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 174
  1. Assistance With Code Which Is Causing Excel To Close (10 replies)
  2. [SOLVED:] Combined multi columns values in one column separated by coma (10 replies)
  3. Automatically mapping and collating data into a new workbook using Excel VBA (4 replies)
  4. [SOLVED:] Copy&paste only if live value has changed from previous loop (7 replies)
  5. [SOLVED:] Macro to insert rows based on cell value (2 replies)
  6. Macro to Separate Text in a Cell (7 replies)
  7. VBA to copy random record from a range (1 replies)
  8. Can an Excel Macro count categories in Outlook 2007 from a shared mailbox? (1 replies)
  9. [SOLVED:] Changing the code from sheet to whole workbook (22 replies)
  10. Help with coding (Macro) (2 replies)
  11. Select Non Continuous Range (7 replies)
  12. Userform macro to update data in specific range (3 replies)
  13. [SOLVED:] Delete all VBA Modules - Except a Few (9 replies)
  14. How to compare data in a spreadsheet (6 replies)
  15. Excel vba - Match Data (8 replies)
  16. [SOLVED:] Macro to paste Approval Data from Row 2 and Reject Data from Row 20 on sheet2 (9 replies)
  17. [SOLVED:] Looping test bed for 3 variables (15 replies)
  18. copy custom tablestyle into new workbook (7 replies)
  19. Edit MS Access data using Excel (1 replies)
  20. [SOLVED:] WorksheetFunction.Sum not working (2 replies)
  21. VBA loop to replace 5k+ array formulas and circular referencing (3 replies)
  22. [SOLVED:] Userform Label Class - Reference Worksheet Cells Range - Run Macros Event Click (8 replies)
  23. [SOLVED:] Check For Existing File and Create New if Not Existing (7 replies)
  24. [SOLVED:] VBA unable to set CF for second range (5 replies)
  25. [SOLVED:] Quick question about Listboxes (2 replies)
  26. [SOLVED:] Simpson's Rule in VBA (14 replies)
  27. Creating a pivot table (1 replies)
  28. Application-Defined Error: 1004 (4 replies)
  29. Different print. (6 replies)
  30. VBA to write to CSV in certain way (9 replies)
  31. Fill multiple comboboxes from same range variable (1 replies)
  32. Deleting and Adding new Chart Using VBA (13 replies)
  33. [SOLVED:] Application.OnTime loop keeps falling out (3 replies)
  34. New Worksheet from listbox name! (27 replies)
  35. Dataset Help (2 replies)
  36. Avoid duplicate entries (16 replies)
  37. Creating new sheets based on date and other criteria from sheet 1 and 2 (10 replies)
  38. Export from Excel to PPT then Apply Custom Slide Layouts created in SlideMaster (8 replies)
  39. Find bottom right cell, and then highlight bottom row (6 replies)
  40. Range Values (7 replies)
  41. Macro to attach Worksheet to a new E-Mail in Lotus Notes as PDF (0 replies)
  42. Loop to match headers on seperatesheets, copy data below, return and paste in header (9 replies)
  43. [SOLVED:] Copy Paste Shapes to Different Worksheets Loop (2 replies)
  44. [SOLVED:] If a word in a cell in col A matches the name of a worksheet, move row to that sheet (14 replies)
  45. [SOLVED:] Assistance for code pasting data into few columns and leaving few columns blank (12 replies)
  46. Lock selected range except for current week (12 replies)
  47. [SOLVED:] Split the row to column (13 replies)
  48. Click on a blank cell and have text appear in another cell (16 replies)
  49. Index Match Formula to VBA (1 replies)
  50. Using VBA to Autofit Visible Rows (1 replies)
  51. [SOLVED:] Paste only Values from sheet 1 that are not in Sheet 2 into sheet 3 (2 replies)
  52. [SOLVED:] Macro to upload data from a file into a summary file (7 replies)
  53. [SOLVED:] VBA Script to extract MS Word document to Excel (5 replies)
  54. [SOLVED:] Is it possible to add a mouseover tooltip to a cell? (4 replies)
  55. Range with Table VBA? (6 replies)
  56. Formula to change cell color based on if it is within two dates (1 replies)
  57. Force SaveAs for this macro only (5 replies)
  58. Code won't paste into excel table, always outside it? (20 replies)
  59. Loop through files in order of date created (1 replies)
  60. Decision tree with VBA (3 replies)
  61. [SOLVED:] Graphics with multipage form (3 replies)
  62. [SLEEPER:] Can I disable Excel 2013 Start up screen using VBA? (3 replies)
  63. Hide Rows in VBA (1 replies)
  64. [SOLVED:] copied userform error (3 replies)
  65. [SOLVED:] Clean Up (7 replies)
  66. [SOLVED:] Circle Invalid Data (14 replies)
  67. VBA to sort horizontal rows Help (7 replies)
  68. [SOLVED:] enter choosen OptionButtons caption to cell (4 replies)
  69. Macro to refresh only sometimes working? (11 replies)
  70. Stringing a bunch of Subs together creates an error But running separately does not (16 replies)
  71. Excel application crashes on ImageSearchDLL without any error. (0 replies)
  72. vba to extract selected subfolder name and file names (1 replies)
  73. [SOLVED:] VBA code to search for online data and import into excel (8 replies)
  74. How to enable user name and password in remote desktop (0 replies)
  75. Give permission to users to change data in Excel using VBA code [VBA] (1 replies)
  76. Send email via Lotus Notes by clicking a button (0 replies)
  77. help to fill the table (3 replies)
  78. [SOLVED:] Issue with getting last member from an array (5 replies)
  79. =IF(J2=B2,"Match","") ??? (7 replies)
  80. If then, Go To Next Sub using a filtered column in VBA (4 replies)
  81. [SOLVED:] If column F is not empty merge data with column C (2 replies)
  82. [SOLVED:] Looping Advanced Filter specific to current worksheet (9 replies)
  83. Copy Sheet - Change Name with a twist. (3 replies)
  84. How to Separate One Long Column of Data into Separate Columns (4 replies)
  85. Macro to Copy and Paste from Adobe Reader to Excel (0 replies)
  86. [SOLVED:] Macro to only allow data to be copy pasted based on data validation criteria (8 replies)
  87. IF statement for pasting entries into another sheet (3 replies)
  88. Excel VBA Double Click or Hyperlink That Filters For Value In Another Workbook? (7 replies)
  89. [SOLVED:] Textbox Loop (6 replies)
  90. [SOLVED:] Delete filtered rows - 2 conditions (1 replies)
  91. ENABLE COMMENTS BUT PROTECTING OBJECTS (3 replies)
  92. [SOLVED:] Shift column from row 3 to left (6 replies)
  93. [SOLVED:] Copy Data based on cell value (3 replies)
  94. [SOLVED:] need help please creating a quick VBA solution for auto filling a dynamic range (3 replies)
  95. Combine rows with duplicate values into columns (2 replies)
  96. Elegant Way to Copy Cells from one Sheet to Another - Value only (7 replies)
  97. Get child ID from parent ID (0 replies)
  98. Way to reference a number in a cell (2 replies)
  99. [SOLVED:] Directory mapping macro - need more robust code (3 replies)
  100. Run Time Errror 91 when trying to find value (9 replies)
  101. [SOLVED:] Delete filter outcome (3 replies)
  102. using array to add 1 hour to column A (11 replies)
  103. [SOLVED:] Displaying numbers in fractions, not decimal (when concatenating) (6 replies)
  104. Using VBA to Copy Multiple Workbook Filenames into their Workbooks (6 replies)
  105. [SOLVED:] VBA Code Required (2 replies)
  106. Formula getting a cell's data from another worksheet. (4 replies)
  107. Runtime error 13 : Excel vba pivot - please help (1 replies)
  108. Help with excel and word. Sounds easy, but its not. (5 replies)
  109. if unique of column A b c then count ifs (2 replies)
  110. [SOLVED:] Insert row & total other columns (11 replies)
  111. [SOLVED:] Aligning two tables (16 replies)
  112. [SOLVED:] VBA filter (3 replies)
  113. [SOLVED:] Excel/Word/Access (2 replies)
  114. [SOLVED:] Need to change code in bottom line (4 replies)
  115. Need macro that creates new rows and copies matching info from sheet 1 to Sheet 2 (1 replies)
  116. Search and copy macro with search criteria (11 replies)
  117. [SOLVED:] Need some very basic help (3 replies)
  118. [SOLVED:] VBA - Filename Checker? (1 replies)
  119. [SOLVED:] VBA Array Function - Return Array from Range without Blanks (10 replies)
  120. Filter A Range And Chart It (10 replies)
  121. month end variance analysis (29 replies)
  122. [SOLVED:] Dynamically Copy and Paste (4 replies)
  123. [SOLVED:] VBA loop to do multiple cut, transpose pastes within a loop, then repeat. (8 replies)
  124. Excel Search Function (10 replies)
  125. [SOLVED:] Require total in column B of positive & negative values (35 replies)
  126. [SOLVED:] Date Problem showing as 42463 ? (5 replies)
  127. HELP!!! Need a VBA code to get a table from a site (9 replies)
  128. [SOLVED:] Currentregion and autofilter Help (4 replies)
  129. ComboBox lag (38 replies)
  130. Microsoft Dynamics AX (1 replies)
  131. [SOLVED:] Create list of files in a folder and link to them in Excel (2 replies)
  132. 90% there - Maybe paste as picture instead to esure cond format? (2 replies)
  133. VBA Find and Replace from Excel Range (2 replies)
  134. Help With Recursive Formula (17 replies)
  135. VBA -- Call Function Not Running Macros Properly (3 replies)
  136. Skip first sheet in For Each loop? (3 replies)
  137. [SOLVED:] Schedule code to run at a set time and then at intervals thereafter (25 replies)
  138. [SOLVED:] Copy data from excel and paste it in to a word template at different places (4 replies)
  139. [SOLVED:] Check if activecell is in a column with date in the header in any table (4 replies)
  140. [SOLVED:] Move files & folders from one location to another from excel (9 replies)
  141. Help with Data in Column A and Shift... (1 replies)
  142. VBA to trigger input box when criteria in data found (5 replies)
  143. [SOLVED:] File copy wont copy to the right folder. (6 replies)
  144. Lotus Notes - VBA (1 replies)
  145. [SOLVED:] Excel Margins (11 replies)
  146. VLOOKUP formula with subtotals (2 replies)
  147. [SOLVED:] Saving filename exists (6 replies)
  148. [SOLVED:] Using wildcards to filter list - help (7 replies)
  149. [SLEEPER:] Run-time Error '1004' - Method 'Open' of object 'Workbooks' failed (6 replies)
  150. [SOLVED:] Trying to get a range of cells to show up in my Combo Box (11 replies)
  151. [SOLVED:] Excel 2013>VBA>PageSetup>User Defined Formula>Interference (6 replies)
  152. [SOLVED:] Trying to name ranges over a number of columns (15 replies)
  153. [SOLVED:] Copy complete folder to another folder (7 replies)
  154. Generate 3 sets combinations, which 3 sets sum match: to request target sum (5 replies)
  155. [SOLVED:] Do While Method to append data (7 replies)
  156. Using Vlookup to set ranges for Loop, not sure how to integrate it. (8 replies)
  157. [SOLVED:] Excel 2013>VBA>Function>Average Visible Cells Horizontally (1 replies)
  158. Conditional Formatting not pasting correctly with macro (1 replies)
  159. [SLEEPER:] Fastest code in consolidating columns with different headers (7 replies)
  160. [SOLVED:] VBA Loop - If Cell is not empty then.... (6 replies)
  161. Display Data from Sheet (1 replies)
  162. [SOLVED:] Assigning values from a table (12 replies)
  163. Macro for copy & paste data from worksheets if path of file changes (1 replies)
  164. [SOLVED:] Generate 5/50 lottery combination with selected odd sum or by even sum!! (14 replies)
  165. excel 2016 splitting datasets creating new separate sheets (2 replies)
  166. VBA code to prompt user to select file folder but still keep the file name... (2 replies)
  167. [SOLVED:] Excel 2013>VBA>Function>Sum Visible Columns (9 replies)
  168. Enabling Content in access db with Excel VBA (0 replies)
  169. Excel Userform Listbox VBA Help (10 replies)
  170. [SOLVED:] How to replace a path in the code by a variable? (1 replies)
  171. Setting a range object & applying table style (9 replies)
  172. Excel 2013 VBA Import Dynamic Range from other Workbook (1 replies)
  173. (VBA) error adding Title and Subtitle to PowerPoint Slide (2 replies)
  174. Count number of mondays (21 replies)
  175. Count texts in two colums and if no match write data (1 replies)
  176. Adjust placement of copy paste to suit last row of previous paste (16 replies)
  177. [SOLVED:] Loop through combinations and add only Even & Odd numbers together within each. (5 replies)
  178. [SLEEPER:] Counting rows in clipboard (4 replies)
  179. [SOLVED:] Apply different format to each column of selection (4 replies)
  180. [SOLVED:] How do I have a cell value displayed on my user form? (12 replies)
  181. Help with #Value! errors (4 replies)
  182. [SOLVED:] Loop through URLs, save source (2 replies)
  183. [SOLVED:] How to connect to a RECORDSET (13 replies)
  184. VBA to collect data from Pivot (0 replies)
  185. VBA: adjusting pivot table per macro (0 replies)
  186. MATCH VALUE FROM TAB2 and UPDATE TAB1-CONDITIONAL (2 replies)
  187. Copy Multiple sheet as SaveAs (1 replies)
  188. SUM of Values by Region and District (1 replies)
  189. Put Excel image to PowerPoint in specific location? (2 replies)
  190. Different references for same formula (more complicated than it sounds) (8 replies)
  191. [SOLVED:] Help Understanding Code (5 replies)
  192. [SLEEPER:] Merging PDFs and Allowing for Filling of Adobe Fields (8 replies)
  193. VBA Cloudera Hadoop connection (1 replies)
  194. [SOLVED:] pulling data from a csv file based on specific dates (4 replies)
  195. VBA (3 replies)
  196. Compares different rectangular areas and highlights equal values (1 replies)
  197. [SOLVED:] Goal Seek without Cell Reference (18 replies)
  198. [SOLVED:] Clear activex listbox selection (5 replies)
  199. [SOLVED:] Excel Book Recommendations (2 replies)
  200. What Do You Think About This? (5 replies)
  201. Help -needed call named range based on cell value (5 replies)
  202. Directing SendKeys to the Correct Application (8 replies)
  203. Order Assignment Problem (2 replies)
  204. [SLEEPER:] VBA to Add 3 Aligned Footers with Custom Formatting and Text (38 replies)
  205. [SOLVED:] Empty Row Deletion (2 replies)
  206. Values lookup in two different tables (2 replies)
  207. [SOLVED:] If range contans "0", mark as incomplete (2 replies)
  208. Combining parts of 3 workbooks (6 replies)
  209. Embedded HTML Image Issues (0 replies)
  210. [SOLVED:] Several If statements inside For Loop (2 replies)
  211. [SOLVED:] What is wrong with my VBA code? (20 replies)
  212. Using Range.Find to search another Open Workbook (1 replies)
  213. Is it possible at all? (2 replies)
  214. ODBC connection if not on users PC (0 replies)
  215. Copy and Paste based on cell value (3 replies)
  216. hide rows based on highlighted cell in column (6 replies)
  217. [SOLVED:] Error when using variable when connecting to SQL from Excel (3 replies)
  218. VBA wont run unless through the editor (6 replies)
  219. vba help (1 replies)
  220. Macro wont work with a cell which is updateing by formular (16 replies)
  221. Intermittent errors after running macro varying number of times (0 replies)
  222. VBA to Search both Email subject and/or Email Body in Outlook (3 replies)
  223. [SOLVED:] Preserve exact formula, monthly analysis for full year (1 replies)
  224. [SOLVED:] Excel Loop WITH Function (2 replies)
  225. [SOLVED:] Vba find and replace with loop (2 replies)
  226. VBA - Auto Select Sheet, Save & Close after 1 hour (7 replies)
  227. [SOLVED:] match delete vba (3 replies)
  228. [SOLVED:] Clear multi - select Listbox (21 replies)
  229. Remove string in text files (5 replies)
  230. [SOLVED:] Help needed with VBA to auto insert pic into comment (10 replies)
  231. Spreadsheet Consolidation based on specific path (6 replies)
  232. [SOLVED:] Types inside a Type (14 replies)
  233. Pivot find and replace (3 replies)
  234. Save as Types (3 replies)
  235. Textfile loop to find/replace characters (1 replies)
  236. [SOLVED:] Easy If-Than code for comparison of multiple values doesn't return correct value (2 replies)
  237. Lable the last know person to entra data to a cell from a list of names, populate dat (0 replies)
  238. [SOLVED:] Using Userform with Date Picker to Select Data Range in Excel (10 replies)
  239. Auto Data Display by Scanning. Please help (0 replies)
  240. VBC Excel to find latest creation date zip within folder, then open CSV file embedded (18 replies)
  241. IE WEBSITE FILE UPLOAD (9 replies)
  242. VBA to Find & Fill a cell based on row & column headers? (0 replies)
  243. VBA macro to hide rows based on cell value (6 replies)
  244. [SOLVED:] Macro for copy/paste values for only that row where the change is made (3 replies)
  245. Hyperlink from a cell in another sheet. Not quite working for me. (2 replies)
  246. Creating indivisual diaries from master rota (13 replies)
  247. [SOLVED:] Can this Conditional Formatting Code be simplified (7 replies)
  248. A day longer than 24 hours (1 replies)
  249. [SOLVED:] vba to loop through multiple worksheets and paste specific data based on a date (4 replies)
  250. [SOLVED:] Creating Sheets from Cell Value IF Only! (2 replies)