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. Formula in VBA (2 replies)
  2. [SOLVED:] columns to columns and rows (9 replies)
  3. Create my own permanent Quick Access Data Form on a UserForm in VBA? (0 replies)
  4. Sleeper: Macro to select next result that an xlookup would return (4 replies)
  5. [SOLVED:] Reading items (7 replies)
  6. [SOLVED:] If Cell Contains Any Words Found in the Adjacent Cell (8 replies)
  7. [SOLVED:] All userform controls are "not" working (4 replies)
  8. [SOLVED:] Working with Read-Only Export - Save-As (3 replies)
  9. Array as variable (2 replies)
  10. Is chatGPT the way to go with Excel (6 replies)
  11. [SOLVED:] Interpolation in excel (4 replies)
  12. how do i output an ascii text from excel and maintain proper dimensions (2 replies)
  13. [SOLVED:] How to connect to SQL server over the internet? (2 replies)
  14. [SOLVED:] Insert names found according row . (4 replies)
  15. [SOLVED:] Vertical progress bar with label and changing height - only "grows" downward (6 replies)
  16. transferring a spreadsheet but specifically which sheet (6 replies)
  17. [SOLVED:] Finding wildcards in indexing and aggregate functions. (2 replies)
  18. make a table bigger at the touch of a button (2 replies)
  19. Drag & drop a file to automatically copy it to a destination folder (5 replies)
  20. [SOLVED:] Find Small in and Array (2 replies)
  21. [SOLVED:] Copilot (3 replies)
  22. [SOLVED:] problem adding 2 values ​​in 2 columns (2 replies)
  23. when the checkbox is checked, something must only happen in that row (3 replies)
  24. Error #Value!, vba code trinomial model, Option Put American (5 replies)
  25. [SOLVED:] 'Run time error 1004 method 'range' of object'_worksheet' failed (6 replies)
  26. [SLEEPER:] copy rows with checkbox (5 replies)
  27. [SOLVED:] 'Run time error 438 Object does not support this property or method (2 replies)
  28. [SOLVED:] condition error (3 replies)
  29. [SOLVED:] Copy file from source path in cell, to destination path in cell, and create folders (7 replies)
  30. [SOLVED:] VLOOKUP - Multiply by a percentage if appropriate (2 replies)
  31. [SOLVED:] Formula to match information from a source sheet (17 replies)
  32. Sleeper: Recursive folder search (9 replies)
  33. Find and replace function (not Sub) with VBA (4 replies)
  34. [SOLVED:] Evaluating Lat Long Equations (6 replies)
  35. [SOLVED:] VBA code to replace "1" with "7:00/ 15:30" (18 replies)
  36. [SOLVED:] How do you get Excel VBA to realize the default properties again (9 replies)
  37. Create Hyperlinks based on selection and cell contents (4 replies)
  38. Excel spreadsheet looks different depending on how I open the file. (2 replies)
  39. Execute a function stored in text format (7 replies)
  40. [SOLVED:] Check if Excel cell is not number (4 replies)
  41. [SOLVED:] return TEXT value from MID w integer results (3 replies)
  42. Data transfer from online excel to offline excel only specfic columns (5 replies)
  43. [SOLVED:] Highlight domain (9 replies)
  44. [SOLVED:] Copy active workbook (1 replies)
  45. [SOLVED:] Create a working search box (5 replies)
  46. [SOLVED:] Dynamically locate and copy last number in a column before #N/A error (5 replies)
  47. Need VBA help for Multilevel number according to the document path (2 replies)
  48. [SOLVED:] Need to delete any row with "Daily Ledger Bal' in the 3rd column (6 replies)
  49. From Abbreviation to full form street address Column E (8 replies)
  50. [SOLVED:] remove . from the last of email (2 replies)
  51. [SOLVED:] Dropdown List Copy/Paste to Excel Table on Different Worksheet But in Wrong Column (6 replies)
  52. [SLEEPER:] Split Workwook and save (17 replies)
  53. [SOLVED:] Delete all conditional formatting and coloring conditional on specific rows (32 replies)
  54. [SOLVED:] How to count unique values in a dynamic range (5 replies)
  55. VBA code working on one file, giving error on another (5 replies)
  56. [SOLVED:] Python dictionary in VBA (44 replies)
  57. [SOLVED:] Input box Data entered need code to state you’ve entered Wrong data try again (4 replies)
  58. [SOLVED:] Formula to find single date from multiple dates (10 replies)
  59. [SOLVED:] How to mark a post as solved (2 replies)
  60. [SOLVED:] VBA Excel Match Sets of items in a range (4 replies)
  61. [SOLVED:] Using active cell move entire row from one table to another (3 replies)
  62. [SOLVED:] Stripping certain data from left side of a string (3 replies)
  63. API call, send XML (2 replies)
  64. Circularity Breaker (3 replies)
  65. [SOLVED:] Macro for numbering several levels (3 replies)
  66. accessing data from intranet and copy pasting it into the appropriate cell (2 replies)
  67. Deleting rows in the middle of a table (5 replies)
  68. [SOLVED:] VBA to copy data from source to destination with unique column match (9 replies)
  69. Show Hide ranges with button selection (4 replies)
  70. [SOLVED:] Resize Code Window (4 replies)
  71. VLOOKUP (3 replies)
  72. Iteration Until Conditions Are Met - Need VBA Code (2 replies)
  73. Need Help with the Following Macro--Copy & Paste (4 replies)
  74. [SLEEPER:] Allocation with VBA until limit value is reached (1 replies)
  75. Automating My Excel Project (7 replies)
  76. VBE Programming buttons in Excel (1 replies)
  77. Change Header Name on Worksheet Table from a ListBox (1 replies)
  78. Secondary & primary axes scaling ! (10 replies)
  79. Absolute Cell Reference Using Match (7 replies)
  80. InvalidateControl in Excel not working... not sure what I'm doing wrong (1 replies)
  81. need help to edit code use values instead of coords (1 replies)
  82. sampling -VBA code (0 replies)
  83. Can Not Seem to Get If and ElesIf Statement to Work Correctly (3 replies)
  84. Delete Button on UserForm won't Cooperate (Run-time error ‘1004’, Range Class Failed) (2 replies)
  85. [SOLVED:] Vlookup in Different Workbook - Sheet Looping (3 replies)
  86. Finding duplicates in 6 columns by excel VBA (61 replies)
  87. [SLEEPER:] A macro to show and hide specific rows in specific worksheets (0 replies)
  88. [SOLVED:] Help needed to count duplicates but derived by a column of values (12 replies)
  89. Need Help converting columns to YML format (4 replies)
  90. Quick VBA Question - Adding Another Condition - Use ElseIf? (13 replies)
  91. Convert ASCII code back to text with StrConv + vbUnicode (VBA) (3 replies)
  92. [SOLVED:] Refresh custom formulars that checks background color and output as 1 or 0 (File here (2 replies)
  93. Transfer specific columns from sheet to another (12 replies)
  94. How to calculate a route / find waypoints between start and destination (20 replies)
  95. VBA Form Source List (7 replies)
  96. [SOLVED:] Change active page of Vision object in Excel (2 replies)
  97. [SOLVED:] Code searches entire workbook-Need only specific coulmn + keep formatting after Paste (1 replies)
  98. [SOLVED:] Copy Multiple Range on Multiple Sheets. (3 replies)
  99. [SOLVED:] Delete rows with previous dates (5 replies)
  100. [SOLVED:] Scale display vba code (31 replies)
  101. Transfer data from one work to another (1 replies)
  102. vba print 2 ranges in one page (5 replies)
  103. [SOLVED:] vba code if lastrow is full, it errors out (5 replies)
  104. Using a class module for several userforms, identify which userform is active (5 replies)
  105. [SOLVED:] Shape Colors Updated per Cell Value (150 cells and shapes) (7 replies)
  106. [SOLVED:] Small VBA Macro: introduce cell text into a CountIF formular and get output (5 replies)
  107. [SOLVED:] Help with Code to splitting values into 2 columns (16 replies)
  108. Filter for suffix [x] when a comparing file has _x suffix (4 replies)
  109. VBA - Flat Text Import Changes (4 replies)
  110. [SOLVED:] autofocus on userform after print out (1 replies)
  111. [SOLVED:] Multiple Individual Exclusive Checkboxes with data validation Macro (code here) (2 replies)
  112. [SOLVED:] VBA doesn't compares correctly via greater than string comparison (6 replies)
  113. Need help with sending multiple .bcc from range in excel (1 replies)
  114. macro to add or subtract date and time from yyyymmdd_hhmmss format (1 replies)
  115. DO NOT Copy Data Under Table/ Copy Data from Table to Table (8 replies)
  116. Noob question about Do-Until Loops (2 replies)
  117. Hide/unhide columns (3 replies)
  118. Function behaving differently (12 replies)
  119. excel help (4 replies)
  120. Cannot get Application Caller to work (8 replies)
  121. [SOLVED:] Copy the Last Row Within a Range and Paste to Last Row in Another Sheet (3 replies)
  122. Adding label for msoDropdown control type (13 replies)
  123. Crossposting VBA Question - Overlapping Text Boxes with all Shapes (4 replies)
  124. Move To Top Of The Sheet (1 replies)
  125. Macro That Inserts a New Row and Defines Formulas to Cells (2 replies)
  126. [SOLVED:] Combinng Ranges into One (2 replies)
  127. How to cycle through control sheet in workbook (8 replies)
  128. [SOLVED:] VBA code to search on folder and sub folder for file named in worksheet (5 replies)
  129. Copy the last 3 columns (3 replies)
  130. [SLEEPER:] Replacing hyperlinks with find and Replace (2 replies)
  131. Fiter, Copy and Paste unique values in the next available row of another workbook (0 replies)
  132. VBA Macro Sort Range (10 replies)
  133. Range Address Variables (2 replies)
  134. [SOLVED:] How to assign a worksheet change codes to a button to refresh the values (2 replies)
  135. Add some cell values as notes (5 replies)
  136. Removing leading letters in a text using VBA (4 replies)
  137. [SOLVED:] Help to fine tune the codes | transform data, delete blank rows and then autofill (4 replies)
  138. help with the debug (2 replies)
  139. VBA - Prompt To Save Excel File In Variable Location (2 replies)
  140. Editable listview items (0 replies)
  141. [SOLVED:] Impossible to insert (8 replies)
  142. [SOLVED:] How to add row in second Sheet using ActiveCell in first sheet? (1 replies)
  143. Insertion range depends on meeting conditions (3 replies)
  144. Reformat found data and count equal 'strings' (1 replies)
  145. Creating a VBA to find and delete duplicate values within Excel workbook (0 replies)
  146. [SOLVED:] Lookup values from a range with partial non-ordered keyword strings (15 replies)
  147. Insert Row & copy and paste formulas in new row (5 replies)
  148. [SOLVED:] Can't loop a macro (11 replies)
  149. Break record row into multiple rows (7 replies)
  150. Macro called from Menu no longer responding (2 replies)
  151. [SOLVED:] Problem in concatenate (10 replies)
  152. Modeless Form Closing (1 replies)
  153. Help duplicating from one cell onto multiple rows (1 replies)
  154. How to make a macro work in selected worksheets and how to fix a macro error from CF (8 replies)
  155. Dynamic update for each userform textbox through looping (1 replies)
  156. Haven't encountered this before, what does it mean? (5 replies)
  157. Precedents arrows state (4 replies)
  158. [SOLVED:] Can a Header (8 replies)
  159. [SOLVED:] Code only doing it for cell not entire column (2 replies)
  160. VBA code (11 replies)
  161. [SOLVED:] Pin Folder to Windows Explorers Quick Access in VBA (5 replies)
  162. [SOLVED:] IF Else statement not executing properly (2 replies)
  163. [SOLVED:] Extract a number from text in cell using VBA (3 replies)
  164. [SOLVED:] Msg error: "Exception from HRESULT:0x800401A8" when refreshing reports automatically (2 replies)
  165. Sorting and cutting part of the sort into a new tab (2 replies)
  166. Sleeper: Linear interpolation in Excel (6 replies)
  167. Sorting two way pivot table with VBA? (3 replies)
  168. Sleeper: VBA using Loop (5 replies)
  169. Transferring data workbook to workbook (2 replies)
  170. [SOLVED:] Help with simplifying my background substraction (data analysis) (4 replies)
  171. How can we use VBA/Macros Excel for solving this interesting simulation question? (3 replies)
  172. errors on Macro code for consolidation (1 replies)
  173. [SLEEPER:] Compare the selected item of a listbox with a table (1 replies)
  174. Unrecognized text on different computer (5 replies)
  175. After user clicks 'Notify', do this (2 replies)
  176. [SLEEPER:] Macro not working for fetching data from Active Directory (7 replies)
  177. Reference a cell. (2 replies)
  178. [SOLVED:] Formula to format the cell? (so text gets enough space) (4 replies)
  179. [SOLVED:] Repeat Search Function (3 replies)
  180. [SOLVED:] Sort range from one empty row to the next empty row Custom (3 replies)
  181. Simple code that refreshes link to another excel file with Password (2 replies)
  182. [SOLVED:] Making a function based on Find having IF (3 replies)
  183. [SOLVED:] Conditional Formatting borders around cells with formulas (4 replies)
  184. [SOLVED:] Keycode 13 only for textbox input on userform (1 replies)
  185. Method 'SaveAs' of object'_Workbook failed (10 replies)
  186. VBA Code for PDF of Vibile Sheets in array (6 replies)
  187. Create a Userform with a Textbox and link it to a Cell or Table (1 replies)
  188. VBA Code for Highlighting Cells based on If then Rules (6 replies)
  189. Using VBA Set for workbook and worksheet (26 replies)
  190. Linear interpolation with lookup of two values (0 replies)
  191. Item number with current month (3 replies)
  192. [SOLVED:] Move data around in workbook (9 replies)
  193. how to create a portfolio Optimimizer using VBA (2 replies)
  194. [SOLVED:] Formula to FIND specific TEXT within a worksheet (7 replies)
  195. Log Scale graph in excel (1 replies)
  196. VBA - Problem in .range (2 replies)
  197. [SLEEPER:] Loop between two tables to sum their matches (4 replies)
  198. Retrieve formulas and autocomplete (0 replies)
  199. [SOLVED:] show multiple separate information (0 replies)
  200. [SOLVED:] Fastest way to transform data (9 replies)
  201. Picture shows in userform with search (14 replies)
  202. Does anyone else have this error 1004? (5 replies)
  203. code to setup crop dimension (2 replies)
  204. Lookup to add Products from one table to another VBA (9 replies)
  205. Help : Error on saving workbook to dektop synced with OneDrive (1 replies)
  206. VBA - Range of object _ Global failed (3 replies)
  207. Can I add cell info into a comment box via a formula? (1 replies)
  208. [SOLVED:] VBA - function Vlookup (3 replies)
  209. Copying values from one column in a sheet to another column in another sheet once. (3 replies)
  210. How to Solve using CurrentRegion if cells in Table is Protected (2 replies)
  211. Using the TEXT function and Concatenate function in one formula (2 replies)
  212. Copy data from user selected source file to current open workbook (0 replies)
  213. [SOLVED:] Putting Values with Leading Zeros Into CSV file (7 replies)
  214. Why do macros work once and then stop? Example is included (3 replies)
  215. How do I get one cell color to change based on another cell color that changes? (7 replies)
  216. [SOLVED:] Finding Shape types WITHOUT selecting the shape ? (2 replies)
  217. [SLEEPER:] VBA Help to change Form of Smart Art Nodes (0 replies)
  218. [SOLVED:] Saving is not creating a new record line, but saving over it (9 replies)
  219. Vlookup to ListObject "Table copy, paste" (1 replies)
  220. [SLEEPER:] VBA Email TO Cell that contains IF formula (4 replies)
  221. VBA Code for pasting today's date into a text box (4 replies)
  222. [SOLVED:] Pivot table (1 replies)
  223. Making code more concise - VBA scrape information (4 replies)
  224. [SOLVED:] How to save multiple selected information from a LISTBOX? (1 replies)
  225. A search code with three possible results (5 replies)
  226. Filter By Multiple Criteria then match results to different workbook & paste new data (19 replies)
  227. Price List Comparator (2 replies)
  228. Filter values ​​from a table and display them in different textboxes (0 replies)
  229. [SOLVED:] Cross section by matching column and row headings (4 replies)
  230. Excel counts a blank as zero. Why not leave it as a blank? (2 replies)
  231. Automatically delete rows after time period using time stamp (have partial code) (2 replies)
  232. Worksheet Change Referencing Cell in Another Sheet (4 replies)
  233. insert selected row from listbox to excel table (5 replies)
  234. HLEP!! I need help modifying this code. (0 replies)
  235. VBA Help on drop down list (10 replies)
  236. Need vba to code to split data depends upon col I:I and col J:J (4 replies)
  237. Help needed- Analysis of splitting of orders (28 replies)
  238. [SOLVED:] How to pull information from different columns of data from the same row? (1 replies)
  239. [SOLVED:] Help for viable registration solution and code improvement (1 replies)
  240. [SOLVED:] IF Countif and Textjoin - Help required (14 replies)
  241. [SOLVED:] how to force users to enable macros (4 replies)
  242. [SLEEPER:] How to convert number of color to RGB? (14 replies)
  243. [SOLVED:] How to range table "t" from ActiveSheet "Charts"? (3 replies)
  244. Doppelte Einträge zusammenfassen (14 replies)
  245. Can someone recommand an obfuscator for xlsm? (10 replies)
  246. check if serial number is repeated (7 replies)
  247. [SOLVED:] AutoComplete doesn't recognize Cell A1, it starts getting information from the second (14 replies)
  248. Image embed (0 replies)
  249. [SOLVED:] Every time you open the UseForm, it generates a new code (3 replies)
  250. Return latest result for work schedule (1 replies)