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. "Can't find project or library" error (5 replies)
  2. Daily Dose Of Excel (2 replies)
  3. VBA to Search More than One Worksheet in a Workbook (2 replies)
  4. Module to Calculate from Two Tables (2 replies)
  5. VBA Assistance needed - lookup, match and copy command (17 replies)
  6. Refer to Excel collections in VBA with a "variable" name? (11 replies)
  7. Excel Help - (0 replies)
  8. [SOLVED:] Make BackUps of files Using Excel List (6 replies)
  9. How to post predefined cell value to active cell (11 replies)
  10. [SOLVED:] SQL query using where with multiple criterias (3 replies)
  11. [SOLVED:] Userform command button does not respond when calling userform from custom ribbon (1 replies)
  12. [SOLVED:] Help with Find and replace code (4 replies)
  13. CommandButton Back Colour is not set on WorkBook Open (5 replies)
  14. [SOLVED:] Else statement in loop (3 replies)
  15. [SOLVED:] Filling array bas on vba formula (8 replies)
  16. [SOLVED:] How to convert Index(match.. (Left(Right...)..)..) into VBA (excel) (4 replies)
  17. How to use uppercase in an additional column? (4 replies)
  18. [SOLVED:] Change destination folder (2 replies)
  19. Copy the last category and insert custom text (2 replies)
  20. [SOLVED:] Extract files in a folder containing contents in column A and move them to own folder (7 replies)
  21. [SOLVED:] Dragging Formula down through merged cells (4 replies)
  22. scraping element in web page.... (0 replies)
  23. Compare Multiple Columns between two workbooks and update the values in the second wo (2 replies)
  24. [SOLVED:] Run time Error 1004 when assigning cell value (2 replies)
  25. [SOLVED:] Unexpected Numerical Value in Table When Adding Blank Line (5 replies)
  26. [SOLVED:] Include the exact name from one cell in to a formula in another cell (9 replies)
  27. Pivot filter by each item and copy to new sheet (3 replies)
  28. [SOLVED:] AVERAGEIFS formula - adjust to exclude values of 0 (14 replies)
  29. Save-As name based on cell value (2 replies)
  30. VBA: fetch data from cells and concatenate matching data heading in another sheet (6 replies)
  31. Roll column forward and hard paste previous (1 replies)
  32. [SOLVED:] Copy unique values from new data and append to existing list in another worksheet (7 replies)
  33. link pictures from Sharepoint to Excel macro (0 replies)
  34. VBA: Remove line in cell if substring present (1 replies)
  35. Combine these codes to one (5 replies)
  36. Finding minimum value Using VBA (3 replies)
  37. incrementing a set string by1 (1 replies)
  38. VBA creating relative references to table columns (5 replies)
  39. [SOLVED:] Unmerge Cells & Copy Cells Down to Next Line of Data (25 replies)
  40. Help fixing and cleaning up code (2 replies)
  41. Using VBA to rename or delete subfolders (8 replies)
  42. [SOLVED:] Remove part of a string (4 replies)
  43. [SOLVED:] Type Mismatch Error when Setting WorkSheets (4 replies)
  44. [SOLVED:] Error with progress bar chart (2 replies)
  45. What does line 7 mean (2 replies)
  46. [SOLVED:] Highest consecutive values in column (13 replies)
  47. [SOLVED:] How to move column of data down (shift it by 1 row) (2 replies)
  48. VBA Excel deleting duplicates (2 replies)
  49. VBA- No form on Mac (0 replies)
  50. Static cell (3 replies)
  51. Sleeper: Application FileSearch help (1 replies)
  52. giving a direction to VBA to open a specific file (1 replies)
  53. [SOLVED:] Why For each rw is empty? (6 replies)
  54. How to sort single column (selected)? (2 replies)
  55. [SOLVED:] How correctly check for error? (2 replies)
  56. [SOLVED:] Single workbook - Cannot run the macro... the macro may not be available in this work (2 replies)
  57. [SOLVED:] VBA to enter formula using variables: Error 438 (2 replies)
  58. Format Incremental Value as Two Digit String (8 replies)
  59. [SOLVED:] Delete multiple rows based on cell color (3 replies)
  60. Need help updating sort automatically, but only if a cell has a number (8 replies)
  61. Export multiple sheets to PDF per product by looping through slicer (5 replies)
  62. VBA for Depreciation Calculation (1 replies)
  63. Create Table with quartils (18 replies)
  64. VBA and Budgeting (2 replies)
  65. [SOLVED:] Create Name in Name Box (7 replies)
  66. [SOLVED:] Layout list by VBA (3 replies)
  67. [SOLVED:] Excel VBA search other email account than default (2 replies)
  68. Select multiple named ranges and clear contents (2 replies)
  69. add multiple rows with content in another tab (0 replies)
  70. finding partial string into another workbook, then do several cell copy when found (2 replies)
  71. VBA macro to search contents of a folder of Excel Workbooks (17 replies)
  72. Trouble switching to the M1 Mac or Excel in Office16.54 (9 replies)
  73. Collect data from a multi-sheets workbook (1 replies)
  74. [SOLVED:] Copy formula down in next blank row andn hard paste previous results (6 replies)
  75. Match values between tabs and insert value from other column (2 replies)
  76. [SOLVED:] Create Copies of Workbook with Sheet2 Formulas Referencing Sheet1 Not Workbook Copied (3 replies)
  77. [SOLVED:] Select & hide multiple rows based on cell value (2 replies)
  78. [SOLVED:] Problem Evaluate Variables (12 replies)
  79. Excel Search Code Help (1 replies)
  80. How to create a coordinate system for a svg picture in excel? (0 replies)
  81. [SOLVED:] Compare column values (2 replies)
  82. Calendar Control in Excel VBA (2 replies)
  83. [SOLVED:] Deadline pop up reminder (2 replies)
  84. VBA to Automate Outlook Mail (0 replies)
  85. VBA Create Hyperlink when additional data is added for each row based on cell value (6 replies)
  86. [SOLVED:] Changing Font Colour (14 replies)
  87. [SOLVED:] Script to detect overlapping values based on two variables (2 replies)
  88. [SOLVED:] Help with intersect (2 replies)
  89. Copy data from another file without opening (5 replies)
  90. Copy Table Thanks and best regards (0 replies)
  91. Search files from textbox in UserForm, display result in Listbox (13 replies)
  92. AT-Sign appearing in formula inserted via VBA (3 replies)
  93. [SOLVED:] how to add range in this vba code (6 replies)
  94. [SOLVED:] Use Offset to select offset cell value (32 replies)
  95. VBA Path Query (8 replies)
  96. Help with VBA (3 replies)
  97. [SOLVED:] Help : Maxifs with criteria of any part of the cell value separated with commas (3 replies)
  98. [SOLVED:] VBA Error - Mail Merge (4 replies)
  99. Use the VBA filter (6 replies)
  100. VBA (3 replies)
  101. Auto filter in all worksheets in VBA. (18 replies)
  102. Worksheets numerically sorting (5 replies)
  103. [SOLVED:] Run-Time Error 1004: Document Not Saved (2 replies)
  104. Sleeper: Interpretation of `@` sign in the formula bar (3 replies)
  105. VBA code and VBA loop (0 replies)
  106. [SOLVED:] Delete row when Cells D,E,F are empty. (1 replies)
  107. How can I add more contour lines to a wireframe chart? (5 replies)
  108. [SOLVED:] Help : Looping and Conditional Formating (7 replies)
  109. Macro - Copy values in column if any of them changes (1 replies)
  110. [SOLVED:] If cell is empty equal value from offset(1,4) (5 replies)
  111. [SOLVED:] Sort table vertically (7 replies)
  112. Outlook Macro sorts Excel worksheet but corrupts file? (2 replies)
  113. [SOLVED:] Help : Shorten code to check multiple columns in Worksheet_Change event (6 replies)
  114. search button (2 replies)
  115. Button to Stop Number Loop Code Running (1 replies)
  116. how merge and unmerge duplictes items in listbox on userform (0 replies)
  117. How do you upload PDF? (1 replies)
  118. Imprt data from MDB file (1 replies)
  119. parsing address into separate cells (5 replies)
  120. vba que: coding for dynamic calendar; multiple drop down lists outputting to new shee (3 replies)
  121. [SOLVED:] Compare first word in Multiline and delete the whole line in a multiline cell (2 replies)
  122. Name Word File According to cell value in excel (1 replies)
  123. Automatically conjoin columns (2 replies)
  124. Add worksheet change event to all sheets during runtime (5 replies)
  125. [SOLVED:] Lookup & Color cell Red (6 replies)
  126. Concatenate columns without formula in private sub worksheet_change (16 replies)
  127. Deleting Blank Rows in VBA Code (4 replies)
  128. Making listboxes interdependent (3 replies)
  129. Filters (1 replies)
  130. Excel VB Script to Fill Values Based on Common Values in an Adjacent Cell (5 replies)
  131. How can I control the color of wires in wireframe 3-D surface chart? (2 replies)
  132. [SOLVED:] Create n number of tables based on number of days in that week (10 replies)
  133. How to webscrape using VBA querySelectorAll when selectors have data-bind in them (0 replies)
  134. [SOLVED:] Date Format Issue in the Data Received (27 replies)
  135. How to disable editing in Analysis for office (2 replies)
  136. Automatically replacing placeholders in different word templates via Excel (1 replies)
  137. [SOLVED:] Name PDF from Filter Criteria Row (3 replies)
  138. Procv (0 replies)
  139. vba command import data from web page (4 replies)
  140. Error after date: 10-10-2021 (3 replies)
  141. [SOLVED:] how to find a value and copy remark, author, row and column header names to new sheet (4 replies)
  142. [SOLVED:] Trying to add tick marks to scatter plots. (1 replies)
  143. Insert time in another column when a column containing RTD updates values (10 replies)
  144. [SOLVED:] add lines (4 replies)
  145. [SOLVED:] Finding 1 but not 10 or 100 (10 replies)
  146. [SOLVED:] Total filtered rows - Range of object Global failed (18 replies)
  147. Sleeper: Is there a faster method to find extended file properties (11 replies)
  148. [SOLVED:] Find last number in column if year matches (4 replies)
  149. Read content of a XLSX or CSV file using VBA if that is stored on an FTP-server ? (0 replies)
  150. Adding formula to excisting formulas (4 replies)
  151. [SOLVED:] Selecting one OptionButton reset the choices in another Group (1 replies)
  152. [SOLVED:] "Object variable or with block variable not set" Error on Second loop of For Loop (4 replies)
  153. [SOLVED:] VBA dynamic column names in pivot tables (4 replies)
  154. [SOLVED:] Delete worksheets with blank cell (2 replies)
  155. How to Merge two arrays with filter condition? (4 replies)
  156. [SOLVED:] Stuck with replacing character (2 replies)
  157. Count blank rows after non blank row (2 replies)
  158. Adapt code attached to normal excel sheet (0 replies)
  159. [SOLVED:] Sorting based on letter, and then on number (22 replies)
  160. Formulas or guide of simpler formulas (1 replies)
  161. Countif into VBA from teams excel (0 replies)
  162. [SOLVED:] Get out of design mode (2 replies)
  163. [SOLVED:] Exclude Sheet from Formula (5 replies)
  164. is there any macro to open temp file folder and delete temp files (5 replies)
  165. Can VBA determine the first row number of each page? (3 replies)
  166. How can I set the default font color of chart titles? (1 replies)
  167. [SOLVED:] Use a formatting cell property to count duplicate (4 replies)
  168. How to assign Xaxis limits to multiple scatter plots on the same sheet? (1 replies)
  169. How to query an open ListObject? (15 replies)
  170. Extract 10 digits number from text or any special characters (2 replies)
  171. can you set 3d models to have to same depth? excel, vba (0 replies)
  172. [SOLVED:] VBA Format Function not Formatting Numbers on Worksheet (2 replies)
  173. Block to write in cell (0 replies)
  174. MACROS &VBA BEGINNER (2 replies)
  175. unable to get match property of worksheetfunction class (2 replies)
  176. vbObjectError Not Working as Expected (33 replies)
  177. VBA Beginer -Real Estate Industry (2 replies)
  178. [SOLVED:] Excel 365 - VBA to assign a formula (6 replies)
  179. [SOLVED:] run macro on range of cells only (0 replies)
  180. loop + Add value (1 replies)
  181. Move WordArts on others Sheets with a checkbox on the active sheet? (4 replies)
  182. Formula for finding unique values (7 replies)
  183. [SOLVED:] AND Cell value A minus Cell value B divided by Cell value A > 0.1 (2 replies)
  184. Work book with on time control to close in specified time (0 replies)
  185. Stop Importing file after 'End Records' (1 replies)
  186. Google Spread Sheet Search any part of the cell and display (0 replies)
  187. Sum Cell Values Until Blank Cells With VBA (5 replies)
  188. [SOLVED:] Color Cell based off of a Simple Range. (8 replies)
  189. Copy data column from a table to another (3 replies)
  190. [SOLVED:] Help. Macro works, but Excel is not responding well after running it (1 replies)
  191. Experiencing workbook with user form keeps closing upon opening (4 replies)
  192. Reading a SharePoint list using Excel VBA (8 replies)
  193. General about VBA (2 replies)
  194. [SOLVED:] Formula Modification Help with And/OR (2 replies)
  195. How to extract a specific data in a column and parse it in another column with VBA (3 replies)
  196. Copy & Paste from 1 WB to another WB (4 replies)
  197. [SOLVED:] Getting Error when calculating date value (3 replies)
  198. [SOLVED:] Listbox Multiselect (4 replies)
  199. [SOLVED:] Resolve changed filename in Excel shortcut Target attribute (1 replies)
  200. Run-time error ‘1004’: Method ‘Name’ of object ‘_Worksheet’ failed (2 replies)
  201. Adjusting VBA module (4 replies)
  202. How to pop up message box even when editing a cell (0 replies)
  203. One OptionButton change state of another one in different group (1 replies)
  204. [SOLVED:] Transferring Wide Data to Long Data (5 replies)
  205. Combine All Data From one Worksheets in All Workbooks in a Specified Directory (0 replies)
  206. Concatenate with conditional and reference (2 replies)
  207. NumberFormat of a table column (1 replies)
  208. Add sheet and rename sheet and paste only value (4 replies)
  209. How to Run a Batch File Using VBA in Excel 2013 (11 replies)
  210. [SOLVED:] Payroll Formula Help (3 replies)
  211. [SOLVED:] Application-defined or object-defined error - Error in replicating code (9 replies)
  212. Excel version (3 replies)
  213. RAM does not get released when workbook is closed (3 replies)
  214. [SOLVED:] VBA Insert ROWs into table and continue index value based on last row (2 replies)
  215. [SOLVED:] Dynamic column Add and names (3 replies)
  216. Do not update range if cell is not empty (4 replies)
  217. [VBA] Edit and Move my diagram (2 replies)
  218. [SOLVED:] Linear Interpolation (5 replies)
  219. Extract record based on company (9 replies)
  220. [SOLVED:] UserForm Button That Loops Through Various Table Styles on the Table Design Ribbon (3 replies)
  221. [SOLVED:] Copying data to another sheet in a particular format and Auto-adjustment (2 replies)
  222. [SOLVED:] VBA Create Diagramms (1 replies)
  223. VBA to Paste Text into Ppt as Title (3 replies)
  224. VBA Addition to existing cell (0 replies)
  225. Excel UDF with IF (10 replies)
  226. vba - Sendkeys Crtl+C and clipboard (4 replies)
  227. [SOLVED:] VBA formula not working because array formula needed (10 replies)
  228. How to Bring up the Table Design Dialogbox (VBA) for the User to Select Table Designs (4 replies)
  229. How can I create product keys for VBA add-ins and store it in the system? (19 replies)
  230. [SOLVED:] Use Inputbox to Add Column in Excel Table with Multiple Criteria (4 replies)
  231. [SOLVED:] Fill in blank cells with the data listed above it (8 replies)
  232. Changing shapes in footers (0 replies)
  233. [SOLVED:] VBA to export data with altered format to a csv (10 replies)
  234. Extract Excel Outlook Attcahments (2 replies)
  235. [SOLVED:] Download files from excel multiple links (0 replies)
  236. Excel VBA to delete Email String from Picked Folder (1 replies)
  237. Text File processed into Excel (8 replies)
  238. Conditional Formatting in Listview (3 replies)
  239. complex excel formula (16 replies)
  240. [SOLVED:] why is my 'find and replace' function automatically set to look in formulas? (9 replies)
  241. For Next lop ends on x +1 (5 replies)
  242. update final sheet with data from existing sheets (2 replies)
  243. 6 columns to 6 sheets in same workbook and 6 sheets charts pasted to PowerPoint slide (0 replies)
  244. Bar charts in pivot (0 replies)
  245. Map SharePoint drive using VBA (3 replies)
  246. Listbox fill via recordset (6 replies)
  247. Select only cells with visible values (1 replies)
  248. vba userform move listbox1 item to listbox2 (2 replies)
  249. Pop up windows asks what name the folder should have (1 replies)
  250. hex to color (9 replies)