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. Workbook Partial Name Match (7 replies)
  2. [SOLVED:] Compare rows of two sheets based on multiple columns (5 replies)
  3. VBA with index + match with 2 criterion issue (0 replies)
  4. Getting values from specific cells in a dynamic range (0 replies)
  5. Using VBA To Conditionally Format (0 replies)
  6. Allocating amount with invoices based on FIFO method (1 replies)
  7. VBA - Split/Extract data into specific worksheet with formatting (0 replies)
  8. [SOLVED:] Colon as part of string in Userform Label (4 replies)
  9. help (1 replies)
  10. Active Directory Bulk Check (2 replies)
  11. [SOLVED:] rename sheet and first row. (4 replies)
  12. [SOLVED:] Referencing a range into formula: explanation (2 replies)
  13. Room reservation in sort of calendar (3 replies)
  14. Code to unprotect worksheet in 2016 (3 replies)
  15. auto draw triangle from cell values in worksheet (2 replies)
  16. VBA is Stubbornly Interpreting 10/12 as Date (2 replies)
  17. [VBA-excel 2007] How to check if variable exist on userform (2 replies)
  18. Extract data from a table using two criteria variables (6 replies)
  19. [SOLVED:] VBA Matrix Operations Help Needed. (26 replies)
  20. [SOLVED:] Fisher Yates Shufflein Excel with VBA (3 replies)
  21. Search function using VBA (3 replies)
  22. [SOLVED:] Use cell ref in table formula (3 replies)
  23. [SOLVED:] PAUSE AND WAIT EXCEL VBA (6 replies)
  24. [SOLVED:] Problems with vlookup on another sheet (2 replies)
  25. [SOLVED:] Obtain text between words and populate to different cell in another sheet (1 replies)
  26. [SOLVED:] VBA code to unhide Unhide multiple columns based on multiple values in row (18 replies)
  27. [SOLVED:] formula (1 replies)
  28. Select Rows which has specific value (but now Entire Row selection) (2 replies)
  29. [SOLVED:] Excel, switching between worksheets is "jumpy" (0 replies)
  30. [SOLVED:] Renaming multiple worksheets from list (2 replies)
  31. Extracting directly from a text file into excel with specific conditions in theheader (3 replies)
  32. extracting object browser information (1 replies)
  33. [SOLVED:] Match, Find, Offset & Sum in loop not working (2 replies)
  34. [SOLVED:] VBA Sumif in R1C1 style not working (3 replies)
  35. Comparing two cell range (1 replies)
  36. [SOLVED:] Extracting Letters from the String (2 replies)
  37. [SOLVED:] Wildcard Filter Not Working For Dates (2 replies)
  38. Sum Variable types (3 replies)
  39. VBA Help (0 replies)
  40. Unable to View XLS File Created in Office 365 (10 replies)
  41. [SOLVED:] Trouble with CountIF Function in VBA, I think (5 replies)
  42. [SOLVED:] Worksheet/Workbook properties (7 replies)
  43. ByRef Array Button Click (2 replies)
  44. [SOLVED:] VBA Code for Worst Month from Daily Data (1 replies)
  45. [SOLVED:] Filling Empty Cells with Data based on Averages (2 replies)
  46. [SOLVED:] How to make a search filter in Excel Userform that displays the output in the ListBox (2 replies)
  47. [SOLVED:] VBA cannot resolve type mismatch error with vlookup (4 replies)
  48. Copy worksheets (names, data and format) from saved data file to open active workbook (4 replies)
  49. how to make exception when I get message of “if could not find the specified object” (3 replies)
  50. [SOLVED:] Unable to resolve type mismatch with userform entry (1 replies)
  51. Daily Cash-flow Forecast Planning (9 replies)
  52. Returning a Value (10 replies)
  53. Split range based on total (4 replies)
  54. coverting if formula to macro (1 replies)
  55. Sleeper: Macro to populate all the macros to the ribbon (0 replies)
  56. [SOLVED:] VBA Investment Returns - How to find last day of a month? (2 replies)
  57. [SOLVED:] Explanation about a specific function (2 replies)
  58. [SOLVED:] Type Mismatch (4 replies)
  59. Hide current Roll based on Cell value (1 replies)
  60. [SOLVED:] Need Help in VBA (4 replies)
  61. Why can't I UPDATE the SELECTED value from the ListBox? (13 replies)
  62. Need copied web workbook to overwrite to the same worksheet (1 replies)
  63. Chart generation loop issue (1 replies)
  64. [SOLVED:] Find and collate rows with repeated partial text in one column (16 replies)
  65. [SOLVED:] Run-Time error 9 Subscript out of range (7 replies)
  66. Filter multiple sheets with same headers in one sheet (0 replies)
  67. [SOLVED:] Excel VBA events only working on last element of Collection (6 replies)
  68. Simple Loop For Selecting a Range and Replacing Values (2 replies)
  69. VBA/macro to filter Pivot Table Filter Field (16 replies)
  70. Cell reference changes to make a change in URL (4 replies)
  71. [SOLVED:] Chartobjectsd and SeriesCollection (9 replies)
  72. Userform & scanner, won't go to the next field (5 replies)
  73. How to speed up a Change Event Loop (1 replies)
  74. Help next sheet macro (2 replies)
  75. [SOLVED:] Crashing UDF - debug tips needed (6 replies)
  76. Ribbon Toggle Buttons Issue (6 replies)
  77. [SOLVED:] If find any data on column P add CHECKED word on Column O (0 replies)
  78. [SOLVED:] How to draw out the WorkSheet properties? (8 replies)
  79. [SOLVED:] Extracting groups of Options button (5 replies)
  80. Pop up a help text on userform after hovering the mouse for 1 sec (5 replies)
  81. [SOLVED:] Worksheet formula Offset 1 Column Left & another Cell (7 replies)
  82. Change code to search multiple terms across columns (8 replies)
  83. compare pictures (4 replies)
  84. Need Help : How to do convert 1 table to another format (7 replies)
  85. [SOLVED:] Convert negative to positive numbers in range being copied (21 replies)
  86. VBA Query (7 replies)
  87. Saving files using Relative Filepath Location (5 replies)
  88. Conditionally copy content of adjacent cells to different worksheet (6 replies)
  89. VBA Formula with dynamic range. Please help (2 replies)
  90. Repeat Bottom Rows on every printed page of a worksheet (2 replies)
  91. Copy .CSV to .XLS and Formatting (1 replies)
  92. VBA API Macro Inconsistent (4 replies)
  93. [SOLVED:] Showing & Hiding Rows based on values (3 replies)
  94. [SOLVED:] Sum two dynamic totals (0 replies)
  95. [SOLVED:] Extracting Four Specific Data for each Row. Complex and Disorganized Raw Data. (11 replies)
  96. [SOLVED:] filter sublist from list in another column then filter that with another criterion (2 replies)
  97. [SOLVED:] Copy cell range onto new tabs sorted in groups (11 replies)
  98. need help in macro to select a column (2 replies)
  99. [SOLVED:] Workbook_Open operates inconsistenly (11 replies)
  100. How to run macro for multiple worksheets (3 replies)
  101. [SOLVED:] Pivot Table Name Changed Every time when Macro Runs (0 replies)
  102. [SOLVED:] VBA Copy Value Method not working (13 replies)
  103. VBA: Loop a simple calculation through a 2 dimensional array (1 replies)
  104. [SOLVED:] Properties Window - Won't display (Not a Docking issue) (3 replies)
  105. [SOLVED:] Vba to save range with formulas as values if date is less than today. (4 replies)
  106. Pasting and editing data formats in excel (2 replies)
  107. Get row number from a closed workbook (7 replies)
  108. [SOLVED:] Copy data based on pivot table (3 replies)
  109. [SOLVED:] Auto close userform when video ends (5 replies)
  110. [SOLVED:] Remove Duplicates keeping most recent change (6 replies)
  111. Update Data of Charts (4 replies)
  112. [SOLVED:] Commission Percent based on Gross Margin Percent Formula (1 replies)
  113. VBA File/Path Error (5 replies)
  114. [SOLVED:] 2 change events on 1 worksheet (6 replies)
  115. Allow Auto Data Entry into a locked cell. (3 replies)
  116. [SOLVED:] Excel VBA: Copy cell values to next empty row in table when row contains formulas. (1 replies)
  117. vba chart series formula property (2 replies)
  118. Work Books Sheets copy to Multiple WorkBooks and Rename and Save (1 replies)
  119. Mac Office 2019 - Any different than Office 2016? (1 replies)
  120. Extract FIlename (including dots) without extension (1 replies)
  121. Change Color Of Labels As Mouse Moves (Using MouseOver event) (4 replies)
  122. [SOLVED:] Locking Cells If Certain Values Is Selected (1 replies)
  123. [SOLVED:] UNable to get vlookup property of worksheet function class (6 replies)
  124. Copy Worksheet to a New Excel Document and SaveAs... (4 replies)
  125. [SOLVED:] Copy/Paste files into new folders based on condition (36 replies)
  126. [SOLVED:] Search multiple ranges for two specific above values and modify an offset (8 replies)
  127. Search Characters Within String (6 replies)
  128. [SOLVED:] Hide Rows (2 replies)
  129. VBA Lag/Delay Issue on Import Command Button (2 replies)
  130. [SOLVED:] vba Personal workbook - I dont get it (2 replies)
  131. VBA dependent drop down list (1 replies)
  132. Adding Percentages to a Pivot Table with Calculated Item (0 replies)
  133. Adjust VBA-Excel split code to combine similar tab names (4 replies)
  134. VBA to loop through an array (4 replies)
  135. [SOLVED:] Save file to a different folder, add to file name & change from .xlsm to .xlsx (4 replies)
  136. Populate single listbox merging different ranges from different sheets (7 replies)
  137. Data Entry VBA Form (3 replies)
  138. Dynamically Added Checkbox Is Not Shown While Clicked (1 replies)
  139. VBA/Macro. Hashtag Generator. (0 replies)
  140. What's the difference between the dims of Array ? (1 replies)
  141. VBA: Match row data with below cells and fill cell with data condition (0 replies)
  142. [SOLVED:] Stop user from pressing CTRL + BREAK (16 replies)
  143. vba property in lcase (2 replies)
  144. [SOLVED:] How to reduce file open time and screen flicker (with custom RibbonXML) (2 replies)
  145. Anyone have any idea on this code to speed up macros (5 replies)
  146. Simple VBA: Copy cell data from the top row in below cells (in the respective column) (0 replies)
  147. link pivot tables to existing slicer(s) - error "invalid procedure call or argument" (1 replies)
  148. Concatenating two ranges in MATCH function (6 replies)
  149. loop (4 replies)
  150. VBA Copy Last Row into Last Row on Another Workbook (7 replies)
  151. [SOLVED:] excel vba permission denied run time error 70 (5 replies)
  152. [SOLVED:] RUN ADD-IN AS PART OF MACRO (3 replies)
  153. [SOLVED:] A working macro that I need to change the search range and write location (12 replies)
  154. [SOLVED:] Select Cells Excel VBA (7 replies)
  155. VBA: Cross-match first two sheets and save result sheet as excel workbook. (7 replies)
  156. Pivot table changing from tabular view to compact view automatically (1 replies)
  157. Copy Data till Last Row and Column (2 replies)
  158. advance filter (7 replies)
  159. Scatter Plot with Filter option (0 replies)
  160. Lock Black Colored Cells (Revised) (3 replies)
  161. Remove Duplicates By Making Them Unique (3 replies)
  162. VBA for Slicer & Table Formatting (0 replies)
  163. Best way to create dynamic named ranges (6 replies)
  164. [SOLVED:] Remove Duplicate Data by Specify Columns and Their Date (2 replies)
  165. [SOLVED:] If Formula with Year Function (2 replies)
  166. vba for shifting or arranging certain column with respect to Data1 sheet (1 replies)
  167. Extract rows of data based on a criteria (4 replies)
  168. [SOLVED:] How To Show A System Tray Notification Balloon (5 replies)
  169. Code addition of rows (3 replies)
  170. [SOLVED:] VBA code copy and paste (3 replies)
  171. VBA - help optimise/clean up the code (2 replies)
  172. [SOLVED:] Possible Combination (12 replies)
  173. List box error 308 (13 replies)
  174. Reading the XML of a workbook (3 replies)
  175. Replacement for PLX-DAQ Add-In (0 replies)
  176. [SOLVED:] VBA myFSO GetFolder path problem (2 replies)
  177. [SOLVED:] Excell userform requiring boxes to be populated with filenames (5 replies)
  178. How to create and manage user access (8 replies)
  179. 64 bit excel question (2 replies)
  180. [SOLVED:] VBA: USE InStrRev to get file Name (3 replies)
  181. [SLEEPER:] Merge few files with few sheets to one sheet (0 replies)
  182. [SOLVED:] ADDING INDICATOR ICONS TO EXCEL USERFORM (3 replies)
  183. How to use arrays to filter and find information (29 replies)
  184. Bluezone 7.1 and Excel VBA (2 replies)
  185. Runtime 50290 error When trying to enter Time value in a Range (19 replies)
  186. [SOLVED:] Please need some help to edit my macro (Copy colored words) (3 replies)
  187. [SOLVED:] Help for interpretation of the code (4 replies)
  188. [SOLVED:] How to find the top5 and bottom5 values without using large or small (7 replies)
  189. [SOLVED:] Userform with File Selector Process not working (4 replies)
  190. [SOLVED:] How to set up spreadsheet for regression analysis in Excel 2016 (32 replies)
  191. [SOLVED:] Any way to make this apply to a larger selection instead of just 1 cell ? (7 replies)
  192. Required VBA code to change Color of chart & also formatting (9 replies)
  193. VBA - Lock the cell based on Conditional Formatting (3 replies)
  194. ACTIVE X CONTROL MOVES POSITION WHEN MACRO IS RUN (4 replies)
  195. [SOLVED:] CANNOT PLACE BUTTON IN SPECIFIED LOCATION (5 replies)
  196. Find and Replace Multiple values in Excel (16 replies)
  197. VBA: GetObject / Copy and Past is bringing only 255 characters (2 replies)
  198. Learning VBA (1 replies)
  199. Automation Error when trying to run stored procedure on SQL server (0 replies)
  200. [SOLVED:] Modifying VBA code in multiple files (2 replies)
  201. Run time Error 438 (4 replies)
  202. Lock pictures so immovable (but do not want to lock objects) (3 replies)
  203. [SOLVED:] vba cell event change & call macro combination (2 replies)
  204. Legend Issue (0 replies)
  205. Array Formula - More than one wildcard in lookup (2 replies)
  206. To set Date filter on pivot via input box when opening a file (1 replies)
  207. VBA to check column I and if find data and match the same ID in column A Put Data in. (4 replies)
  208. LISTFILLRANGE COMBOBOX PROPERTY NOT WORKING (1 replies)
  209. [SOLVED:] COMBO BOX MISSING, BUT PROPERTIES EXIST (2 replies)
  210. VBA Counting instances of journeys (6 replies)
  211. [SOLVED:] Insert progressive numbers in a column but every n rows (3 replies)
  212. Lock and unlock lines in worksheet based on usrname (6 replies)
  213. Password protect and unprotect a worksheet/workbook (5 replies)
  214. Array loop (3 replies)
  215. [SOLVED:] .AdvancedFilter using an array as the criteria (2 replies)
  216. INSERT TEXT AND FORMAT AUTOSHAPE (1 replies)
  217. excel stops working and crashes when working with excel user form (2 replies)
  218. Timer/StopWatch - How do I make button turn to red and flash when I click Start? (4 replies)
  219. Display CopyFromRecordset result vertically (2 replies)
  220. Help to separate two codes and place one in a Userform Function (0 replies)
  221. Need Help Re-writing Recorded Macro (3 replies)
  222. [SOLVED:] VBA creating new folders and files (10 replies)
  223. [SOLVED:] Remove excess cells (5 replies)
  224. [SOLVED:] Msg Box Problem (4 replies)
  225. Lookup formula Corresponding value in anywhere in array (0 replies)
  226. Long if statements with numbers. (1 replies)
  227. [SOLVED:] macro or VBA code "is it possible?" (13 replies)
  228. Extract Unique List That Meets Criteria (3 replies)
  229. [SOLVED:] Set Worksheet to variable name (3 replies)
  230. VBA Row offset when dynamically changing cell value (2 replies)
  231. vba example (2 replies)
  232. Copy calculated data ranges in Sheet2 O:O to Sheet1 offset column block areas in C:C (10 replies)
  233. Copy And Paste All Rows That Match A Specific Criteria (3 replies)
  234. Allow access to certain sheets in a workbook (1 replies)
  235. Comparing two columns with empty rows but same data and delete (0 replies)
  236. How to make my combobox invisible (5 replies)
  237. Copy Paste Without Opening The .csv file/s (0 replies)
  238. [SOLVED:] Paste and End(xlRight) (2 replies)
  239. VBA Conditional Format Error 9 (3 replies)
  240. Highlight cells with inputbox (32 replies)
  241. VBA restaurant ordering form (2 replies)
  242. [SOLVED:] Sub Not Defined error when using a renamed combobox (15 replies)
  243. USERFORM WITH MULTIPLE ENTRY LINES (1 replies)
  244. ControlTip Text not showing in excel Userform (5 replies)
  245. Ignoring Error VBA (8 replies)
  246. How to rename TextBoxes on userform (5 replies)
  247. Populate a cell percentage based on amount of dates in a range of cells. (7 replies)
  248. VBA save a variable when criteria is met (5 replies)
  249. [SOLVED:] Userform instructions (3 replies)
  250. open workbook (1 replies)