Log in

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 163 164 165 166 167 168 169 170 171 172 173
  1. How do i select a table range in VBA (3 replies)
  2. [SOLVED:] Problem with Macro (2 replies)
  3. Macro to copy the 0 number (8 replies)
  4. Consolidate and remove duplicate (3 replies)
  5. Data Validation / Indirect help (0 replies)
  6. Import Multiple Text Files from a folder to multiple worksheets (6 replies)
  7. [SOLVED:] Script to desseminate broker statement into trade journaling software (11 replies)
  8. [SOLVED:] Change Layout of Column chart (1 replies)
  9. Transferring Data Between Sheets (Excel VBA) (2 replies)
  10. If first conditions is NOK else go to second condition (4 replies)
  11. [SOLVED:] Need help restructuring code tohighlight numerical data w/o special characters please (12 replies)
  12. VBA code to apply to whole workbook (1 replies)
  13. vba to append data by sheets name (6 replies)
  14. [SOLVED:] Toggle Visibility of the Drop Down of A Specified Table Column (10 replies)
  15. Help with workbook source and textbox value (5 replies)
  16. Help with Reusing file name (0 replies)
  17. [SOLVED:] Need Help in contructing a Macro the returns frequ. of searched data in chart,please! (8 replies)
  18. Open Workbook when the workbook name is combination of cells (3 replies)
  19. How to sort numbers and strings at once? (22 replies)
  20. [SOLVED:] Run Time Error when I click on a button twice (11 replies)
  21. [VBA] Query an Outlook Distribution List from Excel (0 replies)
  22. [SOLVED:] VBA to copy row if cells contain value (9 replies)
  23. move email from a frolder to different folder from Desktop (0 replies)
  24. [SOLVED:] Sending e-mail from Excel with Outlook behaving badly (2 replies)
  25. VBA to auto filter based on 4 criterias (2 replies)
  26. VBA to autofilter between dates in one column based on text value in another cell (1 replies)
  27. Replace Multiple Carriage Returns with Single Carriage Returns (9 replies)
  28. [SOLVED:] Excel 2013>OFFSET>Count visible columns in a row that are >0 (3 replies)
  29. [SOLVED:] Problems with hidden rows (6 replies)
  30. [SOLVED:] How do I create a macro that allows me to show and hide rows with only one button? (2 replies)
  31. [SOLVED:] VBA :FORMAT AS TABLE BASED ON ENTERED DATA (5 replies)
  32. [SOLVED:] VBA to open file with date and partial name (13 replies)
  33. Macro to automatically paste the selected column into another sheet (23 replies)
  34. [SOLVED:] need help constructing a vba macro by using a key chart to reanslate number combin to (8 replies)
  35. [SOLVED:] Save Workbook As .txt File With Delimiter (10 replies)
  36. [SOLVED:] Help, i need to create a command button for saving selection as txt file (4 replies)
  37. [SOLVED:] Need help restructuring or recreating VBA code Please! (23 replies)
  38. Copy a range of cells (9 replies)
  39. [SOLVED:] Copying multiple sheets with varying numbers of rows to one sheet. (8 replies)
  40. [SOLVED:] Need help with constructing a macro that counts dates as one day. (6 replies)
  41. [SOLVED:] Issue consolidating data to another worksheet (3 replies)
  42. Select range on Row until last empty cell (4 replies)
  43. Macro help to copy from Excel into email without duplicating info (1 replies)
  44. [SOLVED:] VBA & OLAP Pivot:Code to set report filter pvt field with items from another pvt tabl (6 replies)
  45. Compile error (8 replies)
  46. Copy Data from One Sheet to another Specific sheet (16 replies)
  47. Open outlook new email and attach most recent file from directory (9 replies)
  48. Dynamic gradient chart background (1 replies)
  49. [SOLVED:] Custom Formatting (7 replies)
  50. Help with Macros for Conditional display (3 replies)
  51. [SOLVED:] Exit Do after search item no longer found in a range (3 replies)
  52. Need help wth a Macro (9 replies)
  53. Split data based on criteria (2 replies)
  54. [SOLVED:] Need help constructing VBA code to enter selected letter into cell after data already (3 replies)
  55. [SOLVED:] VBA multiple Goal Seek depending and selection (2 replies)
  56. [SOLVED:] Deleting rows based on values of cells in TWO different columns (2 replies)
  57. [SOLVED:] Moving Data around in a Row. (2 replies)
  58. [SOLVED:] Windows activate + Todays date (2 replies)
  59. Filter large files without opening (10 replies)
  60. [SOLVED:] Find and open latest csv file in given directory (23 replies)
  61. Find external links within code (0 replies)
  62. Navigation With Firefox (0 replies)
  63. [SOLVED:] Populating specific cell with data from a userform when an option button is selected (3 replies)
  64. Drill Down Pivot Same Page (0 replies)
  65. [SOLVED:] Linking to cells in another sheet with VBA - Can my code be improved? (11 replies)
  66. Calculate distance between point and rectangle (30 replies)
  67. Transpose Horizontal Table (8 replies)
  68. Macro to check value, open file, copy value, loop through range. (4 replies)
  69. [SOLVED:] Addressing problem in loop (11 replies)
  70. [SOLVED:] Need help with constructing a vba code, please! (7 replies)
  71. Check Points within Rectangles (22 replies)
  72. Email Sending Userform problem (12 replies)
  73. Macro to Find Cells by Color and Copy to Different Worksheet (1 replies)
  74. Nested IF Statements - Please Help to Resolve (2 replies)
  75. [SOLVED:] VBA Excel clear cells causes error 400 (2 replies)
  76. Excel to ask what activity I am doing every hour (1 replies)
  77. Excel vba to open ie ribbon (1 replies)
  78. Consolidating worksheets into one and paste special (3 replies)
  79. [SOLVED:] VBA Excel - Collections unexpected answer (10 replies)
  80. Excel 2013 -> need help having two macro's in a workbook - already have one running (3 replies)
  81. [SOLVED:] Excel 2013>VBA>Sheets>Array (5 replies)
  82. [SOLVED:] Excel 2013>VBA>Clipboard (3 replies)
  83. Custom VBA Column to Row Insert and Transpose (4 replies)
  84. [SOLVED:] How do I lock the contents of a moving cell? (2 replies)
  85. POP - UP Window on Excel file start (7 replies)
  86. Create a numbered list from string (6 replies)
  87. Writing userform List Box entries into a worksheet (0 replies)
  88. [SOLVED:] Format only selected text on textbox userform (7 replies)
  89. Textbox macro to update data from 2 different rows on sheet2 (0 replies)
  90. VBA Excel increase invoice number and save (need help with code) Excel 2003 (6 replies)
  91. Pls help *Urgent* VBA Macro Problem (1 replies)
  92. Assistance With Code Which Is Causing Excel To Close (10 replies)
  93. [SOLVED:] Combined multi columns values in one column separated by coma (10 replies)
  94. Automatically mapping and collating data into a new workbook using Excel VBA (4 replies)
  95. [SOLVED:] Copy&paste only if live value has changed from previous loop (7 replies)
  96. [SOLVED:] Macro to insert rows based on cell value (2 replies)
  97. Macro to Separate Text in a Cell (7 replies)
  98. VBA to copy random record from a range (1 replies)
  99. Can an Excel Macro count categories in Outlook 2007 from a shared mailbox? (1 replies)
  100. [SOLVED:] Changing the code from sheet to whole workbook (22 replies)
  101. Help with coding (Macro) (2 replies)
  102. Select Non Continuous Range (7 replies)
  103. Userform macro to update data in specific range (3 replies)
  104. [SOLVED:] Delete all VBA Modules - Except a Few (9 replies)
  105. How to compare data in a spreadsheet (6 replies)
  106. Excel vba - Match Data (8 replies)
  107. [SOLVED:] Macro to paste Approval Data from Row 2 and Reject Data from Row 20 on sheet2 (9 replies)
  108. [SOLVED:] Looping test bed for 3 variables (15 replies)
  109. copy custom tablestyle into new workbook (7 replies)
  110. Edit MS Access data using Excel (1 replies)
  111. [SOLVED:] WorksheetFunction.Sum not working (2 replies)
  112. VBA loop to replace 5k+ array formulas and circular referencing (3 replies)
  113. [SOLVED:] Userform Label Class - Reference Worksheet Cells Range - Run Macros Event Click (8 replies)
  114. [SOLVED:] Check For Existing File and Create New if Not Existing (7 replies)
  115. [SOLVED:] VBA unable to set CF for second range (5 replies)
  116. [SOLVED:] Quick question about Listboxes (2 replies)
  117. [SOLVED:] Simpson's Rule in VBA (14 replies)
  118. Creating a pivot table (1 replies)
  119. Application-Defined Error: 1004 (4 replies)
  120. Different print. (6 replies)
  121. VBA to write to CSV in certain way (9 replies)
  122. Fill multiple comboboxes from same range variable (1 replies)
  123. Deleting and Adding new Chart Using VBA (13 replies)
  124. [SOLVED:] Application.OnTime loop keeps falling out (3 replies)
  125. New Worksheet from listbox name! (27 replies)
  126. Dataset Help (2 replies)
  127. Avoid duplicate entries (16 replies)
  128. Creating new sheets based on date and other criteria from sheet 1 and 2 (10 replies)
  129. Export from Excel to PPT then Apply Custom Slide Layouts created in SlideMaster (8 replies)
  130. Find bottom right cell, and then highlight bottom row (6 replies)
  131. Range Values (7 replies)
  132. Macro to attach Worksheet to a new E-Mail in Lotus Notes as PDF (0 replies)
  133. Loop to match headers on seperatesheets, copy data below, return and paste in header (9 replies)
  134. [SOLVED:] Copy Paste Shapes to Different Worksheets Loop (2 replies)
  135. [SOLVED:] If a word in a cell in col A matches the name of a worksheet, move row to that sheet (14 replies)
  136. [SOLVED:] Assistance for code pasting data into few columns and leaving few columns blank (12 replies)
  137. Lock selected range except for current week (12 replies)
  138. [SOLVED:] Split the row to column (13 replies)
  139. Click on a blank cell and have text appear in another cell (16 replies)
  140. Index Match Formula to VBA (1 replies)
  141. Using VBA to Autofit Visible Rows (1 replies)
  142. [SOLVED:] Paste only Values from sheet 1 that are not in Sheet 2 into sheet 3 (2 replies)
  143. [SOLVED:] Macro to upload data from a file into a summary file (7 replies)
  144. [SOLVED:] VBA Script to extract MS Word document to Excel (5 replies)
  145. [SOLVED:] Is it possible to add a mouseover tooltip to a cell? (4 replies)
  146. Range with Table VBA? (6 replies)
  147. Formula to change cell color based on if it is within two dates (1 replies)
  148. Force SaveAs for this macro only (5 replies)
  149. Code won't paste into excel table, always outside it? (20 replies)
  150. Loop through files in order of date created (1 replies)
  151. Decision tree with VBA (3 replies)
  152. [SOLVED:] Graphics with multipage form (3 replies)
  153. Can I disable Excel 2013 Start up screen using VBA? (3 replies)
  154. Hide Rows in VBA (1 replies)
  155. [SOLVED:] copied userform error (3 replies)
  156. [SOLVED:] Clean Up (7 replies)
  157. [SOLVED:] Circle Invalid Data (14 replies)
  158. VBA to sort horizontal rows Help (7 replies)
  159. [SOLVED:] enter choosen OptionButtons caption to cell (4 replies)
  160. Macro to refresh only sometimes working? (11 replies)
  161. Stringing a bunch of Subs together creates an error But running separately does not (16 replies)
  162. Excel application crashes on ImageSearchDLL without any error. (0 replies)
  163. vba to extract selected subfolder name and file names (1 replies)
  164. [SOLVED:] VBA code to search for online data and import into excel (8 replies)
  165. How to enable user name and password in remote desktop (0 replies)
  166. Give permission to users to change data in Excel using VBA code [VBA] (1 replies)
  167. Send email via Lotus Notes by clicking a button (0 replies)
  168. help to fill the table (3 replies)
  169. [SOLVED:] Issue with getting last member from an array (5 replies)
  170. =IF(J2=B2,"Match","") ??? (7 replies)
  171. If then, Go To Next Sub using a filtered column in VBA (4 replies)
  172. [SOLVED:] If column F is not empty merge data with column C (2 replies)
  173. [SOLVED:] Looping Advanced Filter specific to current worksheet (9 replies)
  174. Copy Sheet - Change Name with a twist. (3 replies)
  175. How to Separate One Long Column of Data into Separate Columns (4 replies)
  176. Macro to Copy and Paste from Adobe Reader to Excel (0 replies)
  177. [SOLVED:] Macro to only allow data to be copy pasted based on data validation criteria (8 replies)
  178. IF statement for pasting entries into another sheet (3 replies)
  179. Excel VBA Double Click or Hyperlink That Filters For Value In Another Workbook? (7 replies)
  180. [SOLVED:] Textbox Loop (6 replies)
  181. [SOLVED:] Delete filtered rows - 2 conditions (1 replies)
  182. ENABLE COMMENTS BUT PROTECTING OBJECTS (3 replies)
  183. [SOLVED:] Shift column from row 3 to left (6 replies)
  184. [SOLVED:] Copy Data based on cell value (3 replies)
  185. [SOLVED:] need help please creating a quick VBA solution for auto filling a dynamic range (3 replies)
  186. Combine rows with duplicate values into columns (2 replies)
  187. Elegant Way to Copy Cells from one Sheet to Another - Value only (7 replies)
  188. Get child ID from parent ID (0 replies)
  189. Way to reference a number in a cell (2 replies)
  190. [SOLVED:] Directory mapping macro - need more robust code (3 replies)
  191. Run Time Errror 91 when trying to find value (9 replies)
  192. [SOLVED:] Delete filter outcome (3 replies)
  193. using array to add 1 hour to column A (11 replies)
  194. [SOLVED:] Displaying numbers in fractions, not decimal (when concatenating) (6 replies)
  195. Using VBA to Copy Multiple Workbook Filenames into their Workbooks (6 replies)
  196. [SOLVED:] VBA Code Required (2 replies)
  197. Formula getting a cell's data from another worksheet. (4 replies)
  198. Runtime error 13 : Excel vba pivot - please help (1 replies)
  199. Help with excel and word. Sounds easy, but its not. (5 replies)
  200. if unique of column A b c then count ifs (2 replies)
  201. [SOLVED:] Insert row & total other columns (11 replies)
  202. [SOLVED:] Aligning two tables (16 replies)
  203. [SOLVED:] VBA filter (3 replies)
  204. [SOLVED:] Excel/Word/Access (2 replies)
  205. [SOLVED:] Need to change code in bottom line (4 replies)
  206. Need macro that creates new rows and copies matching info from sheet 1 to Sheet 2 (1 replies)
  207. Search and copy macro with search criteria (11 replies)
  208. [SOLVED:] Need some very basic help (3 replies)
  209. [SOLVED:] VBA - Filename Checker? (1 replies)
  210. [SOLVED:] VBA Array Function - Return Array from Range without Blanks (10 replies)
  211. Filter A Range And Chart It (10 replies)
  212. month end variance analysis (29 replies)
  213. [SOLVED:] Dynamically Copy and Paste (4 replies)
  214. [SOLVED:] VBA loop to do multiple cut, transpose pastes within a loop, then repeat. (8 replies)
  215. Excel Search Function (10 replies)
  216. [SOLVED:] Require total in column B of positive & negative values (35 replies)
  217. [SOLVED:] Date Problem showing as 42463 ? (5 replies)
  218. HELP!!! Need a VBA code to get a table from a site (9 replies)
  219. [SOLVED:] Currentregion and autofilter Help (4 replies)
  220. ComboBox lag (38 replies)
  221. Microsoft Dynamics AX (1 replies)
  222. [SOLVED:] Create list of files in a folder and link to them in Excel (2 replies)
  223. 90% there - Maybe paste as picture instead to esure cond format? (2 replies)
  224. VBA Find and Replace from Excel Range (2 replies)
  225. Help With Recursive Formula (17 replies)
  226. VBA -- Call Function Not Running Macros Properly (3 replies)
  227. Skip first sheet in For Each loop? (3 replies)
  228. [SOLVED:] Schedule code to run at a set time and then at intervals thereafter (25 replies)
  229. [SOLVED:] Copy data from excel and paste it in to a word template at different places (4 replies)
  230. [SOLVED:] Check if activecell is in a column with date in the header in any table (4 replies)
  231. [SOLVED:] Move files & folders from one location to another from excel (9 replies)
  232. Help with Data in Column A and Shift... (1 replies)
  233. VBA to trigger input box when criteria in data found (5 replies)
  234. [SOLVED:] File copy wont copy to the right folder. (6 replies)
  235. Lotus Notes - VBA (1 replies)
  236. [SOLVED:] Excel Margins (11 replies)
  237. VLOOKUP formula with subtotals (2 replies)
  238. [SOLVED:] Saving filename exists (6 replies)
  239. [SOLVED:] Using wildcards to filter list - help (7 replies)
  240. Run-time Error '1004' - Method 'Open' of object 'Workbooks' failed (6 replies)
  241. [SOLVED:] Trying to get a range of cells to show up in my Combo Box (11 replies)
  242. [SOLVED:] Excel 2013>VBA>PageSetup>User Defined Formula>Interference (6 replies)
  243. [SOLVED:] Trying to name ranges over a number of columns (15 replies)
  244. [SOLVED:] Copy complete folder to another folder (7 replies)
  245. Generate 3 sets combinations, which 3 sets sum match: to request target sum (5 replies)
  246. [SOLVED:] Do While Method to append data (7 replies)
  247. Using Vlookup to set ranges for Loop, not sure how to integrate it. (8 replies)
  248. [SOLVED:] Excel 2013>VBA>Function>Average Visible Cells Horizontally (1 replies)
  249. Conditional Formatting not pasting correctly with macro (1 replies)
  250. HELP!!! Fastest code in consolidating columns with different headers (7 replies)