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. accessing data from intranet and copy pasting it into the appropriate cell (2 replies)
  2. Deleting rows in the middle of a table (5 replies)
  3. [SOLVED:] VBA to copy data from source to destination with unique column match (9 replies)
  4. Show Hide ranges with button selection (4 replies)
  5. [SOLVED:] Resize Code Window (4 replies)
  6. VLOOKUP (3 replies)
  7. Iteration Until Conditions Are Met - Need VBA Code (2 replies)
  8. Need Help with the Following Macro--Copy & Paste (4 replies)
  9. Allocation with VBA until limit value is reached (1 replies)
  10. Automating My Excel Project (7 replies)
  11. VBE Programming buttons in Excel (1 replies)
  12. Change Header Name on Worksheet Table from a ListBox (1 replies)
  13. Secondary & primary axes scaling ! (10 replies)
  14. Absolute Cell Reference Using Match (7 replies)
  15. InvalidateControl in Excel not working... not sure what I'm doing wrong (1 replies)
  16. need help to edit code use values instead of coords (1 replies)
  17. sampling -VBA code (0 replies)
  18. Can Not Seem to Get If and ElesIf Statement to Work Correctly (3 replies)
  19. Delete Button on UserForm won't Cooperate (Run-time error ‘1004’, Range Class Failed) (2 replies)
  20. [SOLVED:] Vlookup in Different Workbook - Sheet Looping (3 replies)
  21. Finding duplicates in 6 columns by excel VBA (61 replies)
  22. [SLEEPER:] A macro to show and hide specific rows in specific worksheets (0 replies)
  23. [SOLVED:] Help needed to count duplicates but derived by a column of values (12 replies)
  24. Need Help converting columns to YML format (4 replies)
  25. Quick VBA Question - Adding Another Condition - Use ElseIf? (13 replies)
  26. Convert ASCII code back to text with StrConv + vbUnicode (VBA) (3 replies)
  27. [SOLVED:] Refresh custom formulars that checks background color and output as 1 or 0 (File here (2 replies)
  28. Transfer specific columns from sheet to another (12 replies)
  29. How to calculate a route / find waypoints between start and destination (20 replies)
  30. VBA Form Source List (7 replies)
  31. [SOLVED:] Change active page of Vision object in Excel (2 replies)
  32. [SOLVED:] Code searches entire workbook-Need only specific coulmn + keep formatting after Paste (1 replies)
  33. [SOLVED:] Copy Multiple Range on Multiple Sheets. (3 replies)
  34. [SOLVED:] Delete rows with previous dates (5 replies)
  35. [SOLVED:] Scale display vba code (31 replies)
  36. Transfer data from one work to another (1 replies)
  37. vba print 2 ranges in one page (5 replies)
  38. [SOLVED:] vba code if lastrow is full, it errors out (5 replies)
  39. Using a class module for several userforms, identify which userform is active (5 replies)
  40. [SOLVED:] Shape Colors Updated per Cell Value (150 cells and shapes) (7 replies)
  41. [SOLVED:] Small VBA Macro: introduce cell text into a CountIF formular and get output (5 replies)
  42. [SOLVED:] Help with Code to splitting values into 2 columns (16 replies)
  43. Filter for suffix [x] when a comparing file has _x suffix (4 replies)
  44. VBA - Flat Text Import Changes (4 replies)
  45. [SOLVED:] autofocus on userform after print out (1 replies)
  46. [SOLVED:] Multiple Individual Exclusive Checkboxes with data validation Macro (code here) (2 replies)
  47. [SOLVED:] VBA doesn't compares correctly via greater than string comparison (6 replies)
  48. Need help with sending multiple .bcc from range in excel (1 replies)
  49. macro to add or subtract date and time from yyyymmdd_hhmmss format (1 replies)
  50. DO NOT Copy Data Under Table/ Copy Data from Table to Table (8 replies)
  51. Noob question about Do-Until Loops (2 replies)
  52. Hide/unhide columns (3 replies)
  53. Function behaving differently (12 replies)
  54. excel help (4 replies)
  55. Cannot get Application Caller to work (8 replies)
  56. [SOLVED:] Copy the Last Row Within a Range and Paste to Last Row in Another Sheet (3 replies)
  57. Adding label for msoDropdown control type (13 replies)
  58. Crossposting VBA Question - Overlapping Text Boxes with all Shapes (4 replies)
  59. Move To Top Of The Sheet (1 replies)
  60. Macro That Inserts a New Row and Defines Formulas to Cells (2 replies)
  61. [SOLVED:] Combinng Ranges into One (2 replies)
  62. How to cycle through control sheet in workbook (8 replies)
  63. [SOLVED:] VBA code to search on folder and sub folder for file named in worksheet (5 replies)
  64. Copy the last 3 columns (3 replies)
  65. Replacing hyperlinks with find and Replace (2 replies)
  66. Fiter, Copy and Paste unique values in the next available row of another workbook (0 replies)
  67. VBA Macro Sort Range (10 replies)
  68. Range Address Variables (2 replies)
  69. [SOLVED:] How to assign a worksheet change codes to a button to refresh the values (2 replies)
  70. Add some cell values as notes (5 replies)
  71. Removing leading letters in a text using VBA (4 replies)
  72. Help to fine tune the codes | transform data, delete blank rows and then autofill (4 replies)
  73. help with the debug (2 replies)
  74. VBA - Prompt To Save Excel File In Variable Location (2 replies)
  75. Editable listview items (0 replies)
  76. [SOLVED:] Impossible to insert (8 replies)
  77. [SOLVED:] How to add row in second Sheet using ActiveCell in first sheet? (1 replies)
  78. Insertion range depends on meeting conditions (3 replies)
  79. Reformat found data and count equal 'strings' (1 replies)
  80. Creating a VBA to find and delete duplicate values within Excel workbook (0 replies)
  81. [SOLVED:] Lookup values from a range with partial non-ordered keyword strings (15 replies)
  82. Insert Row & copy and paste formulas in new row (5 replies)
  83. [SOLVED:] Can't loop a macro (11 replies)
  84. Break record row into multiple rows (7 replies)
  85. Macro called from Menu no longer responding (2 replies)
  86. [SOLVED:] Problem in concatenate (10 replies)
  87. Modeless Form Closing (1 replies)
  88. Help duplicating from one cell onto multiple rows (1 replies)
  89. How to make a macro work in selected worksheets and how to fix a macro error from CF (8 replies)
  90. Dynamic update for each userform textbox through looping (1 replies)
  91. Haven't encountered this before, what does it mean? (5 replies)
  92. Precedents arrows state (4 replies)
  93. [SOLVED:] Can a Header (8 replies)
  94. [SOLVED:] Code only doing it for cell not entire column (2 replies)
  95. VBA code (11 replies)
  96. [SOLVED:] Pin Folder to Windows Explorers Quick Access in VBA (5 replies)
  97. [SOLVED:] IF Else statement not executing properly (2 replies)
  98. Extract a number from text in cell using VBA (3 replies)
  99. [SOLVED:] Msg error: "Exception from HRESULT:0x800401A8" when refreshing reports automatically (2 replies)
  100. Sorting and cutting part of the sort into a new tab (2 replies)
  101. Sleeper: Linear interpolation in Excel (6 replies)
  102. Sorting two way pivot table with VBA? (3 replies)
  103. Sleeper: VBA using Loop (5 replies)
  104. Transferring data workbook to workbook (2 replies)
  105. [SOLVED:] Help with simplifying my background substraction (data analysis) (4 replies)
  106. How can we use VBA/Macros Excel for solving this interesting simulation question? (3 replies)
  107. errors on Macro code for consolidation (1 replies)
  108. [SLEEPER:] Compare the selected item of a listbox with a table (1 replies)
  109. Unrecognized text on different computer (5 replies)
  110. After user clicks 'Notify', do this (2 replies)
  111. Macro not working for fetching data from Active Directory (7 replies)
  112. Reference a cell. (2 replies)
  113. [SOLVED:] Formula to format the cell? (so text gets enough space) (4 replies)
  114. [SOLVED:] Repeat Search Function (3 replies)
  115. [SOLVED:] Sort range from one empty row to the next empty row Custom (3 replies)
  116. Simple code that refreshes link to another excel file with Password (2 replies)
  117. [SOLVED:] Making a function based on Find having IF (3 replies)
  118. [SOLVED:] Conditional Formatting borders around cells with formulas (4 replies)
  119. [SOLVED:] Keycode 13 only for textbox input on userform (1 replies)
  120. Method 'SaveAs' of object'_Workbook failed (10 replies)
  121. VBA Code for PDF of Vibile Sheets in array (6 replies)
  122. Create a Userform with a Textbox and link it to a Cell or Table (1 replies)
  123. VBA Code for Highlighting Cells based on If then Rules (6 replies)
  124. Using VBA Set for workbook and worksheet (26 replies)
  125. Linear interpolation with lookup of two values (0 replies)
  126. Item number with current month (3 replies)
  127. [SOLVED:] Move data around in workbook (9 replies)
  128. how to create a portfolio Optimimizer using VBA (2 replies)
  129. [SOLVED:] Formula to FIND specific TEXT within a worksheet (7 replies)
  130. Log Scale graph in excel (1 replies)
  131. VBA - Problem in .range (2 replies)
  132. [SLEEPER:] Loop between two tables to sum their matches (4 replies)
  133. Retrieve formulas and autocomplete (0 replies)
  134. [SOLVED:] show multiple separate information (0 replies)
  135. [SOLVED:] Fastest way to transform data (9 replies)
  136. Picture shows in userform with search (14 replies)
  137. Does anyone else have this error 1004? (5 replies)
  138. code to setup crop dimension (2 replies)
  139. Lookup to add Products from one table to another VBA (9 replies)
  140. Help : Error on saving workbook to dektop synced with OneDrive (1 replies)
  141. VBA - Range of object _ Global failed (3 replies)
  142. Can I add cell info into a comment box via a formula? (1 replies)
  143. VBA - function Vlookup (3 replies)
  144. Copying values from one column in a sheet to another column in another sheet once. (3 replies)
  145. How to Solve using CurrentRegion if cells in Table is Protected (2 replies)
  146. Using the TEXT function and Concatenate function in one formula (2 replies)
  147. Copy data from user selected source file to current open workbook (0 replies)
  148. [SOLVED:] Putting Values with Leading Zeros Into CSV file (7 replies)
  149. Why do macros work once and then stop? Example is included (3 replies)
  150. How do I get one cell color to change based on another cell color that changes? (7 replies)
  151. Finding Shape types WITHOUT selecting the shape ? (2 replies)
  152. VBA Help to change Form of Smart Art Nodes (0 replies)
  153. [SOLVED:] Saving is not creating a new record line, but saving over it (9 replies)
  154. Vlookup to ListObject "Table copy, paste" (1 replies)
  155. [SLEEPER:] VBA Email TO Cell that contains IF formula (4 replies)
  156. VBA Code for pasting today's date into a text box (4 replies)
  157. [SOLVED:] Pivot table (1 replies)
  158. Making code more concise - VBA scrape information (4 replies)
  159. [SOLVED:] How to save multiple selected information from a LISTBOX? (1 replies)
  160. A search code with three possible results (5 replies)
  161. Filter By Multiple Criteria then match results to different workbook & paste new data (19 replies)
  162. Price List Comparator (2 replies)
  163. Filter values ​​from a table and display them in different textboxes (0 replies)
  164. [SOLVED:] Cross section by matching column and row headings (4 replies)
  165. Excel counts a blank as zero. Why not leave it as a blank? (2 replies)
  166. Automatically delete rows after time period using time stamp (have partial code) (2 replies)
  167. Worksheet Change Referencing Cell in Another Sheet (4 replies)
  168. insert selected row from listbox to excel table (5 replies)
  169. HLEP!! I need help modifying this code. (0 replies)
  170. VBA Help on drop down list (10 replies)
  171. Need vba to code to split data depends upon col I:I and col J:J (4 replies)
  172. Help needed- Analysis of splitting of orders (28 replies)
  173. [SOLVED:] How to pull information from different columns of data from the same row? (1 replies)
  174. [SOLVED:] Help for viable registration solution and code improvement (1 replies)
  175. [SOLVED:] IF Countif and Textjoin - Help required (14 replies)
  176. [SOLVED:] how to force users to enable macros (4 replies)
  177. [SLEEPER:] How to convert number of color to RGB? (14 replies)
  178. [SOLVED:] How to range table "t" from ActiveSheet "Charts"? (3 replies)
  179. Doppelte Einträge zusammenfassen (14 replies)
  180. Can someone recommand an obfuscator for xlsm? (10 replies)
  181. check if serial number is repeated (7 replies)
  182. [SOLVED:] AutoComplete doesn't recognize Cell A1, it starts getting information from the second (14 replies)
  183. Image embed (0 replies)
  184. [SOLVED:] Every time you open the UseForm, it generates a new code (3 replies)
  185. Return latest result for work schedule (1 replies)
  186. Search for a match files using value from selected cell in Folder or Subfolders (10 replies)
  187. [SOLVED:] Search for name and letter matches and split equally (28 replies)
  188. [SOLVED:] VBA Userform macro help for range dates (2 replies)
  189. [SOLVED:] Copy Data from one workbook to another - based on tab name (0 replies)
  190. Checkboxes and filters (2 replies)
  191. [SOLVED:] create Summary report from information on the DATA Tab. (2 replies)
  192. Copy and paste specific ranges (5 replies)
  193. [SOLVED:] VBA Excel - reduction of lines (2 replies)
  194. Copy and paste styles of diagram (14 replies)
  195. Insert Multiple Image and name image in Userform (0 replies)
  196. Instant change between one textbox to another. (1 replies)
  197. Criteria based lookup (3 replies)
  198. [SOLVED:] MkDir and "Path Not Found" Run-time error 76 (2 replies)
  199. [SOLVED:] need Code to select value from dropdown list using numeric values (13 replies)
  200. [SOLVED:] Expanding the range (5 replies)
  201. [SOLVED:] 3 questions regarding VBA Excel (1 replies)
  202. Sleeper: Find a Partial Match from Location Sheet (4 replies)
  203. [SOLVED:] HOW TO CONCATENATE: IF(condition;result string;result string) result string? (8 replies)
  204. Make a declared variable equal to values from multiple cells (2 replies)
  205. Array loop values (2 replies)
  206. How to close all the hyperlinked files automatically? (21 replies)
  207. [SOLVED:] Formula with OR condition does not return expected result (5 replies)
  208. VBA script updating values other sheet (3 replies)
  209. Help to remove duplicate strings from table (12 replies)
  210. search and copy the line (0 replies)
  211. Helper columns to solve problem (14 replies)
  212. [SOLVED:] looping through functions (5 replies)
  213. [SOLVED:] Textbox within a Frame in UDF unable to take focus. Why not? (13 replies)
  214. [SOLVED:] storing processed data (9 replies)
  215. [SOLVED:] insert auto serial number in user form (2 replies)
  216. Copy text from text file between keyword in rows. (4 replies)
  217. wrap broken lines in one line in a given text or log file (9 replies)
  218. [SOLVED:] Conditional Format:Need to compare 2 cells with any other 2 cells for the same number (1 replies)
  219. How to split a big text file (with more than 500000 lines) in to smaller files (8 replies)
  220. File Selection- if user cancels- End Sub Then call macro1 (3 replies)
  221. SUMIFS on multiple rows and columns, based on a mapping (0 replies)
  222. [SOLVED:] Delete Rows if Cost Code Bucket is Zero (10 replies)
  223. strAddress = .ActiveCell.Address Run-time error 438 when switching sheets (21 replies)
  224. [SOLVED:] Compile Error Private WithEvents oCbarEvents As CommandBars and Private Sub Worksheet (6 replies)
  225. [SOLVED:] Check if within multiple ranges check problem (8 replies)
  226. Data validation and manipulating input (12 replies)
  227. Macro Or Command To Change Photo In Excel - Urgent Weekend Help Needed (29 replies)
  228. Setting tab order, adding ability to stop/start code and refine functionality (40 replies)
  229. Pull SQL Data into Excel by Date Range (3 replies)
  230. [SOLVED:] Deleting Worksheet Stops Script (6 replies)
  231. copy information with vba (2 replies)
  232. [SOLVED:] VBA code to pull in data from SQL table (7 replies)
  233. [SOLVED:] clear dependant drop down boxes (5 replies)
  234. [SOLVED:] Is it possible to store range objects in an variant array? (5 replies)
  235. [SOLVED:] Re-Arrange Columns after Import (6 replies)
  236. Loop Through Data Validation List and Copy Values Given By Each Item (7 replies)
  237. Add the value taken from the user to my range for ActiveX ComboBox (7 replies)
  238. New to VBA: Compile Error Syntax Error (5 replies)
  239. [SOLVED:] Countif in VBA Module (4 replies)
  240. Shell Command results in Runtime Error 5 - but path appears to exist (5 replies)
  241. How to prevent duplicate value (1 replies)
  242. [SOLVED:] Create Summary (3 replies)
  243. [SOLVED:] Zero Out Column if another column has a certain qualifier (11 replies)
  244. [SOLVED:] How to Change the Value of a Cell based on the values of two other cells (3 replies)
  245. [SOLVED:] Multi-sheet procedure (2 replies)
  246. Macro for inserting rows if value (7 replies)
  247. [SOLVED:] Date Help (16 replies)
  248. copy with loop double variable (3 replies)
  249. Market data and charts (0 replies)
  250. expenses compared to the budget (1 replies)