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. [SOLVED:] VBA code not working (8 replies)
  2. Creating a macro to highlight cells in one sheet using info provided in another sheet (5 replies)
  3. How to save multiple output excel in single folder in the given format (2 replies)
  4. ActiveWorkbook.SaveAs not working with folder (2 replies)
  5. [SOLVED:] Create Named Ranges from worksheet list (5 replies)
  6. [SOLVED:] Help needed to find matching string from the collection. (30 replies)
  7. userform close when i close another excel file (5 replies)
  8. [SOLVED:] Excel VBA NOT LOOPING (3 replies)
  9. [SOLVED:] Open file with vba based on file name (3 replies)
  10. VBA and Highlight function has stopped the Undo Funciton (15 replies)
  11. Cannot find the Chrome binary (2 replies)
  12. Could not find installable isam when connecting Excel 2016 to SharePoint 1016 lists (0 replies)
  13. Split file with multiple sheets into new workbooks based on column value (0 replies)
  14. [SOLVED:] Subtracting Single and Formular values (5 replies)
  15. Sleeper: VBA to continuously click email hyperlink (4 replies)
  16. Need help with VBA (1 replies)
  17. [SOLVED:] Macro to import historical data using web query (9 replies)
  18. [SOLVED:] Inserting Date Last Modified in lots of excel files without opening (24 replies)
  19. VBA module to Macro short cut and sharing to multiple users (16 replies)
  20. [SOLVED:] How to search text in pdf files in one folder (1 replies)
  21. Hide unhide sheets with navigation buttons (1 replies)
  22. [SOLVED:] Why does this work? Replacing IF with Text (8 replies)
  23. [SOLVED:] Saving index to a variable prior to closing the file (2 replies)
  24. [SOLVED:] Close Specific Workbooks Without Saving (22 replies)
  25. [SOLVED:] Summing dynamic Excel column and count (17 replies)
  26. Command Button (3 replies)
  27. [SOLVED:] VBA Hyperlink not working (4 replies)
  28. [SOLVED:] Help with Convert a formula (5 replies)
  29. [SOLVED:] Incrementing a list on clicking a macro button (10 replies)
  30. [SOLVED:] Incrementing value in a cell depending on clicking of a macro button (3 replies)
  31. circular flow diagram (4 replies)
  32. Sleeper: Method to show exponential growth in population (1 replies)
  33. How to create a module to find missing brands and models (look through table 1, compa (2 replies)
  34. [SOLVED:] Update Excel table from a one column range on a different sheet (6 replies)
  35. [SOLVED:] Pivot table showing how a Batsman was given out (6 replies)
  36. [SOLVED:] Existing macro to password protect sheets has stopped working (6 replies)
  37. How to.. Macros only running one active worksheet (2 replies)
  38. Sleeper: Change Cell's named reference via VBA (3 replies)
  39. [SOLVED:] Join Lines (2 replies)
  40. Adding worksheets to a Listbox (14 replies)
  41. [SOLVED:] VBA sub - result in run-time error 9, but code looks good (6 replies)
  42. Sleeper: VBA Change Line colors (12 replies)
  43. Sleeper: Loop for copying and pasting tables (4 replies)
  44. [SOLVED:] Macro Codes for auto fit columns and rows (5 replies)
  45. Sleeper: VBA code to un-merge cells from a Database (4 replies)
  46. [SOLVED:] how to enable macro button for every sheet (2 replies)
  47. Convert Index Match to a regular excel reference (8 replies)
  48. Table format to rows Macro (5 replies)
  49. Simplification of Repetative Actions on 2 sets of Different Ranges (11 replies)
  50. [SOLVED:] Select row apart from a merged area (4 replies)
  51. Sleeper: Excel's Formula by Example (1 replies)
  52. [SOLVED:] Counts min and max quantity of equals 'strings' based on a filter column (10 replies)
  53. [SOLVED:] Custom Function Wtih Range in Another Sheet (3 replies)
  54. Moving file to folder with first couple matching characters (2 replies)
  55. Sleeper: Need some help with arrays and loops (3 replies)
  56. Oddly slow running code, under very specific circumstances (9 replies)
  57. Hide the Macro form Dialog Box (4 replies)
  58. Changing excel version with macros (2 replies)
  59. Switching Between Two Already Open Apps (3 replies)
  60. Automatic sensitivity assignment in Excel VBA - Blocks automatic processes in VBA (5 replies)
  61. [SOLVED:] Excel not handling large number correctly (3 replies)
  62. [SOLVED:] Press button to assign the reason provided and count (9 replies)
  63. [SOLVED:] Dependant cells (11 replies)
  64. [SOLVED:] Copy and paste vba - Full numbers come out -1 (2 replies)
  65. [SOLVED:] Power Query to transpose a dataset (7 replies)
  66. [SOLVED:] VBA Macro. I Think I'm Close But Something Is Not Right (6 replies)
  67. Change lines in a macro with the same idea but different reordering (0 replies)
  68. Automatic form creation from construction activities list (0 replies)
  69. [SOLVED:] Use an Input box to select a range (7 replies)
  70. [SOLVED:] Transposing data (10 replies)
  71. [SOLVED:] Run-time error 1004 when trying to open a VBA form (8 replies)
  72. [SOLVED:] Should I need a terminate initialisation subset as well? (2 replies)
  73. [SOLVED:] VBA Highlight consequent cells based on value from another cell with criteria (2 replies)
  74. Find duplicates in combobox - get index and remove from other comboboxes. (2 replies)
  75. [SOLVED:] PowerQuery Steps to Move Data (2 replies)
  76. [SOLVED:] Error handling (14 replies)
  77. [SOLVED:] VBA code not work if I change the file name (7 replies)
  78. Feedback for Dashboards (0 replies)
  79. Removing folder and subfolder from hyperlink path (1 replies)
  80. [SLEEPER:] Please make my code for an active workbook (4 replies)
  81. Can't position dialog (2 replies)
  82. [SOLVED:] Appointments Failing to Line up correctly when more than one Appt scheduled in a day (11 replies)
  83. [SOLVED:] Copy Macro based on ActiveCell.Offset(r,c) (2 replies)
  84. Move data from Template A to template B (10 replies)
  85. [SOLVED:] Counting DataValidation Attempts (14 replies)
  86. Sleeper: Pull different numbers from independent lists efficiently (4 replies)
  87. Convert Excel formula to VBA code (1 replies)
  88. Sleeper: Payroll File--Need Help with Formula (15 replies)
  89. [SOLVED:] Standard Deviation of an array (2 replies)
  90. Sleeper: VBA Help on Excel to Web portal (10 replies)
  91. [SOLVED:] Filter function (not VBA) (29 replies)
  92. Sleeper: Reading serial port rs232 vba (3 replies)
  93. Sleeper: Ribbon Menu (4 replies)
  94. VBA formula that creates new workbook from 1 sheet after 1 cell is updated and refres (3 replies)
  95. [SOLVED:] Switching 3 colors on Form (6 replies)
  96. [SOLVED:] Concatenate first 3 letters of first word, and first 3 letters of second word (3 replies)
  97. Sleeper: If and Statement based on one cell and (15 replies)
  98. Sleeper: Draw proper Bezier curves to contruct flow shapes for Sankey chart (4 replies)
  99. [SOLVED:] Trying to reference data from a column of cells in a message box (4 replies)
  100. Sleeper: 'New Outlook' Broken my VBA (10 replies)
  101. [SOLVED:] VBA Code to Send Email Using Excel (7 replies)
  102. Sleeper: AdvancedFilter - limited columns (5 replies)
  103. Sleeper: AdvancedFilter - Removing page (0 replies)
  104. Formula in VBA (2 replies)
  105. [SOLVED:] columns to columns and rows (9 replies)
  106. Create my own permanent Quick Access Data Form on a UserForm in VBA? (0 replies)
  107. Sleeper: Macro to select next result that an xlookup would return (4 replies)
  108. [SOLVED:] Reading items (7 replies)
  109. [SOLVED:] If Cell Contains Any Words Found in the Adjacent Cell (8 replies)
  110. [SOLVED:] All userform controls are "not" working (4 replies)
  111. [SOLVED:] Working with Read-Only Export - Save-As (3 replies)
  112. Array as variable (2 replies)
  113. Is chatGPT the way to go with Excel (6 replies)
  114. [SOLVED:] Interpolation in excel (4 replies)
  115. how do i output an ascii text from excel and maintain proper dimensions (2 replies)
  116. [SOLVED:] How to connect to SQL server over the internet? (2 replies)
  117. [SOLVED:] Insert names found according row . (4 replies)
  118. [SOLVED:] Vertical progress bar with label and changing height - only "grows" downward (6 replies)
  119. transferring a spreadsheet but specifically which sheet (6 replies)
  120. [SOLVED:] Finding wildcards in indexing and aggregate functions. (2 replies)
  121. make a table bigger at the touch of a button (2 replies)
  122. Drag & drop a file to automatically copy it to a destination folder (5 replies)
  123. [SOLVED:] Find Small in and Array (2 replies)
  124. [SOLVED:] Copilot (3 replies)
  125. [SOLVED:] problem adding 2 values ​​in 2 columns (2 replies)
  126. when the checkbox is checked, something must only happen in that row (3 replies)
  127. Error #Value!, vba code trinomial model, Option Put American (5 replies)
  128. [SOLVED:] 'Run time error 1004 method 'range' of object'_worksheet' failed (6 replies)
  129. [SLEEPER:] copy rows with checkbox (5 replies)
  130. [SOLVED:] 'Run time error 438 Object does not support this property or method (2 replies)
  131. [SOLVED:] condition error (3 replies)
  132. [SOLVED:] Copy file from source path in cell, to destination path in cell, and create folders (7 replies)
  133. [SOLVED:] VLOOKUP - Multiply by a percentage if appropriate (2 replies)
  134. [SOLVED:] Formula to match information from a source sheet (17 replies)
  135. Sleeper: Recursive folder search (9 replies)
  136. Find and replace function (not Sub) with VBA (4 replies)
  137. [SOLVED:] Evaluating Lat Long Equations (6 replies)
  138. [SOLVED:] VBA code to replace "1" with "7:00/ 15:30" (18 replies)
  139. [SOLVED:] How do you get Excel VBA to realize the default properties again (9 replies)
  140. Create Hyperlinks based on selection and cell contents (4 replies)
  141. Excel spreadsheet looks different depending on how I open the file. (2 replies)
  142. Execute a function stored in text format (7 replies)
  143. [SOLVED:] Check if Excel cell is not number (4 replies)
  144. [SOLVED:] return TEXT value from MID w integer results (3 replies)
  145. Data transfer from online excel to offline excel only specfic columns (5 replies)
  146. [SOLVED:] Highlight domain (9 replies)
  147. [SOLVED:] Copy active workbook (1 replies)
  148. [SOLVED:] Create a working search box (5 replies)
  149. [SOLVED:] Dynamically locate and copy last number in a column before #N/A error (5 replies)
  150. Need VBA help for Multilevel number according to the document path (2 replies)
  151. [SOLVED:] Need to delete any row with "Daily Ledger Bal' in the 3rd column (6 replies)
  152. From Abbreviation to full form street address Column E (8 replies)
  153. [SOLVED:] remove . from the last of email (2 replies)
  154. [SOLVED:] Dropdown List Copy/Paste to Excel Table on Different Worksheet But in Wrong Column (6 replies)
  155. Split Workwook and save (17 replies)
  156. [SOLVED:] Delete all conditional formatting and coloring conditional on specific rows (25 replies)
  157. [SOLVED:] How to count unique values in a dynamic range (5 replies)
  158. VBA code working on one file, giving error on another (5 replies)
  159. [SOLVED:] Python dictionary in VBA (44 replies)
  160. [SOLVED:] Input box Data entered need code to state you’ve entered Wrong data try again (4 replies)
  161. [SOLVED:] Formula to find single date from multiple dates (10 replies)
  162. [SOLVED:] How to mark a post as solved (2 replies)
  163. [SOLVED:] VBA Excel Match Sets of items in a range (4 replies)
  164. [SOLVED:] Using active cell move entire row from one table to another (3 replies)
  165. [SOLVED:] Stripping certain data from left side of a string (3 replies)
  166. API call, send XML (2 replies)
  167. Circularity Breaker (3 replies)
  168. [SOLVED:] Macro for numbering several levels (3 replies)
  169. accessing data from intranet and copy pasting it into the appropriate cell (2 replies)
  170. Deleting rows in the middle of a table (5 replies)
  171. [SOLVED:] VBA to copy data from source to destination with unique column match (9 replies)
  172. Show Hide ranges with button selection (4 replies)
  173. [SOLVED:] Resize Code Window (4 replies)
  174. VLOOKUP (3 replies)
  175. Iteration Until Conditions Are Met - Need VBA Code (2 replies)
  176. Need Help with the Following Macro--Copy & Paste (4 replies)
  177. Allocation with VBA until limit value is reached (1 replies)
  178. Automating My Excel Project (7 replies)
  179. VBE Programming buttons in Excel (1 replies)
  180. Change Header Name on Worksheet Table from a ListBox (1 replies)
  181. Secondary & primary axes scaling ! (10 replies)
  182. Absolute Cell Reference Using Match (7 replies)
  183. InvalidateControl in Excel not working... not sure what I'm doing wrong (1 replies)
  184. need help to edit code use values instead of coords (1 replies)
  185. sampling -VBA code (0 replies)
  186. Can Not Seem to Get If and ElesIf Statement to Work Correctly (3 replies)
  187. Delete Button on UserForm won't Cooperate (Run-time error ‘1004’, Range Class Failed) (2 replies)
  188. [SOLVED:] Vlookup in Different Workbook - Sheet Looping (3 replies)
  189. Finding duplicates in 6 columns by excel VBA (61 replies)
  190. A macro to show and hide specific rows in specific worksheets (0 replies)
  191. [SOLVED:] Help needed to count duplicates but derived by a column of values (12 replies)
  192. Need Help converting columns to YML format (4 replies)
  193. Quick VBA Question - Adding Another Condition - Use ElseIf? (13 replies)
  194. Convert ASCII code back to text with StrConv + vbUnicode (VBA) (3 replies)
  195. [SOLVED:] Refresh custom formulars that checks background color and output as 1 or 0 (File here (2 replies)
  196. Transfer specific columns from sheet to another (12 replies)
  197. How to calculate a route / find waypoints between start and destination (20 replies)
  198. VBA Form Source List (7 replies)
  199. [SOLVED:] Change active page of Vision object in Excel (2 replies)
  200. [SOLVED:] Code searches entire workbook-Need only specific coulmn + keep formatting after Paste (1 replies)
  201. [SOLVED:] Copy Multiple Range on Multiple Sheets. (3 replies)
  202. [SOLVED:] Delete rows with previous dates (5 replies)
  203. [SOLVED:] Scale display vba code (31 replies)
  204. Transfer data from one work to another (1 replies)
  205. vba print 2 ranges in one page (5 replies)
  206. [SOLVED:] vba code if lastrow is full, it errors out (5 replies)
  207. Using a class module for several userforms, identify which userform is active (5 replies)
  208. [SOLVED:] Shape Colors Updated per Cell Value (150 cells and shapes) (7 replies)
  209. [SOLVED:] Small VBA Macro: introduce cell text into a CountIF formular and get output (5 replies)
  210. [SOLVED:] Help with Code to splitting values into 2 columns (16 replies)
  211. Filter for suffix [x] when a comparing file has _x suffix (4 replies)
  212. VBA - Flat Text Import Changes (4 replies)
  213. [SOLVED:] autofocus on userform after print out (1 replies)
  214. [SOLVED:] Multiple Individual Exclusive Checkboxes with data validation Macro (code here) (2 replies)
  215. [SOLVED:] VBA doesn't compares correctly via greater than string comparison (6 replies)
  216. Need help with sending multiple .bcc from range in excel (1 replies)
  217. macro to add or subtract date and time from yyyymmdd_hhmmss format (1 replies)
  218. DO NOT Copy Data Under Table/ Copy Data from Table to Table (8 replies)
  219. Noob question about Do-Until Loops (2 replies)
  220. Hide/unhide columns (3 replies)
  221. Function behaving differently (12 replies)
  222. excel help (4 replies)
  223. Cannot get Application Caller to work (8 replies)
  224. [SOLVED:] Copy the Last Row Within a Range and Paste to Last Row in Another Sheet (3 replies)
  225. Adding label for msoDropdown control type (13 replies)
  226. Crossposting VBA Question - Overlapping Text Boxes with all Shapes (4 replies)
  227. Move To Top Of The Sheet (1 replies)
  228. Macro That Inserts a New Row and Defines Formulas to Cells (2 replies)
  229. [SOLVED:] Combinng Ranges into One (2 replies)
  230. How to cycle through control sheet in workbook (8 replies)
  231. [SOLVED:] VBA code to search on folder and sub folder for file named in worksheet (5 replies)
  232. Copy the last 3 columns (3 replies)
  233. Replacing hyperlinks with find and Replace (2 replies)
  234. Fiter, Copy and Paste unique values in the next available row of another workbook (0 replies)
  235. VBA Macro Sort Range (10 replies)
  236. Range Address Variables (2 replies)
  237. [SOLVED:] How to assign a worksheet change codes to a button to refresh the values (2 replies)
  238. Add some cell values as notes (5 replies)
  239. Removing leading letters in a text using VBA (4 replies)
  240. Help to fine tune the codes | transform data, delete blank rows and then autofill (4 replies)
  241. help with the debug (2 replies)
  242. VBA - Prompt To Save Excel File In Variable Location (2 replies)
  243. Editable listview items (0 replies)
  244. [SOLVED:] Impossible to insert (8 replies)
  245. [SOLVED:] How to add row in second Sheet using ActiveCell in first sheet? (1 replies)
  246. Insertion range depends on meeting conditions (3 replies)
  247. Reformat found data and count equal 'strings' (1 replies)
  248. Creating a VBA to find and delete duplicate values within Excel workbook (0 replies)
  249. [SOLVED:] Lookup values from a range with partial non-ordered keyword strings (15 replies)
  250. Insert Row & copy and paste formulas in new row (5 replies)