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. [SOLVED:] Which is Faster? (7 replies)
  2. [SOLVED:] "This Workbook" script ignored on opening (4 replies)
  3. [SOLVED:] VBA Excel - For... next instruction (5 replies)
  4. [SOLVED:] Application level click event for shape (2 replies)
  5. [SOLVED:] Combine 2 ranges, compare and take the unique values (11 replies)
  6. Beginner help with VBA (2 replies)
  7. [SOLVED:] Pick multiple file extensions in msoFileDialogFolderPicker (7 replies)
  8. [SOLVED:] VBA - how to change Text Box to date format (4 replies)
  9. vba borders and conditional formatting (4 replies)
  10. Need Help Converting a JSON file to new format (2 replies)
  11. [SOLVED:] Reoccurring Corrupt files (4 replies)
  12. Error when trying to access .ChartData.Workbook for Map Charts (ChartType=xlRegionMap (3 replies)
  13. Need a button to do all the work (4 replies)
  14. RANGE FILL BASED ON CELL VALUES (2 replies)
  15. [SOLVED:] I need VBA to delete lines related to date (3 replies)
  16. Split two different columns with two different addresses (5 replies)
  17. VBA : Input form : Copy column and paste special value in another column (4 replies)
  18. VBA - define variables for shape names & use in a loop function (8 replies)
  19. Converting 32-bit to 64-bit VBA code (3 replies)
  20. Prepare Profit and Loss Statement (2 replies)
  21. [SOLVED:] VBA Code to call another VBA function when certain cells match a given criteria (25 replies)
  22. help with detrended fluctuatin analysis (3 replies)
  23. Vba to copy range from Sheet to another and define a name (4 replies)
  24. [SOLVED:] VBA - Remove Duplicate rows from an entire worksheet (3 replies)
  25. [SOLVED:] Help with a Macro to insert a column of a fairly complicated Date/Time function (3 replies)
  26. Perform basic operations basen on a cell (2 replies)
  27. [SOLVED:] Failed to run codes from txt file (8 replies)
  28. [SOLVED:] VBA Code to Copy UserForm Textbox data to specific Excel sheet/cells (4 replies)
  29. [SOLVED:] Return Subtotal for Table Columns (3 replies)
  30. Optimization of newton-raphson iterative solution with excel solver vba (1 replies)
  31. VBA dictionary concept problem (4 replies)
  32. [SOLVED:] List the 2nd Tuesday of the month for the next 12 months - Calculation Error (9 replies)
  33. Macro to apply MP3 tags changes with VBA (5 replies)
  34. [SOLVED:] Pivot table filter based on value using VBA code (5 replies)
  35. [SOLVED:] Transfer columns from comparable workbook if cell value exists (9 replies)
  36. Scan and copy in same worksheet (0 replies)
  37. Pulling data from another workbook and worksheet (3 replies)
  38. Pull information from selected row via listbox (3 replies)
  39. Extracting Financial Data From PDF (2 replies)
  40. Unprotect sheet for certain users upon start up (2 replies)
  41. A1 RECTANGULAR B1 APPLY (7 replies)
  42. [SLEEPER:] Copy data including coloured cells automatically to another sheet (2 replies)
  43. [SOLVED:] VBA - Search explorer for keyword and return file path (3 replies)
  44. [SOLVED:] Split Text File Into Multiple Text Files keeping the header row (13 replies)
  45. Moving rows when cell value is changed (1 replies)
  46. VBA User form error when saving data to a table (3 replies)
  47. [SOLVED:] dynamically call sub via string (12 replies)
  48. Looping through textboxes to copy files and send emails. (5 replies)
  49. [SOLVED:] Stuck on sorting array (3 replies)
  50. [SOLVED:] VBA display pictures in a table (7 replies)
  51. [SOLVED:] Clearing clipboard performance (7 replies)
  52. Syntax issue (6 replies)
  53. Run time error 91 object variables not set (17 replies)
  54. Create new column in excel when email received. (6 replies)
  55. Excel VB Macro Help (2 replies)
  56. [SOLVED:] Need help: debug/fix VBA code to create new worksheets from template and names list (6 replies)
  57. [SOLVED:] Problem with Query Filters on Excel (4 replies)
  58. Command button to download all attachments recieved today from a specific sender. (12 replies)
  59. Excel Not Changing Serial Date to Formatted Date (4 replies)
  60. [SOLVED:] IF statment nested within VBA Code (71 replies)
  61. Workaround to Create a Checkbox in a table with cells(A:A) (2 replies)
  62. [SOLVED:] VBA help - New row in excel with predefined data (4 replies)
  63. Why cannot print PDF (4 replies)
  64. VBAcode to switch(show and hide) between 4 sum value fields on a data mod pivot table (3 replies)
  65. [SLEEPER:] Row protection based on specific cell (6 replies)
  66. [SOLVED:] Non-VBA question for Conditional Formatting (3 replies)
  67. [SOLVED:] VBA Combination/Posibility problem with and "not equal/OR" (10 replies)
  68. Generating and populating a table based on list of values in another workbook. (4 replies)
  69. Modules and forms autoupdate (1 replies)
  70. [SOLVED:] Auto commentary function (4 replies)
  71. need help in looping (13 replies)
  72. Use Excel VBA to extract fund size data (10 replies)
  73. Next Help to fix VBA please? (3 replies)
  74. Need help with the following code--To Save and Close (3 replies)
  75. Export bespoke PDF macro (0 replies)
  76. [SOLVED:] Compare each Value from a Row with Values in a Range (11 replies)
  77. Sleeper: Inserting a Row under a Specified Value (4 replies)
  78. Sum of arrays (5 replies)
  79. [SOLVED:] Why doesn't the macro I created work on all of my sheets. (4 replies)
  80. VBA copies random rows to new sheet (0 replies)
  81. how to merge two VBA codes in one? (6 replies)
  82. Sleeper: Reset CommandButton Caption after creating PDF (2 replies)
  83. [SOLVED:] VBA code not working (8 replies)
  84. Creating a macro to highlight cells in one sheet using info provided in another sheet (5 replies)
  85. How to save multiple output excel in single folder in the given format (2 replies)
  86. ActiveWorkbook.SaveAs not working with folder (2 replies)
  87. [SOLVED:] Create Named Ranges from worksheet list (5 replies)
  88. [SOLVED:] Help needed to find matching string from the collection. (30 replies)
  89. userform close when i close another excel file (5 replies)
  90. [SOLVED:] Excel VBA NOT LOOPING (3 replies)
  91. [SOLVED:] Open file with vba based on file name (3 replies)
  92. VBA and Highlight function has stopped the Undo Funciton (15 replies)
  93. Cannot find the Chrome binary (2 replies)
  94. Could not find installable isam when connecting Excel 2016 to SharePoint 1016 lists (0 replies)
  95. Split file with multiple sheets into new workbooks based on column value (0 replies)
  96. [SOLVED:] Subtracting Single and Formular values (5 replies)
  97. Sleeper: VBA to continuously click email hyperlink (4 replies)
  98. Need help with VBA (1 replies)
  99. [SOLVED:] Macro to import historical data using web query (9 replies)
  100. [SOLVED:] Inserting Date Last Modified in lots of excel files without opening (24 replies)
  101. VBA module to Macro short cut and sharing to multiple users (16 replies)
  102. [SOLVED:] How to search text in pdf files in one folder (1 replies)
  103. Hide unhide sheets with navigation buttons (1 replies)
  104. [SOLVED:] Why does this work? Replacing IF with Text (8 replies)
  105. [SOLVED:] Saving index to a variable prior to closing the file (2 replies)
  106. [SOLVED:] Close Specific Workbooks Without Saving (22 replies)
  107. [SOLVED:] Summing dynamic Excel column and count (17 replies)
  108. Command Button (3 replies)
  109. [SOLVED:] VBA Hyperlink not working (4 replies)
  110. [SOLVED:] Help with Convert a formula (5 replies)
  111. [SOLVED:] Incrementing a list on clicking a macro button (10 replies)
  112. [SOLVED:] Incrementing value in a cell depending on clicking of a macro button (3 replies)
  113. circular flow diagram (4 replies)
  114. Sleeper: Method to show exponential growth in population (1 replies)
  115. How to create a module to find missing brands and models (look through table 1, compa (2 replies)
  116. [SOLVED:] Update Excel table from a one column range on a different sheet (6 replies)
  117. [SOLVED:] Pivot table showing how a Batsman was given out (6 replies)
  118. [SOLVED:] Existing macro to password protect sheets has stopped working (6 replies)
  119. How to.. Macros only running one active worksheet (2 replies)
  120. Sleeper: Change Cell's named reference via VBA (3 replies)
  121. [SOLVED:] Join Lines (2 replies)
  122. Adding worksheets to a Listbox (14 replies)
  123. [SOLVED:] VBA sub - result in run-time error 9, but code looks good (6 replies)
  124. Sleeper: VBA Change Line colors (12 replies)
  125. Sleeper: Loop for copying and pasting tables (4 replies)
  126. [SOLVED:] Macro Codes for auto fit columns and rows (5 replies)
  127. Sleeper: VBA code to un-merge cells from a Database (4 replies)
  128. [SOLVED:] how to enable macro button for every sheet (2 replies)
  129. Convert Index Match to a regular excel reference (8 replies)
  130. Table format to rows Macro (5 replies)
  131. Simplification of Repetative Actions on 2 sets of Different Ranges (14 replies)
  132. [SOLVED:] Select row apart from a merged area (4 replies)
  133. Sleeper: Excel's Formula by Example (1 replies)
  134. [SOLVED:] Counts min and max quantity of equals 'strings' based on a filter column (10 replies)
  135. [SOLVED:] Custom Function Wtih Range in Another Sheet (3 replies)
  136. Moving file to folder with first couple matching characters (2 replies)
  137. Sleeper: Need some help with arrays and loops (3 replies)
  138. Oddly slow running code, under very specific circumstances (9 replies)
  139. Hide the Macro form Dialog Box (4 replies)
  140. Changing excel version with macros (2 replies)
  141. Switching Between Two Already Open Apps (3 replies)
  142. Automatic sensitivity assignment in Excel VBA - Blocks automatic processes in VBA (5 replies)
  143. [SOLVED:] Excel not handling large number correctly (3 replies)
  144. [SOLVED:] Press button to assign the reason provided and count (9 replies)
  145. [SOLVED:] Dependant cells (11 replies)
  146. [SOLVED:] Copy and paste vba - Full numbers come out -1 (2 replies)
  147. [SOLVED:] Power Query to transpose a dataset (7 replies)
  148. [SOLVED:] VBA Macro. I Think I'm Close But Something Is Not Right (6 replies)
  149. Change lines in a macro with the same idea but different reordering (0 replies)
  150. Automatic form creation from construction activities list (0 replies)
  151. [SOLVED:] Use an Input box to select a range (7 replies)
  152. [SOLVED:] Transposing data (10 replies)
  153. [SOLVED:] Run-time error 1004 when trying to open a VBA form (8 replies)
  154. [SOLVED:] Should I need a terminate initialisation subset as well? (2 replies)
  155. [SOLVED:] VBA Highlight consequent cells based on value from another cell with criteria (2 replies)
  156. Find duplicates in combobox - get index and remove from other comboboxes. (2 replies)
  157. [SOLVED:] PowerQuery Steps to Move Data (2 replies)
  158. [SOLVED:] Error handling (14 replies)
  159. [SOLVED:] VBA code not work if I change the file name (7 replies)
  160. Feedback for Dashboards (0 replies)
  161. Removing folder and subfolder from hyperlink path (1 replies)
  162. [SLEEPER:] Please make my code for an active workbook (4 replies)
  163. Can't position dialog (2 replies)
  164. [SOLVED:] Appointments Failing to Line up correctly when more than one Appt scheduled in a day (11 replies)
  165. [SOLVED:] Copy Macro based on ActiveCell.Offset(r,c) (2 replies)
  166. Move data from Template A to template B (10 replies)
  167. [SOLVED:] Counting DataValidation Attempts (14 replies)
  168. Sleeper: Pull different numbers from independent lists efficiently (4 replies)
  169. Convert Excel formula to VBA code (1 replies)
  170. Sleeper: Payroll File--Need Help with Formula (15 replies)
  171. [SOLVED:] Standard Deviation of an array (2 replies)
  172. Sleeper: VBA Help on Excel to Web portal (10 replies)
  173. [SOLVED:] Filter function (not VBA) (29 replies)
  174. Sleeper: Reading serial port rs232 vba (3 replies)
  175. Sleeper: Ribbon Menu (4 replies)
  176. VBA formula that creates new workbook from 1 sheet after 1 cell is updated and refres (3 replies)
  177. [SOLVED:] Switching 3 colors on Form (6 replies)
  178. [SOLVED:] Concatenate first 3 letters of first word, and first 3 letters of second word (3 replies)
  179. Sleeper: If and Statement based on one cell and (15 replies)
  180. Sleeper: Draw proper Bezier curves to contruct flow shapes for Sankey chart (4 replies)
  181. [SOLVED:] Trying to reference data from a column of cells in a message box (4 replies)
  182. Sleeper: 'New Outlook' Broken my VBA (10 replies)
  183. [SOLVED:] VBA Code to Send Email Using Excel (7 replies)
  184. Sleeper: AdvancedFilter - limited columns (5 replies)
  185. Sleeper: AdvancedFilter - Removing page (0 replies)
  186. Formula in VBA (2 replies)
  187. [SOLVED:] columns to columns and rows (9 replies)
  188. Create my own permanent Quick Access Data Form on a UserForm in VBA? (0 replies)
  189. Sleeper: Macro to select next result that an xlookup would return (4 replies)
  190. [SOLVED:] Reading items (7 replies)
  191. [SOLVED:] If Cell Contains Any Words Found in the Adjacent Cell (8 replies)
  192. [SOLVED:] All userform controls are "not" working (4 replies)
  193. [SOLVED:] Working with Read-Only Export - Save-As (3 replies)
  194. Array as variable (2 replies)
  195. Is chatGPT the way to go with Excel (6 replies)
  196. [SOLVED:] Interpolation in excel (4 replies)
  197. how do i output an ascii text from excel and maintain proper dimensions (2 replies)
  198. [SOLVED:] How to connect to SQL server over the internet? (2 replies)
  199. [SOLVED:] Insert names found according row . (4 replies)
  200. [SOLVED:] Vertical progress bar with label and changing height - only "grows" downward (6 replies)
  201. transferring a spreadsheet but specifically which sheet (6 replies)
  202. [SOLVED:] Finding wildcards in indexing and aggregate functions. (2 replies)
  203. make a table bigger at the touch of a button (2 replies)
  204. Drag & drop a file to automatically copy it to a destination folder (5 replies)
  205. [SOLVED:] Find Small in and Array (2 replies)
  206. [SOLVED:] Copilot (3 replies)
  207. [SOLVED:] problem adding 2 values ​​in 2 columns (2 replies)
  208. when the checkbox is checked, something must only happen in that row (3 replies)
  209. Error #Value!, vba code trinomial model, Option Put American (5 replies)
  210. [SOLVED:] 'Run time error 1004 method 'range' of object'_worksheet' failed (6 replies)
  211. [SLEEPER:] copy rows with checkbox (5 replies)
  212. [SOLVED:] 'Run time error 438 Object does not support this property or method (2 replies)
  213. [SOLVED:] condition error (3 replies)
  214. [SOLVED:] Copy file from source path in cell, to destination path in cell, and create folders (7 replies)
  215. [SOLVED:] VLOOKUP - Multiply by a percentage if appropriate (2 replies)
  216. [SOLVED:] Formula to match information from a source sheet (17 replies)
  217. Sleeper: Recursive folder search (9 replies)
  218. Find and replace function (not Sub) with VBA (4 replies)
  219. [SOLVED:] Evaluating Lat Long Equations (6 replies)
  220. [SOLVED:] VBA code to replace "1" with "7:00/ 15:30" (18 replies)
  221. [SOLVED:] How do you get Excel VBA to realize the default properties again (9 replies)
  222. Create Hyperlinks based on selection and cell contents (4 replies)
  223. Excel spreadsheet looks different depending on how I open the file. (2 replies)
  224. Execute a function stored in text format (7 replies)
  225. [SOLVED:] Check if Excel cell is not number (4 replies)
  226. [SOLVED:] return TEXT value from MID w integer results (3 replies)
  227. Data transfer from online excel to offline excel only specfic columns (5 replies)
  228. [SOLVED:] Highlight domain (9 replies)
  229. [SOLVED:] Copy active workbook (1 replies)
  230. [SOLVED:] Create a working search box (5 replies)
  231. [SOLVED:] Dynamically locate and copy last number in a column before #N/A error (5 replies)
  232. Need VBA help for Multilevel number according to the document path (2 replies)
  233. [SOLVED:] Need to delete any row with "Daily Ledger Bal' in the 3rd column (6 replies)
  234. From Abbreviation to full form street address Column E (8 replies)
  235. [SOLVED:] remove . from the last of email (2 replies)
  236. [SOLVED:] Dropdown List Copy/Paste to Excel Table on Different Worksheet But in Wrong Column (6 replies)
  237. [SLEEPER:] Split Workwook and save (17 replies)
  238. [SOLVED:] Delete all conditional formatting and coloring conditional on specific rows (32 replies)
  239. [SOLVED:] How to count unique values in a dynamic range (5 replies)
  240. VBA code working on one file, giving error on another (5 replies)
  241. [SOLVED:] Python dictionary in VBA (44 replies)
  242. [SOLVED:] Input box Data entered need code to state you’ve entered Wrong data try again (4 replies)
  243. [SOLVED:] Formula to find single date from multiple dates (10 replies)
  244. [SOLVED:] How to mark a post as solved (2 replies)
  245. [SOLVED:] VBA Excel Match Sets of items in a range (4 replies)
  246. [SOLVED:] Using active cell move entire row from one table to another (3 replies)
  247. [SOLVED:] Stripping certain data from left side of a string (3 replies)
  248. API call, send XML (2 replies)
  249. Circularity Breaker (3 replies)
  250. [SOLVED:] Macro for numbering several levels (3 replies)