PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 [126] 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162

  1. Macro to copy data from one workbook to another.
  2. [SOLVED] Out of memory for below code
  3. [SOLVED] Wrapper for RtlMoveMemory
  4. [SOLVED] Subtotals several columns
  5. Date Filtering with VBA
  6. Document select, and move
  7. Hide Rows to variable specific criteria
  8. When PrintView button is clicked open the invoice in PDF format
  9. [SOLVED] Insert Picture in Footer
  10. [SOLVED] Get Max value in a multpile term cell reference
  11. User Form Code to Load Text Files
  12. [SOLVED] Copy Data from one sheet to another IF cells are highlighted specific colors.
  13. [SOLVED] Delete rows ONLY IF duplicate value in column A + cell is highlighted Specific Color.
  14. [SOLVED] Count Cells by Color
  15. Maintain index table to show allocated numbers
  16. VBA substitute on Office RT?
  17. Data Picking and placing to appropriate cell
  18. [SOLVED] Clean and Trim Text from Download
  19. Split cell contents
  20. Skipping Over If Statement
  21. xlSheetVeryHidden Does Not Work on Mac?
  22. Trouble with swimming time grading in excel
  23. Need help with creating references from one sheet to another in a more efficient way.
  24. Compare two columns varying in number of rows on different sheets
  25. Excell
  26. [SOLVED] Find Hidden cells in array and enable "Calculate used range" on all non hidden cells
  27. Excel Formula to determine winning teams
  28. Two Sheets Exported to One File
  29. [SOLVED] Pre Typed Text Box Appear After Macro is Executed
  30. Consolidating data
  31. Macro to save a readonly copy of file with todays date
  32. Click in Image with iframe
  33. Ranking and declaring winner and runner up
  34. Workday Friday changed to a Thursday
  35. Delete table rows from different worksheets in excel
  36. Date Data Tracking
  37. Tab behavior in user forms
  38. Macro Inserts Lines, but disturbs referencing cells
  39. run-time error 91
  40. Date Tracking NEW
  41. Is it possible to Insert Array into Excel Table
  42. How do I handle missing XML attributes?
  43. Calculate BOM levels with target price
  44. [SOLVED] Selecting numeric data in range if they start with 2 specified numbers
  45. [SOLVED] Entering a value to a range of cells which are -1 column from cells selected
  46. [SOLVED] Select Cell X, Filter cell Y, if cell Y meets condition Z -> Input into cell X
  47. Excel traversing Array Uses lots of Memory
  48. Excel to Memories
  49. [SOLVED] ADO Query of Excel Table is returning with incorrect Field Type
  50. [SOLVED] Find text in Row and use as criteria for search in column where text is found
  51. vba to terminate Chrome Browser
  52. Run-time error 13 - type mismatch- simple price time series calc not working on array
  53. [SOLVED] Cond Formatting
  54. [SOLVED] code executing too fast?
  55. Export All Pictures in Spreadsheet as Filename in Cell Range
  56. [SOLVED] Coordinate based query and data copy/paste/clear
  57. [SOLVED] Run-time error '1004': Application-defined or object-defined error
  58. Combining duplicates based on several conditions
  59. Date Picker Issue
  60. Problem to calculate target price according to tree levels
  61. [SOLVED] EOF question
  62. COUNTIF (unique values only)
  63. copying Data from multiple tabs of multiple files in master file
  64. Keyboard shortcut to refresh the data in auto-filter column
  65. [SOLVED] Mininum Maximum
  66. If then Else to fill blank cells
  67. Copy & Paste Based on Column Criteria
  68. VBA - Search Loop Help
  69. Code for linking multiple check boxes with If then statements
  70. How to generate Crystal Report (SAP BO BI) using Excel VBA?
  71. AHT Calculation
  72. Identify cell formula changes in VBA
  73. Loop through and ignore hidden rows
  74. VBA - struggling to calc and write StDev data into an array with a For Next loop
  75. Save/Retrieve Image from database using excel vba
  76. Fetching datas from different sheets onto one sheet
  77. Colour visible cells in a loop VBA
  78. [SOLVED] Formula to return value in months in date range match
  79. VBA separate range of dates in cells with duration
  80. Return Color of Individual Characters in Cell
  81. Insert Row with formula on double click & delete last row within a defined Range
  82. Type Mismatch error because macro only applicable to .xls - files and not .csv
  83. How to bypass security warning sending emails from outlook using Excel VBA Code sampl
  84. [SOLVED] Help to modify this lookup function
  85. [SOLVED] Copy only borders of a range to new range
  86. VBA to send Email from other users on shared WB
  87. [SOLVED] New Issue with SaveAs
  88. Amendment (With exception) on the the created vendor macro file
  89. VBA to change cell font if then not working
  90. [SOLVED] PivotTable copy certain sections and paste to another sheet
  91. Error 438 in VBA
  92. [SOLVED] Copy Paste Formula in alternate Rows without breaking link
  93. Completing Data / Interpolation
  94. Problem with conditional selection
  95. 3D garph help
  96. Why so hard to get a cell's formula dependents/precedents
  97. VBA Sharepoint Check out & Check in - Please help a newbie!!
  98. VBA - Hiding rows in worksheets with comments
  99. Filter/Sort looping issue
  100. [SOLVED] Add "Print" button to my msg box
  101. Exit MsgBox If MsgBoxResult = Cancel
  102. VBA_ How to download .xls file (which is created from javascript) from website
  103. [SOLVED] Lock sheet-macro
  104. Sine using Taylor Series
  105. [SOLVED] VBA to select first cell with data in a row
  106. Double numbers
  107. Double Click to insert Row
  108. Index function skips value in table.
  109. [SOLVED] Tricky COUNT(IF(S)) problem
  110. [SOLVED] VBA creating, activating command buttons
  111. Mail Merge VBA + Excel + Word!?
  112. VBA help request: copy a range, add new data within the range and paste beneath data
  113. Get browser to update after changing drop down box value
  114. Menu shortcuts
  115. error msg box
  116. Loop Case Statement
  117. [SOLVED] Time Format in a cell
  118. Adding Columns into Excel with a Macro
  119. [SOLVED] VBA - Random Comparison Columns
  120. Finding the greater text value from several cells
  121. VBA Excel: How to create file which will be crashed on precise date
  122. Userform or InputBox appearing on screen connected via network
  123. can't find my mistake to calculate target price
  124. [SOLVED] VBA Excel: Error 424 in "For Each" caused by FireEvent ("onchange")
  125. ByVal vs ByRef Question
  126. Convert excel data to fixed width text file
  127. [SOLVED] VBA CheckBox issues
  128. [SOLVED] Delete Rows Based ColA (multiple criteria)-Delete Rows based ColB (multiple criteria)
  129. [SOLVED] VBA check box used to change color of a cell not working
  130. [SOLVED] Extracting Last name, First Name and sometimes Middle Name
  131. click a button in a dropdown menu on webpage to download sth using vba
  132. Workbook open fail problem
  133. [SOLVED] clear contents of adjacent cell(s) on change
  134. VBA macro to create pdf and folder based on cell values
  135. [SOLVED] Macro that to transfer information sheets by product
  136. right-Click on image
  137. [SOLVED] Array
  138. [SOLVED] excel functions regarding text entries
  139. IF Statement that will assign account types based on "account number"
  140. [SOLVED] VBA code to initiate search button on website
  141. Get all data from word table into excel
  142. [SOLVED] Formula help please
  143. Insert file name and loop
  144. Looking to create a Outlook Task. Need VBA Template
  145. Select Case Statement Problem
  146. Remove line breaks
  147. Assign each trade a Trade ID
  148. [SOLVED] How to make Excel file only open in Excel 2007
  149. [SOLVED] I'm having trouble removing some shapes from my worksheet
  150. Using VBA to paste an Excel sheet as an image and keep conditional formatting
  151. [SOLVED] VBA code to quickly change dates and times in comments
  152. Copy paste filtered range with criteria using VBA
  153. vba for when data is changed to remove item from data validation list in another wksh
  154. Error 13: Type Mismatch Row Limit Restriction?
  155. Insert Copied does not work when selecting Visible Cells Only
  156. [SOLVED] COUNTIF - Alternate to count values in every third cell rather than full range.
  157. Duplicate Entire Row where Comma Exists
  158. HTTTP Post Request Help Needed
  159. Tracking tasks.
  160. [SOLVED] Adding Sheets from array
  161. Toggle autofilter while sheet is protected
  162. VDA structure creating
  163. Saving Using Path Definition
  164. vba to send email at the end of the day.
  165. Get container and/or parent of dynamically created control (checkbox)
  166. Paste Excel Picture from Cell in to Word - Error 438
  167. Export Data from another program to excel
  168. Match duplicates and copy updated cells from one worksheet to another
  169. [SOLVED] Merging PDFs Based on Checklist Selection in Excel
  170. Transferring Data from one Workbook to Another based on whether or not the cell is em
  171. Macro to Create Multiple Pivot Tables in Multiple Sheets with Dynamic Data Filter
  172. [SOLVED] Avoiding run time error '424': object required
  173. [SOLVED] How to add table in the outlook via excel.
  174. [SOLVED] Excel 2010 Weekly Update Breaks Excel
  175. [SOLVED] Custom Ribbon XML - Create a Dropdown with Additional SubMenu
  176. [SOLVED] Shape selection based on user input
  177. Adding a common value to a column using VBA
  178. [SOLVED] ActiveX button VBA references contents of button sheet even after activating new one
  179. [SOLVED] Little help with VBA please and programming search in VBA
  180. [SOLVED] Paste copied info one row down daily
  181. Create Check Box before running Macros
  182. [SOLVED] Colours based on drop down
  183. [SOLVED] Excel VBA to What If Test
  184. Excel SQL Query
  185. VBA assistance
  186. Excel VBA help! Duplicate orders with same customer ID totals?
  187. [SOLVED] Access array between different modules
  188. Search column for text match, if found add text into row
  189. Consolidating Workbooks
  190. [SOLVED] Copy all text on Sheet2 and paste to the Last unused row on Sheet1
  191. Show Item on special cell when click on each cell on column E
  192. Using ShowDetail Causes Un-Grouping
  193. Date type changing when moving cells from one sheet to another
  194. Which is the best tool to repair Excel?
  195. Shared workbook with specific sheets being read only if in use?
  196. Stop button from moving
  197. [SOLVED] Run-time error '70': Permission denied ->when i run code
  198. [SOLVED] Compare comma separated numbers
  199. VBA to Format Charts
  200. Automatic row addition
  201. Count button clicks and write them to a file or sheet with time and date index
  202. Special Characters
  203. Subtitle problem in embedded WMP control
  204. [SOLVED] Object doesn't support this property or method
  205. Worksheet Sheet ActiveX Controls Command Buttons Stopped Don't Work Working
  206. Run-time error '5' : From Excel Macro to AutoCad
  207. [SOLVED] Sorting by number of character in cell
  208. Running a Database Query
  209. [SOLVED] Types of Data Distributions
  210. [SOLVED] Need Code to copy Data to other sheets on condition
  211. [SOLVED] Operation must use an updateable query
  212. vbCrLf and vbLf
  213. Ifs, ors, and nots
  214. A few questions about DoEvents
  215. [SOLVED] Inserting a Row based on two conditions
  216. [SOLVED] Run-time error 424 issue
  217. VBA Date Match Error
  218. [SOLVED] Copy Table from one Sheet to Another
  219. [SOLVED] Function that finds number of Fridays in a particular interval date
  220. Excel VBA to select first value in Validation list
  221. vba to send appointment from excel to outlook
  222. Runtime Errror 9 Subscript out of range
  223. [SOLVED] Change tab color based on cell contents
  224. How to set 2 condition in VBA
  225. Customize Error bars individually in a dynamic timeline chart
  226. [SOLVED] Problem with Deleting Select Legend Keys
  227. Line intersection - with a difference
  228. [SOLVED] horizantal total
  229. How to add date column in workbook files
  230. DAYS360 in VBA
  231. VBA script to extract/reduce data to certain parameters(columns)
  232. Downlaod URL Data on disk based on criteria
  233. [SOLVED] Copy & Paste Variable Range By Table Header
  234. [SOLVED] Modify Code to Include More Columns
  235. [SOLVED] Copying Row Above Results In Zero Instead of Blank
  236. [SOLVED] Update data fill down dynamically
  237. [SOLVED] Compile Errror: Can't Find Project or Library
  238. [SOLVED] Sum if
  239. VBA for Row Difference
  240. How to use the path of an excel filevariable in a formula?
  241. Combo boxes stopped working
  242. follow hyperlink to location then delete linked file
  243. Use check button enable/disable code lines
  244. [SOLVED] Sort blocks independently
  245. Create sheets using data shown in filter
  246. [SOLVED] Improve Performance of Insert
  247. [SOLVED] Change Cells color based on cell and other cells value.
  248. How to do web scraping from java based website
  249. How to save excel file in CSV with Comma delimited (*.csv)
  250. [SOLVED] Checking cell format