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. Insert Row & copy and paste formulas in new row (5 replies)
  2. [SOLVED:] Can't loop a macro (11 replies)
  3. Break record row into multiple rows (7 replies)
  4. Macro called from Menu no longer responding (2 replies)
  5. [SOLVED:] Problem in concatenate (10 replies)
  6. Modeless Form Closing (1 replies)
  7. Help duplicating from one cell onto multiple rows (1 replies)
  8. How to make a macro work in selected worksheets and how to fix a macro error from CF (8 replies)
  9. Dynamic update for each userform textbox through looping (1 replies)
  10. Haven't encountered this before, what does it mean? (5 replies)
  11. Precedents arrows state (4 replies)
  12. [SOLVED:] Can a Header (8 replies)
  13. [SOLVED:] Code only doing it for cell not entire column (2 replies)
  14. VBA code (11 replies)
  15. [SOLVED:] Pin Folder to Windows Explorers Quick Access in VBA (5 replies)
  16. [SOLVED:] IF Else statement not executing properly (2 replies)
  17. Extract a number from text in cell using VBA (3 replies)
  18. [SOLVED:] Msg error: "Exception from HRESULT:0x800401A8" when refreshing reports automatically (2 replies)
  19. Sorting and cutting part of the sort into a new tab (2 replies)
  20. Sleeper: Linear interpolation in Excel (6 replies)
  21. Sorting two way pivot table with VBA? (3 replies)
  22. Sleeper: VBA using Loop (5 replies)
  23. Transferring data workbook to workbook (2 replies)
  24. [SOLVED:] Help with simplifying my background substraction (data analysis) (4 replies)
  25. How can we use VBA/Macros Excel for solving this interesting simulation question? (3 replies)
  26. errors on Macro code for consolidation (1 replies)
  27. Compare the selected item of a listbox with a table (1 replies)
  28. Unrecognized text on different computer (5 replies)
  29. After user clicks 'Notify', do this (2 replies)
  30. Macro not working for fetching data from Active Directory (7 replies)
  31. Reference a cell. (2 replies)
  32. [SOLVED:] Formula to format the cell? (so text gets enough space) (4 replies)
  33. [SOLVED:] Repeat Search Function (3 replies)
  34. [SOLVED:] Sort range from one empty row to the next empty row Custom (3 replies)
  35. Simple code that refreshes link to another excel file with Password (2 replies)
  36. [SOLVED:] Making a function based on Find having IF (3 replies)
  37. [SOLVED:] Conditional Formatting borders around cells with formulas (4 replies)
  38. [SOLVED:] Keycode 13 only for textbox input on userform (1 replies)
  39. Method 'SaveAs' of object'_Workbook failed (10 replies)
  40. VBA Code for PDF of Vibile Sheets in array (6 replies)
  41. Create a Userform with a Textbox and link it to a Cell or Table (1 replies)
  42. VBA Code for Highlighting Cells based on If then Rules (6 replies)
  43. Using VBA Set for workbook and worksheet (26 replies)
  44. Linear interpolation with lookup of two values (0 replies)
  45. Item number with current month (3 replies)
  46. [SOLVED:] Move data around in workbook (9 replies)
  47. how to create a portfolio Optimimizer using VBA (2 replies)
  48. [SOLVED:] Formula to FIND specific TEXT within a worksheet (7 replies)
  49. Log Scale graph in excel (1 replies)
  50. VBA - Problem in .range (2 replies)
  51. [SLEEPER:] Loop between two tables to sum their matches (4 replies)
  52. Retrieve formulas and autocomplete (0 replies)
  53. [SOLVED:] show multiple separate information (0 replies)
  54. [SOLVED:] Fastest way to transform data (9 replies)
  55. Picture shows in userform with search (14 replies)
  56. Does anyone else have this error 1004? (5 replies)
  57. code to setup crop dimension (2 replies)
  58. Lookup to add Products from one table to another VBA (9 replies)
  59. Help : Error on saving workbook to dektop synced with OneDrive (1 replies)
  60. VBA - Range of object _ Global failed (3 replies)
  61. Can I add cell info into a comment box via a formula? (1 replies)
  62. VBA - function Vlookup (3 replies)
  63. Copying values from one column in a sheet to another column in another sheet once. (3 replies)
  64. How to Solve using CurrentRegion if cells in Table is Protected (2 replies)
  65. Using the TEXT function and Concatenate function in one formula (2 replies)
  66. Copy data from user selected source file to current open workbook (0 replies)
  67. [SOLVED:] Putting Values with Leading Zeros Into CSV file (7 replies)
  68. Why do macros work once and then stop? Example is included (3 replies)
  69. How do I get one cell color to change based on another cell color that changes? (7 replies)
  70. Finding Shape types WITHOUT selecting the shape ? (2 replies)
  71. VBA Help to change Form of Smart Art Nodes (0 replies)
  72. [SOLVED:] Saving is not creating a new record line, but saving over it (9 replies)
  73. Vlookup to ListObject "Table copy, paste" (1 replies)
  74. [SLEEPER:] VBA Email TO Cell that contains IF formula (4 replies)
  75. VBA Code for pasting today's date into a text box (4 replies)
  76. [SOLVED:] Pivot table (1 replies)
  77. Making code more concise - VBA scrape information (4 replies)
  78. [SOLVED:] How to save multiple selected information from a LISTBOX? (1 replies)
  79. A search code with three possible results (5 replies)
  80. Filter By Multiple Criteria then match results to different workbook & paste new data (19 replies)
  81. Price List Comparator (2 replies)
  82. Filter values ​​from a table and display them in different textboxes (0 replies)
  83. [SOLVED:] Cross section by matching column and row headings (4 replies)
  84. Excel counts a blank as zero. Why not leave it as a blank? (2 replies)
  85. Automatically delete rows after time period using time stamp (have partial code) (2 replies)
  86. Worksheet Change Referencing Cell in Another Sheet (4 replies)
  87. insert selected row from listbox to excel table (5 replies)
  88. HLEP!! I need help modifying this code. (0 replies)
  89. VBA Help on drop down list (10 replies)
  90. Need vba to code to split data depends upon col I:I and col J:J (4 replies)
  91. Help needed- Analysis of splitting of orders (28 replies)
  92. [SOLVED:] How to pull information from different columns of data from the same row? (1 replies)
  93. [SOLVED:] Help for viable registration solution and code improvement (1 replies)
  94. [SOLVED:] IF Countif and Textjoin - Help required (14 replies)
  95. [SOLVED:] how to force users to enable macros (4 replies)
  96. How to convert number of color to RGB? (14 replies)
  97. [SOLVED:] How to range table "t" from ActiveSheet "Charts"? (3 replies)
  98. Doppelte Einträge zusammenfassen (14 replies)
  99. Can someone recommand an obfuscator for xlsm? (10 replies)
  100. check if serial number is repeated (7 replies)
  101. [SOLVED:] AutoComplete doesn't recognize Cell A1, it starts getting information from the second (14 replies)
  102. Image embed (0 replies)
  103. [SOLVED:] Every time you open the UseForm, it generates a new code (3 replies)
  104. Return latest result for work schedule (1 replies)
  105. Search for a match files using value from selected cell in Folder or Subfolders (10 replies)
  106. [SOLVED:] Search for name and letter matches and split equally (28 replies)
  107. [SOLVED:] VBA Userform macro help for range dates (2 replies)
  108. [SOLVED:] Copy Data from one workbook to another - based on tab name (0 replies)
  109. Checkboxes and filters (2 replies)
  110. [SOLVED:] create Summary report from information on the DATA Tab. (2 replies)
  111. Copy and paste specific ranges (5 replies)
  112. [SOLVED:] VBA Excel - reduction of lines (2 replies)
  113. Copy and paste styles of diagram (14 replies)
  114. Insert Multiple Image and name image in Userform (0 replies)
  115. Instant change between one textbox to another. (1 replies)
  116. Criteria based lookup (3 replies)
  117. [SOLVED:] MkDir and "Path Not Found" Run-time error 76 (2 replies)
  118. [SOLVED:] need Code to select value from dropdown list using numeric values (13 replies)
  119. [SOLVED:] Expanding the range (5 replies)
  120. [SOLVED:] 3 questions regarding VBA Excel (1 replies)
  121. Sleeper: Find a Partial Match from Location Sheet (4 replies)
  122. [SOLVED:] HOW TO CONCATENATE: IF(condition;result string;result string) result string? (8 replies)
  123. Make a declared variable equal to values from multiple cells (2 replies)
  124. Array loop values (2 replies)
  125. How to close all the hyperlinked files automatically? (21 replies)
  126. [SOLVED:] Formula with OR condition does not return expected result (5 replies)
  127. VBA script updating values other sheet (3 replies)
  128. Help to remove duplicate strings from table (12 replies)
  129. search and copy the line (0 replies)
  130. Helper columns to solve problem (14 replies)
  131. [SOLVED:] looping through functions (5 replies)
  132. [SOLVED:] Textbox within a Frame in UDF unable to take focus. Why not? (13 replies)
  133. [SOLVED:] storing processed data (9 replies)
  134. [SOLVED:] insert auto serial number in user form (2 replies)
  135. Copy text from text file between keyword in rows. (4 replies)
  136. wrap broken lines in one line in a given text or log file (9 replies)
  137. [SOLVED:] Conditional Format:Need to compare 2 cells with any other 2 cells for the same number (1 replies)
  138. How to split a big text file (with more than 500000 lines) in to smaller files (8 replies)
  139. File Selection- if user cancels- End Sub Then call macro1 (3 replies)
  140. SUMIFS on multiple rows and columns, based on a mapping (0 replies)
  141. [SOLVED:] Delete Rows if Cost Code Bucket is Zero (10 replies)
  142. strAddress = .ActiveCell.Address Run-time error 438 when switching sheets (21 replies)
  143. [SOLVED:] Compile Error Private WithEvents oCbarEvents As CommandBars and Private Sub Worksheet (6 replies)
  144. [SOLVED:] Check if within multiple ranges check problem (8 replies)
  145. Data validation and manipulating input (12 replies)
  146. Macro Or Command To Change Photo In Excel - Urgent Weekend Help Needed (29 replies)
  147. Setting tab order, adding ability to stop/start code and refine functionality (40 replies)
  148. Pull SQL Data into Excel by Date Range (3 replies)
  149. [SOLVED:] Deleting Worksheet Stops Script (6 replies)
  150. copy information with vba (2 replies)
  151. [SOLVED:] VBA code to pull in data from SQL table (7 replies)
  152. [SOLVED:] clear dependant drop down boxes (5 replies)
  153. [SOLVED:] Is it possible to store range objects in an variant array? (5 replies)
  154. [SOLVED:] Re-Arrange Columns after Import (6 replies)
  155. Loop Through Data Validation List and Copy Values Given By Each Item (7 replies)
  156. Add the value taken from the user to my range for ActiveX ComboBox (7 replies)
  157. New to VBA: Compile Error Syntax Error (5 replies)
  158. [SOLVED:] Countif in VBA Module (4 replies)
  159. Shell Command results in Runtime Error 5 - but path appears to exist (5 replies)
  160. How to prevent duplicate value (1 replies)
  161. [SOLVED:] Create Summary (3 replies)
  162. [SOLVED:] Zero Out Column if another column has a certain qualifier (11 replies)
  163. [SOLVED:] How to Change the Value of a Cell based on the values of two other cells (3 replies)
  164. [SOLVED:] Multi-sheet procedure (2 replies)
  165. Macro for inserting rows if value (7 replies)
  166. [SOLVED:] Date Help (16 replies)
  167. copy with loop double variable (3 replies)
  168. Market data and charts (0 replies)
  169. expenses compared to the budget (1 replies)
  170. Not Getting Sum Result From All Sheets (2 replies)
  171. HELP!! can't figure out details for a file-combining macro (13 replies)
  172. Opened Workbooks are still opened after executing Macro (Workbook.Close doesn't work) (28 replies)
  173. [SOLVED:] Cumulative based of criteria (6 replies)
  174. [SOLVED:] mismatch when sum values in multiple textboxes (8 replies)
  175. Application Visible with more than 1 workbook (7 replies)
  176. Excel VBA folder-search-tool (24 replies)
  177. [SOLVED:] How to create a values only copy of WB while keeping formatting and filters in tact? (20 replies)
  178. Excel file always opens in read-only mode when opening from sharepoint (0 replies)
  179. Open and Close Workbooks | best Practices (5 replies)
  180. Column getting truncated (7 replies)
  181. [SOLVED:] Help: Capture file location on the first opening of a workbook/workbook open event (2 replies)
  182. Script not working after moving data to SharePoint (4 replies)
  183. [SOLVED:] Worksheet SelectionChange Error - Target.Address - if statement (5 replies)
  184. [SOLVED:] Userform is not displaying anything when i change a "box" to visible or not visible (8 replies)
  185. [SOLVED:] Lookup formula not returning the correct result (4 replies)
  186. Show graph in userform but via sharepoint (1 replies)
  187. Variant-type object array element is deallocated by With statement (6 replies)
  188. Userform error (2 replies)
  189. [SOLVED:] Depending on the marked radio button, the text in the cell changes (2 replies)
  190. [SOLVED:] Variable look up fields based on Value from different cell. (6 replies)
  191. Nasty spreadsheet (16 replies)
  192. [SOLVED:] Macro to split data based on the value from specific column (23 replies)
  193. [SOLVED:] Adding Conditional Formatting using AND (5 replies)
  194. [SOLVED:] VBA Autofilter Loop (27 replies)
  195. I'm trying to perform two validations on a range of cells at the same time (3 replies)
  196. Join two pieces of code (2 replies)
  197. [SOLVED:] IIF function in Excel 365 (3 replies)
  198. [SOLVED:] How to maintain a consolidated checklist for preparing dashboard (17 replies)
  199. [SOLVED:] Dependant dropdown error (6 replies)
  200. Find Text Within A Row, Then Copy Information Below That Cell To Second Worksheet (6 replies)
  201. Making Program work with different number formats (1 replies)
  202. Please help me to update array between 2 sheets (7 replies)
  203. List Box, runtime error (4 replies)
  204. [SOLVED:] Writing trig equations in Excel (10 replies)
  205. [SOLVED:] Lookup Values from List and Copy data unde headings VBA (7 replies)
  206. using application.getopenfilename keeps opening new app (9 replies)
  207. [SOLVED:] Sending emails with attachments (3 replies)
  208. Excel VBA and arrays (1 replies)
  209. [SOLVED:] ComboBox display incorrect text (9 replies)
  210. Connection to cloud based SQL Server database using VBA (1 replies)
  211. Excel on Android (0 replies)
  212. [SOLVED:] Merging TXT files in a current worksheet using VBA (15 replies)
  213. VBA script works when stepped through, but not when run in realtime (13 replies)
  214. [SOLVED:] Copy Heading number in condition (9 replies)
  215. VBA error (2 replies)
  216. [SOLVED:] userform indirect alternative (14 replies)
  217. Macro that updates values in a function (4 replies)
  218. [SOLVED:] Please Help! Code For Multiple Checkbox Returning to One cell in Excel VBA User Form (3 replies)
  219. [SOLVED:] Adding VBA Conditional Formatting (4 replies)
  220. General VBA Inquiry (3 replies)
  221. [SOLVED:] Application.Caller return value (13 replies)
  222. EXCEL VBA VLookUp (4 replies)
  223. [SOLVED:] Please Help! Code For Option Buttons in Excel VBA User Form (4 replies)
  224. Extending the data range of a scatter chart by dragging. (0 replies)
  225. [SOLVED:] VBA - Clean up a table with returning values (6 replies)
  226. VBA - Convert data table into a long list (multiple columns) (3 replies)
  227. [SOLVED:] Filter function to pull results based on drop down non VBA solution (1 replies)
  228. VBA Code to copy data from two sheet ,paste into corresponding sheet (4 replies)
  229. Import image from path in adjacent cell (7 replies)
  230. [SOLVED:] clear last but one line to a userform (12 replies)
  231. MoveLast ERROR (9 replies)
  232. VBA to make 1st column of a text to columns operation "CLEAN" (2 replies)
  233. Simplifying Code (7 replies)
  234. [SOLVED:] clear last line (2 replies)
  235. VBA - Copy and Paste Data Base into an existing Sheet (1 replies)
  236. Setting a Dynamic Table Range in a VBA (4 replies)
  237. [SOLVED:] VBA how to use date to write file name in PDF (13 replies)
  238. [SOLVED:] BUILD A SET OF DATA BASED ON SOME FILTERS (4 replies)
  239. [SOLVED:] Sum entire column by like IDs (3 replies)
  240. [SOLVED:] VBA - Copy Paste data to another sheet based on criteria (3 replies)
  241. Finding last cell in a column (2 replies)
  242. [SOLVED:] VBA - Concatenate columns with delimiter (7 replies)
  243. [SOLVED:] Adding odd numbers in VBA (2 replies)
  244. Discrete Time Conversion Problem (8 replies)
  245. [SOLVED:] Creating date and time stamp (5 replies)
  246. Sleeper: How can I automate arranging cell values by repeating and transposing values (8 replies)
  247. RE: Insert/Embed outlook mail using vba Excel (1 replies)
  248. [SOLVED:] RE: Excel Formula to update Account number based on signage using mapping key (8 replies)
  249. [SOLVED:] VBA help to move all images from a cell, not folder? (15 replies)
  250. How can I change the default chart callout color? - text & border? (2 replies)