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:] multiple pivot tables to a worksheet using Excel (14 replies)
  2. Infinite FOR EACH loop when second application opened (4 replies)
  3. [SOLVED:] excel not multiplying correctly (10 replies)
  4. Macro creating Comma separated Key (11 replies)
  5. Ticked check boxes that create a new list - VBA? (4 replies)
  6. [SLEEPER:] Add worksheet change event to all sheets during runtime_new (6 replies)
  7. [SOLVED:] Userform: Combining 2 values into 1 record (5 replies)
  8. How to Sort Excel File (2013) with 4 or 5 Keys in VBA (3 replies)
  9. [SOLVED:] For each sheet in between two sheets criteria - VBA (5 replies)
  10. Code for IF statement referencing two more sheets and color formatting (3 replies)
  11. [SOLVED:] Showing numbers in 1000's, but not rounded (2 replies)
  12. [SOLVED:] Copy Insert Row At Start End Or Middle with different Columns same row range (2 replies)
  13. Faster way to delete rows based on criteria? (9 replies)
  14. Combine Multiple Csv Files Into one Worksheets with file name as header (9 replies)
  15. [SOLVED:] apply distinct formulas to autocomplete different columns in a specific table (2 replies)
  16. VBA code to switch system language to English (0 replies)
  17. Count successful create blank row (1 replies)
  18. [SOLVED:] Merge two tables into one - VBA help? (11 replies)
  19. [SOLVED:] Autofill NOT COPYING formula (5 replies)
  20. Conditional Formatting (Macro) (1 replies)
  21. Coding help for a complete VBA Beginner (1 replies)
  22. VBA Code for Next Business Day (4 replies)
  23. [SOLVED:] Multiplier (VBA) (10 replies)
  24. Copy true number in another column (2 replies)
  25. How to return to the original active cell? (2 replies)
  26. VBA Code to Track Changes in Excel Sheet (1 replies)
  27. Copy rows according to value of cells selected according to the value of other cells (7 replies)
  28. [SOLVED:] EXCEL export creating double quotes (11 replies)
  29. Copy certain columns of data from 2 worksheets that are auto-filtered to 1 summary wo (1 replies)
  30. [SOLVED:] Compile Error Object Required (Excel VBA) (5 replies)
  31. [SOLVED:] Excel 365 - Forms Control (5 replies)
  32. Loping through each worksheet with an exception (12 replies)
  33. [SOLVED:] VBA function with 3 arguments in 3 cells to the left of entered cell (6 replies)
  34. [SOLVED:] Delete duplicate value for same date and other look up value. (6 replies)
  35. Force switch the language to ENG (0 replies)
  36. Running Total SUM Based on Criteria (2 replies)
  37. Workbook & Worksheet referencing (5 replies)
  38. [SOLVED:] ListBox mirror TextBox and Copy to Excel Table (3 replies)
  39. [SOLVED:] vba combobox list on Userform has blanks (9 replies)
  40. insert only the first 4 images from folder (3 replies)
  41. Copy column, copy list from another document and use that to replace multiple values (0 replies)
  42. [SLEEPER:] VBA: concatenate multiple cell data (3 replies)
  43. [SOLVED:] Method value of object range failed. (4 replies)
  44. Take several screenshots one after another of a table (6 replies)
  45. [SOLVED:] Truncate number to two decimal places without rounding (6 replies)
  46. [SOLVED:] VBA Find string and add hyperlink (7 replies)
  47. Cannot use that command on overlapping selections- delete row code (1 replies)
  48. [SOLVED:] Highlight Pay Dates on Userform Calendar (14 replies)
  49. [SOLVED:] VBA: If number found in column B:C in excel sheet reduce numbers by -1 (3 replies)
  50. create treeview with 2 columns (1 replies)
  51. Add/Remove pivot fields via macro- Help req to change existing code (3 replies)
  52. Linear Interpolation (3 replies)
  53. [SOLVED:] Excel VBA if condition then copy other cells to another worksheet (8 replies)
  54. [SOLVED:] Using a function with part of an array (14 replies)
  55. [SOLVED:] No Intellisense for "Sheets" Object in Excel VBA? (6 replies)
  56. [SOLVED:] VLOOKUP Error : Need a VBA to copy matching row cell data in sheet1 from sheet2 (2 replies)
  57. vba add worksheet checkboxes (4 replies)
  58. Using VBA to copy data to new sheet and find data from other sheets (5 replies)
  59. [SOLVED:] VBA: Find the position of occurrence of text in sentence (9 replies)
  60. My script opens a large workbook - too slow - any fixes? (7 replies)
  61. [SOLVED:] How To Change VBA Copy Rows "X" Number of Times (4 replies)
  62. [SOLVED:] Intercept an splwow64.exe error (3 replies)
  63. [SOLVED:] How to save a macro excel? (2 replies)
  64. Tricky situation in excel ( (15 replies)
  65. [SOLVED:] tooltip macro (6 replies)
  66. How to use VBA for multiple rows? Now I have code for 1 row. (3 replies)
  67. [SOLVED:] Fiscal Date year changes automatically (9 replies)
  68. Looking to paste without changing the format of the cells pasted into (9 replies)
  69. Hello, I have tree macros and I want to link two of them: 1. The first one( Report m (2 replies)
  70. [SOLVED:] VBA comparison with ActiveCell.Offset (14 replies)
  71. [SOLVED:] Overflow Error Trying to Calculate Percentages (9 replies)
  72. [SOLVED:] Vlookup across Workbook (6 replies)
  73. Declare function no longer works (13 replies)
  74. VBA code to delete and replace this month's data (9 replies)
  75. [SOLVED:] Filter month based on file name contains months (5 replies)
  76. vba partial names variables (14 replies)
  77. [VBA - UserForm] Change "Status" cells in all duplicated rows at the same time (2 replies)
  78. [SLEEPER:] How to replace specific formulas by values and then generate several xlsx/pdf filenam (5 replies)
  79. [SOLVED:] Sending and receiving ASCII commands in excel (14 replies)
  80. [SOLVED:] Merging Error (8 replies)
  81. How to Structure Conditional Statement for an Array (2 replies)
  82. Value out row based on a cell value (5 replies)
  83. [SOLVED:] Converter Function (3 replies)
  84. Important security change by Microsoft (2 replies)
  85. Getopenfilename - File dialog hidden (6 replies)
  86. ActiveSheet.Pictures.Paste runtime error (8 replies)
  87. [SOLVED:] VBA Loop through column, copy specific cells, and stop when i meets a red cell? HELP (14 replies)
  88. group by column (4 replies)
  89. One Macro for Copy/Paste, Formula, Colouring and Hyperlinking for at home (4 replies)
  90. I want to copy a value from a previous sheet, every day. (3 replies)
  91. [SOLVED:] VBA macro for print out (12 replies)
  92. Trying to find a way to find matching values, their row number and update whole rows (1 replies)
  93. Text file import texttocolumns vs querytable.add (5 replies)
  94. [SOLVED:] VBA Sort Data Descending Order in two tables (4 replies)
  95. Macro to compare sheetname from one workbook with another and take actions depending (3 replies)
  96. "Can't find project or library" error (5 replies)
  97. Daily Dose Of Excel (2 replies)
  98. VBA to Search More than One Worksheet in a Workbook (2 replies)
  99. Module to Calculate from Two Tables (2 replies)
  100. VBA Assistance needed - lookup, match and copy command (17 replies)
  101. [SLEEPER:] Refer to Excel collections in VBA with a "variable" name? (11 replies)
  102. Excel Help - (0 replies)
  103. [SOLVED:] Make BackUps of files Using Excel List (6 replies)
  104. How to post predefined cell value to active cell (11 replies)
  105. [SOLVED:] SQL query using where with multiple criterias (3 replies)
  106. [SOLVED:] Userform command button does not respond when calling userform from custom ribbon (1 replies)
  107. [SOLVED:] Help with Find and replace code (4 replies)
  108. CommandButton Back Colour is not set on WorkBook Open (5 replies)
  109. [SOLVED:] Else statement in loop (3 replies)
  110. [SOLVED:] Filling array bas on vba formula (8 replies)
  111. [SOLVED:] How to convert Index(match.. (Left(Right...)..)..) into VBA (excel) (4 replies)
  112. How to use uppercase in an additional column? (4 replies)
  113. [SOLVED:] Change destination folder (2 replies)
  114. Copy the last category and insert custom text (2 replies)
  115. [SOLVED:] Extract files in a folder containing contents in column A and move them to own folder (7 replies)
  116. [SOLVED:] Dragging Formula down through merged cells (4 replies)
  117. scraping element in web page.... (0 replies)
  118. Compare Multiple Columns between two workbooks and update the values in the second wo (2 replies)
  119. [SOLVED:] Run time Error 1004 when assigning cell value (2 replies)
  120. [SOLVED:] Unexpected Numerical Value in Table When Adding Blank Line (5 replies)
  121. [SOLVED:] Include the exact name from one cell in to a formula in another cell (9 replies)
  122. Pivot filter by each item and copy to new sheet (3 replies)
  123. [SOLVED:] AVERAGEIFS formula - adjust to exclude values of 0 (14 replies)
  124. Save-As name based on cell value (2 replies)
  125. VBA: fetch data from cells and concatenate matching data heading in another sheet (6 replies)
  126. Roll column forward and hard paste previous (1 replies)
  127. [SOLVED:] Copy unique values from new data and append to existing list in another worksheet (7 replies)
  128. link pictures from Sharepoint to Excel macro (0 replies)
  129. VBA: Remove line in cell if substring present (1 replies)
  130. Combine these codes to one (5 replies)
  131. Finding minimum value Using VBA (3 replies)
  132. incrementing a set string by1 (1 replies)
  133. [SLEEPER:] VBA creating relative references to table columns (5 replies)
  134. [SOLVED:] Unmerge Cells & Copy Cells Down to Next Line of Data (25 replies)
  135. Help fixing and cleaning up code (2 replies)
  136. Using VBA to rename or delete subfolders (8 replies)
  137. [SOLVED:] Remove part of a string (4 replies)
  138. [SOLVED:] Type Mismatch Error when Setting WorkSheets (4 replies)
  139. [SOLVED:] Error with progress bar chart (2 replies)
  140. What does line 7 mean (2 replies)
  141. [SOLVED:] Highest consecutive values in column (13 replies)
  142. [SOLVED:] How to move column of data down (shift it by 1 row) (2 replies)
  143. VBA Excel deleting duplicates (2 replies)
  144. VBA- No form on Mac (0 replies)
  145. Static cell (3 replies)
  146. Sleeper: Application FileSearch help (1 replies)
  147. giving a direction to VBA to open a specific file (1 replies)
  148. [SOLVED:] Why For each rw is empty? (6 replies)
  149. [SOLVED:] How to sort single column (selected)? (2 replies)
  150. [SOLVED:] How correctly check for error? (2 replies)
  151. [SOLVED:] Single workbook - Cannot run the macro... the macro may not be available in this work (2 replies)
  152. [SOLVED:] VBA to enter formula using variables: Error 438 (2 replies)
  153. Format Incremental Value as Two Digit String (8 replies)
  154. [SOLVED:] Delete multiple rows based on cell color (3 replies)
  155. Need help updating sort automatically, but only if a cell has a number (8 replies)
  156. Export multiple sheets to PDF per product by looping through slicer (5 replies)
  157. VBA for Depreciation Calculation (1 replies)
  158. [SLEEPER:] Create Table with quartils (18 replies)
  159. VBA and Budgeting (2 replies)
  160. [SOLVED:] Create Name in Name Box (7 replies)
  161. [SOLVED:] Layout list by VBA (3 replies)
  162. [SOLVED:] Excel VBA search other email account than default (2 replies)
  163. Select multiple named ranges and clear contents (2 replies)
  164. add multiple rows with content in another tab (0 replies)
  165. finding partial string into another workbook, then do several cell copy when found (2 replies)
  166. VBA macro to search contents of a folder of Excel Workbooks (17 replies)
  167. Trouble switching to the M1 Mac or Excel in Office16.54 (9 replies)
  168. Collect data from a multi-sheets workbook (1 replies)
  169. [SOLVED:] Copy formula down in next blank row andn hard paste previous results (6 replies)
  170. Match values between tabs and insert value from other column (2 replies)
  171. [SOLVED:] Create Copies of Workbook with Sheet2 Formulas Referencing Sheet1 Not Workbook Copied (3 replies)
  172. [SOLVED:] Select & hide multiple rows based on cell value (2 replies)
  173. [SOLVED:] Problem Evaluate Variables (12 replies)
  174. Excel Search Code Help (1 replies)
  175. How to create a coordinate system for a svg picture in excel? (0 replies)
  176. [SOLVED:] Compare column values (2 replies)
  177. Calendar Control in Excel VBA (2 replies)
  178. [SOLVED:] Deadline pop up reminder (2 replies)
  179. VBA to Automate Outlook Mail (0 replies)
  180. VBA Create Hyperlink when additional data is added for each row based on cell value (6 replies)
  181. [SOLVED:] Changing Font Colour (14 replies)
  182. [SOLVED:] Script to detect overlapping values based on two variables (2 replies)
  183. [SOLVED:] Help with intersect (2 replies)
  184. Copy data from another file without opening (5 replies)
  185. Copy Table Thanks and best regards (0 replies)
  186. Search files from textbox in UserForm, display result in Listbox (13 replies)
  187. AT-Sign appearing in formula inserted via VBA (3 replies)
  188. [SOLVED:] how to add range in this vba code (6 replies)
  189. [SOLVED:] Use Offset to select offset cell value (32 replies)
  190. VBA Path Query (8 replies)
  191. [SLEEPER:] Help with VBA (4 replies)
  192. [SOLVED:] Help : Maxifs with criteria of any part of the cell value separated with commas (3 replies)
  193. [SOLVED:] VBA Error - Mail Merge (4 replies)
  194. Use the VBA filter (6 replies)
  195. VBA (3 replies)
  196. Auto filter in all worksheets in VBA. (18 replies)
  197. Worksheets numerically sorting (5 replies)
  198. [SOLVED:] Run-Time Error 1004: Document Not Saved (2 replies)
  199. Sleeper: Interpretation of `@` sign in the formula bar (3 replies)
  200. VBA code and VBA loop (0 replies)
  201. [SOLVED:] Delete row when Cells D,E,F are empty. (1 replies)
  202. How can I add more contour lines to a wireframe chart? (5 replies)
  203. [SOLVED:] Help : Looping and Conditional Formating (7 replies)
  204. Macro - Copy values in column if any of them changes (1 replies)
  205. [SOLVED:] If cell is empty equal value from offset(1,4) (5 replies)
  206. [SOLVED:] Sort table vertically (7 replies)
  207. Outlook Macro sorts Excel worksheet but corrupts file? (2 replies)
  208. [SOLVED:] Help : Shorten code to check multiple columns in Worksheet_Change event (6 replies)
  209. search button (2 replies)
  210. Button to Stop Number Loop Code Running (1 replies)
  211. how merge and unmerge duplictes items in listbox on userform (0 replies)
  212. How do you upload PDF? (1 replies)
  213. Imprt data from MDB file (1 replies)
  214. parsing address into separate cells (5 replies)
  215. [SLEEPER:] que: coding for dynamic calendar; multiple drop down lists outputting to new shee (3 replies)
  216. [SOLVED:] Compare first word in Multiline and delete the whole line in a multiline cell (2 replies)
  217. Name Word File According to cell value in excel (1 replies)
  218. Automatically conjoin columns (2 replies)
  219. Add worksheet change event to all sheets during runtime (5 replies)
  220. [SOLVED:] Lookup & Color cell Red (6 replies)
  221. Concatenate columns without formula in private sub worksheet_change (16 replies)
  222. Deleting Blank Rows in VBA Code (4 replies)
  223. Making listboxes interdependent (3 replies)
  224. Filters (1 replies)
  225. Excel VB Script to Fill Values Based on Common Values in an Adjacent Cell (5 replies)
  226. How can I control the color of wires in wireframe 3-D surface chart? (2 replies)
  227. [SOLVED:] Create n number of tables based on number of days in that week (10 replies)
  228. How to webscrape using VBA querySelectorAll when selectors have data-bind in them (0 replies)
  229. [SOLVED:] Date Format Issue in the Data Received (27 replies)
  230. [SLEEPER:] How to disable editing in Analysis for office (2 replies)
  231. Automatically replacing placeholders in different word templates via Excel (1 replies)
  232. [SOLVED:] Name PDF from Filter Criteria Row (3 replies)
  233. Procv (0 replies)
  234. vba command import data from web page (4 replies)
  235. Error after date: 10-10-2021 (3 replies)
  236. [SOLVED:] how to find a value and copy remark, author, row and column header names to new sheet (4 replies)
  237. [SOLVED:] Trying to add tick marks to scatter plots. (1 replies)
  238. Insert time in another column when a column containing RTD updates values (10 replies)
  239. [SOLVED:] add lines (4 replies)
  240. [SOLVED:] Finding 1 but not 10 or 100 (10 replies)
  241. [SOLVED:] Total filtered rows - Range of object Global failed (18 replies)
  242. Sleeper: Is there a faster method to find extended file properties (11 replies)
  243. [SOLVED:] Find last number in column if year matches (4 replies)
  244. Read content of a XLSX or CSV file using VBA if that is stored on an FTP-server ? (0 replies)
  245. Adding formula to excisting formulas (4 replies)
  246. [SOLVED:] Selecting one OptionButton reset the choices in another Group (1 replies)
  247. [SOLVED:] "Object variable or with block variable not set" Error on Second loop of For Loop (4 replies)
  248. [SOLVED:] VBA dynamic column names in pivot tables (4 replies)
  249. [SOLVED:] Delete worksheets with blank cell (2 replies)
  250. How to Merge two arrays with filter condition? (4 replies)