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. Sleeper: How to color code a row if range of columns are blanks (4 replies)
  2. [SOLVED:] How can I fix my autofilter if criteria not met? (4 replies)
  3. Opening URL with Fragment Identifier from VBA Excel (7 replies)
  4. Find Matches for a Range of multiple criteria? (1 replies)
  5. [SOLVED:] Edit Current Selected Cell (3 replies)
  6. [SOLVED:] How to sort a list of numbers and eject one special number of this list? (6 replies)
  7. [SOLVED:] Return value from Custom Ribbon (5 replies)
  8. Finding a non-unique value and take max in another column (1 replies)
  9. How to copy a column from one worksheet to another if the Active sheet is different (4 replies)
  10. [SOLVED:] Compile Error: Expected: line number or label or statement .... (2 replies)
  11. [SOLVED:] Open a Workbook with path (4 replies)
  12. Looking for some help to find "missing" letter groups (30 replies)
  13. auto transfer multiple rows from one excel to another (1 replies)
  14. Cant use match to find cell (date) i have just copied!? (4 replies)
  15. Put comment with IF (3 replies)
  16. [SOLVED:] Random Variables (8 replies)
  17. [SLEEPER:] Find and Replace VBA using Userforms (1 replies)
  18. Alternative for large data reporting (2 replies)
  19. Static Workbook but dynamic sheet - Indirect lookup (3 replies)
  20. [SOLVED:] AutoFilter Previous Months Data (5 replies)
  21. Toggle newly inserted row based on criteria (1 replies)
  22. Inserting pictures (bmps) from Macros into location of current cell (variable cell) (3 replies)
  23. Help with consolidating date on a worksheet from other worksheets (0 replies)
  24. [SOLVED:] loop certain columns (1 replies)
  25. Extract text files from zip files and import contents to Excel (3 replies)
  26. VBA code to copy differing range of cells depending on sheet name (2 replies)
  27. [SOLVED:] use variables in excel 2010 vba with batch file (3 replies)
  28. Cell Value (4 replies)
  29. building an array (1 replies)
  30. [SOLVED:] Problem Macro (0 replies)
  31. VBA for Sorting Table (7 replies)
  32. [SOLVED:] Select/Move Rows to New Sheet Based on Date (5 replies)
  33. VBA Macro a filter that consolidates and displays information in different tables (0 replies)
  34. [SLEEPER:] R-Code to VBA Conversion (3 replies)
  35. [SOLVED:] IF different from blank then (2 replies)
  36. Using an IF and IN statement in VBA (0 replies)
  37. Nurse Scheduling Help (3 replies)
  38. [SOLVED:] Worksheet Change Event has gone AI :o (5 replies)
  39. [SOLVED:] If filtered rows are Yellow then delete else ignore and remove filter (3 replies)
  40. How to use VBA to apply filter to a pivot table (2 replies)
  41. [SOLVED:] Trying to create a PivotTable with VBA, constantly getting an error. (0 replies)
  42. [SOLVED:] Run JavaScript and Get Return (2 replies)
  43. Copy range in row based on criteria and paste to another row based on criteria (3 replies)
  44. Delete columns based off of formula in another cell (2 replies)
  45. [SOLVED:] Pick the fillcolor of a cell (2 replies)
  46. Help on existing macro (4 replies)
  47. [SOLVED:] loop through all public declared variables in a module (38 replies)
  48. New Comment Arrow (5 replies)
  49. Pivot Table: Difference From ... question (7 replies)
  50. Need help on the code i have created for Ping tool on vb script. (5 replies)
  51. Steer me in the right direction? (8 replies)
  52. [SOLVED:] Count Spaces Between Values (2 replies)
  53. Count Cells in Range Containing Specific Value (2 replies)
  54. Transpose from .txt files (1 replies)
  55. macro to Create a Output file based on Input file (2 replies)
  56. [SOLVED:] VBA to ignore login request? (4 replies)
  57. Reverse a matrix on VBA (1 replies)
  58. DISPLAY SUBTOTAL and SUBTOTAL % in PIVOT TABLE (0 replies)
  59. Worksheet Data Input and Data Handling (2 replies)
  60. [SOLVED:] New to VBA, Need help outputting a list of the TextBox names from my 1st project (5 replies)
  61. table filtering and sorting (0 replies)
  62. Get all occurrences of data from text file using VBA (3 replies)
  63. Code to close workbooks (16 replies)
  64. Data validation list for-loop wont go to next (8 replies)
  65. EXCEL VBA - PUSH DATA AND REFRESH (1 replies)
  66. Converting a range to a table and then creating a pivot table through a series of WBs (0 replies)
  67. [SOLVED:] IF Statement in VBA with Offset (7 replies)
  68. [SOLVED:] Delete Columns based on the font colour in row 1 (7 replies)
  69. Search Dir for Workbook and worksheet and add either as required (3 replies)
  70. How to use Excel to upload a file to web (1 replies)
  71. Multiple text file importing (7 replies)
  72. [SOLVED:] VLOOKUP help (7 replies)
  73. [SOLVED:] Listview sort when column header clicked (1 replies)
  74. [SOLVED:] Making Your Own Date Format (20 replies)
  75. Search Outlook attachments for specific content before sending new e-mail (2 replies)
  76. Copy/Paste Function not working properly in Loop (2 replies)
  77. [SOLVED:] Highlight Lowest Value in a column (11 replies)
  78. ★ Copying paragraphs from other documents with interface (3 replies)
  79. My Macro sits and spins (5 replies)
  80. Application.FileSearch substitute in excel 2010 (1 replies)
  81. Batch protect multiple sheets (1 replies)
  82. [SOLVED:] Dynamic Sort Range. How to code (2 replies)
  83. [SOLVED:] Duplicate Entire row if cell value >15 (3 replies)
  84. [SOLVED:] Simplify Code? (13 replies)
  85. Updating Row Information for Pasting Values (4 replies)
  86. [SOLVED:] Is there a Simple Way to code this. (8 replies)
  87. [SOLVED:] Creating a Function parameter pick list (2 replies)
  88. Status Bar Display (13 replies)
  89. [SOLVED:] Populating a Cell Using Value of Another Cell to Lookup the Desired Value (9 replies)
  90. [SOLVED:] Hidden sheet in vba form excel vlookup (5 replies)
  91. Loop through the range to find the duplicates and print the number of occurrences (1 replies)
  92. [SOLVED:] Filter based on 3 OR conditions and cut paste the same on different sheet (3 replies)
  93. [SOLVED:] VBA returns negative value when calculating difference between date/times (7 replies)
  94. Merging one sheet from Multiple Workbooks with Headings (1 replies)
  95. create an id generator and copy data within worksheets (13 replies)
  96. Problems with copying multiple worksheets into one workbook (6 replies)
  97. [SOLVED:] worksheet_change to select a range (3 replies)
  98. VBA TANKER volume HELP (2 replies)
  99. VBA - Vertical organization display on set chart (7 replies)
  100. Referring formulas to next row in spreadsheets (Shapes) (0 replies)
  101. [SOLVED:] Want help with a tricky sorting Macro (31 replies)
  102. VBA Filter problem (2 replies)
  103. [SOLVED:] Protecting Passwords and Workbook expiration date (12 replies)
  104. Help with .Find and .FindNext in VBA (1 replies)
  105. Stepping through cells in a range (2 replies)
  106. Age Calculate from textobx (1 replies)
  107. Change file name & path with formula or macro (2 replies)
  108. [SOLVED:] Pivot Table error - Tabular format (2 replies)
  109. Edit/Delete Data Row (0 replies)
  110. [SOLVED:] Round Robin Triggered by Button Click (5 replies)
  111. [SOLVED:] How to create a Macro Pivot Table where the range changes? (2 replies)
  112. Chart creation basis dropdown value (0 replies)
  113. [SOLVED:] Removing the Zeros from Blank Cells (12 replies)
  114. VBA: Get Range of found cell (13 replies)
  115. Use Find in a loop (2 replies)
  116. Run-time error 402 for Userform (4 replies)
  117. vba to insert vlookup between workbooks (0 replies)
  118. Deleting two buttons with similar names (6 replies)
  119. Dynamic Table Using Reference Cells to Adjust Size (10 replies)
  120. Need formula for this (0 replies)
  121. How to select highlighted cells as dynamic range? (2 replies)
  122. [SOLVED:] VBA-highlight cell(s) in a column range if empty or greater than a value (5 replies)
  123. help to write VBA code for ignoring cells with "0" in them (I'm new to this..) (5 replies)
  124. Recordset B takes longer to copy/paste to worksheet than Recordset A, but is smaller! (0 replies)
  125. Need to replace SUMIFS function with VBA code (2 replies)
  126. HELP VBA code (5 replies)
  127. Formula Conumdrum Is Excel up to it. (2 replies)
  128. List to Labels (6 replies)
  129. [help][Important to learn VBA] export the list of classes from VBA Object libraries (9 replies)
  130. macro to search & copy columns from another workbook (5 replies)
  131. [SOLVED:] Excel VBA User Form ( Need Help here please ) (6 replies)
  132. Open all Zipped files within folder of the xlsm file. (1 replies)
  133. Create button with different Find range (1 replies)
  134. [SOLVED:] Importing Worksheets from different Workbook (12 replies)
  135. Creating button by offsetting space (2 replies)
  136. [SOLVED:] Unable to remove "Overflow" message while running the macro (3 replies)
  137. VBA code to import data from a website (1 replies)
  138. [SOLVED:] Macro to find duplicates in a column and add the cell contents together (1 replies)
  139. VBA for Pivot Tables and Slicers (1 replies)
  140. Can someone critique my code please (20 replies)
  141. Vlookup in vba isn't working (2 replies)
  142. [SOLVED:] Macro filtered in column no fill cells in selected sheets (6 replies)
  143. Macro Loop to Copy/Paste picture and set of columns if Checkbox (0 replies)
  144. [SOLVED:] Create a Named range for each Unique Value in Column (7 replies)
  145. [SLEEPER:] Need Help Writing Macro to Simulate Roulette Spins (0 replies)
  146. [SOLVED:] Efficiently searching text array? (4 replies)
  147. conditional formatting based on other cell (over multiple Rows & Column) (0 replies)
  148. [SOLVED:] Macro to copy from Merged Cells (Same Range) to Columns of a New Worksheet (1 replies)
  149. Help Needed: filtering data from to sheets in another sheet currency wise (3 replies)
  150. [SOLVED:] How to replace a symbol like ≤ by using VBA? (13 replies)
  151. EXCEL, VBA, DLL (1 replies)
  152. Problem with creating Array (12 replies)
  153. VBA Script for changing grouped data names in multiple pivot tables (3 replies)
  154. Insert Row in Table Linked to PowerPoint (0 replies)
  155. [SOLVED:] Excel VBA Application Object (4 replies)
  156. Why my VBA code runs faster when clicking on the Immediate Window? (14 replies)
  157. Keep Lowest value row (0 replies)
  158. Need a FOR Loop which selects all worksheets with a number in the worksheet name (2 replies)
  159. excel 2010 - turn off cell updates, but keep calculations running (1 replies)
  160. macro loop to save .xml extension to .xls. (2 replies)
  161. VBA Slide array defined by user in Excel (0 replies)
  162. [SOLVED:] Open multiple VBE while using multiple monitors (4 replies)
  163. Problem with Time-Data format (5 replies)
  164. Extract unique words from textbox (6 replies)
  165. [SOLVED:] Trying to get a Macro to sort 4 digits (4 replies)
  166. Excel functions in VBA (basic question) (2 replies)
  167. Sleeper: Combine Worksheets into Master Depending on ID (0 replies)
  168. [SOLVED:] Excel VBA - Change the current page of an already open PDF (1 replies)
  169. Consecutive status in period of 15 minutes (6 replies)
  170. [SLEEPER:] From Excel, selecting Word text between headings (3 replies)
  171. Duplex Printing For 3 Hole Punched Paper (1 replies)
  172. Help with Printing/Exporting First Page of Multiple Sheets to Single PDF file (11 replies)
  173. [SOLVED:] Variable Array based on cell value (22 replies)
  174. minimized userform pops up when new spreadsheet opened (9 replies)
  175. VBA control chart Y-Axis (7 replies)
  176. FORMULA TROUBLESHOOTING (11 replies)
  177. Quicksort code (10 replies)
  178. [SOLVED:] Insert With Worksheet_Change (VBA) (56 replies)
  179. Insert & fill rows based on values if found in columns (8 replies)
  180. VBA Code - Based on Cell Value, macro inputs number into the cell that is next (3 replies)
  181. How to sum without using a worksheet function (1 replies)
  182. stop duplicates (13 replies)
  183. Compiling data from selected excel files (with screenshots!) (0 replies)
  184. Copy "My Sql" Query from worksheet and connect to MY Sql and get results (0 replies)
  185. Call By Month aggregate (17 replies)
  186. Help with macro for solver using variable cells (0 replies)
  187. Save Worksheet as PDF but Ignore Hidden Rows (1 replies)
  188. [SOLVED:] Setting Boolean Using a Cell (6 replies)
  189. VBA problem from complete amateur (2 replies)
  190. Update Worksheet from Listbox selected items (3 replies)
  191. Compiling data from selected excel files (1 replies)
  192. [SOLVED:] How to select all rows down? (2 replies)
  193. Print Screen (2 replies)
  194. [SOLVED:] Please help with formula (4 replies)
  195. Macro emailing that includes a spreadsheet sum (9 replies)
  196. Form (2 replies)
  197. VBA code not working correctly (1 replies)
  198. Sleeper: Macro to find correct workbook from table name in cell (0 replies)
  199. Re-arranging 1 row to multiple rows based on specific data (1 replies)
  200. VBA for putting in 450 word documents into excel (8 replies)
  201. Help with macroes (0 replies)
  202. [SOLVED:] Need Assistance with a complex If And Then statement (6 replies)
  203. [SOLVED:] Calculating Last Vote (5 replies)
  204. [SOLVED:] Selecting sets of 21 Rows and saving as a csv (5 replies)
  205. If statement if cell is active? (2 replies)
  206. Copy table data (0 replies)
  207. Better way to search through 35000 lines? (3 replies)
  208. adding 3 column lines to a 3 column listbox (4 replies)
  209. Compare values from two excel sheets(columns) and check values one by one (0 replies)
  210. Hyperlink to be revised help please (7 replies)
  211. Lookup and insert rows (4 replies)
  212. [SOLVED:] Case Sensitive Macro Help (2 replies)
  213. [SOLVED:] VBA to Create new tabs based on Location (8 replies)
  214. Problem with Instance Code (12 replies)
  215. VBA Help - E-mail extract (1 replies)
  216. [SOLVED:] Comparing Strings (7 replies)
  217. [SOLVED:] picking up every new unique name and counting the times it appears in a column (VBA) (5 replies)
  218. [SOLVED:] MACRO converter number to english letter (3 replies)
  219. [SOLVED:] Print hidden chart (6 replies)
  220. Help with macros/VBA and formulas - Generating a report & recurring task (0 replies)
  221. Help with VBA (1 replies)
  222. [SOLVED:] Extracting Data from Folder -- Want to Select Higher Level Folder (6 replies)
  223. Delete full line under condition (1 replies)
  224. VBA To Open & Close Files from a specified Folder (5 replies)
  225. [SOLVED:] Close Word UserForm from Excel (3 replies)
  226. VBA help - how to ungroup rows at level 2 only (1 replies)
  227. Open Webpage use pg dwn, take a screen shot (print screen) and paste into excel (0 replies)
  228. Weighted Random Number generator (15 replies)
  229. VBA Data Transmission - Sound Output/Input (1 replies)
  230. Count colored worksheets (1 replies)
  231. Run macro from another workbook (1 replies)
  232. Data Validation for a Range (17 replies)
  233. Keeping modeless userform on top (2 replies)
  234. [SOLVED:] Distribute rows from 1 ws into about 100 different workbooks and copy 2 ws to all. (8 replies)
  235. Excel 2013 is changes all General formatting to Date formatting... (0 replies)
  236. How to Loop thru Column and Modify Values Based on User Input (0 replies)
  237. [SOLVED:] Macro for setting up a printarea of random large quntaties of ranges (2 replies)
  238. Find Last Match, if no match use previous Match (5 replies)
  239. [SOLVED:] Get number of last colored column (10 replies)
  240. [SOLVED:] Try to Increment "To" Variable in "For To" but it's static. (3 replies)
  241. Excel code to close an already openend access database (2 replies)
  242. [SOLVED:] Autofill Form fields from external spreadsheet - Help please! (3 replies)
  243. [SOLVED:] Insert N cells for M new rows? (4 replies)
  244. Totally new with VBA help please (11 replies)
  245. VBA match 4 conditional values at once with Select Case. (6 replies)
  246. Worksheet_Change to trigger a graph scale change (7 replies)
  247. OnTime expertise needed (7 replies)
  248. [SOLVED:] VBA Sum a range of variable rows with a value below a set amount and loop (2 replies)
  249. Select a couple of cells per row (4 replies)
  250. VBA in oil and gas prodaction (4 replies)