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:] Importing data from a MySQL database (1 replies)
  2. How can I chart the moon data against the tide data (12 replies)
  3. Place formulae on each row where dates meet criteria (13 replies)
  4. restore workbook after Application.Visible = False (9 replies)
  5. Need help combining multiple sheets into a single summary page (1 replies)
  6. [SOLVED:] Qucik help (2 replies)
  7. [SLEEPER:] Code retrives https:// in Windows Explorer instead of windows explorer drive (3 replies)
  8. [SOLVED:] Run-Time error when saving (4 replies)
  9. This code takes 5 seconds to run. Any suggestions on how to get that down to 3? (4 replies)
  10. Combine Excel sheets w/ same name into one (0 replies)
  11. [SOLVED:] Needs Help With For Next Loop (7 replies)
  12. Run Regression on Filtered Data Set (3 replies)
  13. [SOLVED:] Switch between Putty and Xshell using same Loginbutton (10 replies)
  14. [SOLVED:] How to create a list out of wide table (5 replies)
  15. FSO Object used in VBA code? (3 replies)
  16. [SOLVED:] Select Sheets Array If (7 replies)
  17. [SOLVED:] Need Help With Input Box To Open File in Specified Path (26 replies)
  18. Avoiding the DocumentsPane to show up on startup (4 replies)
  19. [SOLVED:] Need advice with manuals and instructions (2 replies)
  20. VBA Lock rows upon checkbox click on multi-sheets (15 replies)
  21. [SOLVED:] VBA Page Break Issue (2 replies)
  22. [SOLVED:] Highlight Duplicates (3 replies)
  23. VBA code to copy data from one sheet and paste it in a specific location (5 replies)
  24. Insert a picture in an multiple image control with one click based on dropdown list (1 replies)
  25. Copy rows from Outlook to Excel (0 replies)
  26. [SOLVED:] how to remove saturday and sunday when calculating start dates (13 replies)
  27. Problems writing data to worksheet (14 replies)
  28. [SLEEPER:] Linear/nonlinear Optimization with Solver (2 replies)
  29. Need help for copy columns to new sheet with new order and two or more criteria (2 replies)
  30. Excel Macro to copy data from a specified multiple ranges of a workbook to another wb (3 replies)
  31. Pivot Table Filter Button - VBA HELP (0 replies)
  32. Needs help with VBA for 2 specifics detailed functions (5 replies)
  33. [SOLVED:] Needs Help With Calling All Tabs (5 replies)
  34. Excel picture object chart paste in specific ppt as per slide name/number through VBA (4 replies)
  35. Checking for multiple conditions (9 replies)
  36. [SOLVED:] STRUGGLING VLOOKUP in VBA (2 replies)
  37. Need he;p with code error, .SaveAs (1 replies)
  38. [SOLVED:] Needs Help With Conditional Renaming for Several Tabs (8 replies)
  39. Help needed: Vlookup formula with a dynamic range (5 replies)
  40. Macro to delete line in excel after third / sign. (2 replies)
  41. [SOLVED:] Excel 4 Macro Page.Setup Error (1 replies)
  42. [SOLVED:] Stuck with defining range for calculation (2 replies)
  43. [SLEEPER:] Frightened to tunnel! (1 replies)
  44. Studying VBA for Excel and getting frustrated by objects/properties... (2 replies)
  45. Save Document's most recent version (3 replies)
  46. [SOLVED:] Multiple buttons using a single macro (4 replies)
  47. [SOLVED:] How to copy sheets from workbook to new open workbook and rename new workbook accordi (4 replies)
  48. convert date/number (19 replies)
  49. Conbining IF Then Conditions in Excel (7 replies)
  50. [SOLVED:] If Elseif to toggle (8 replies)
  51. macro to select different sheet tabs (2 replies)
  52. [SOLVED:] stripChar is not working (2 replies)
  53. VBA: Am i doing something wrong with While...wend? (8 replies)
  54. [SOLVED:] Find and Replace macro is not working (2 replies)
  55. size of photo based on the height of row and make center based on the column width (7 replies)
  56. Sum/ABS (4 replies)
  57. VBA Macro button to open a folder derived from the (partial) name in a selected cell (3 replies)
  58. [SOLVED:] Code runs when VBA Editor is open, but doesn't work when closed (3 replies)
  59. Unpivot data? (8 replies)
  60. Generate workbook (10 replies)
  61. [SOLVED:] Conditional Formatting (2 replies)
  62. Calculation incomplete message issues (1 replies)
  63. [SOLVED:] change word spacing in a messagbox (7 replies)
  64. [SOLVED:] Subscript out of range (4 replies)
  65. [SOLVED:] PROCESSING External Excel Files (5 replies)
  66. VBA: Counting an "if" loop to get average. (3 replies)
  67. If cells starts with a number and exceeds a certain number of characters (8 replies)
  68. [SOLVED:] VBA save as function as new workbook (5 replies)
  69. Copy & Paste (1 replies)
  70. [SOLVED:] Combine strings and place in separate sheet (4 replies)
  71. Need a macro for copy pasting with transpose (0 replies)
  72. Compare two sheets and exclude existing in the second sheet (2 replies)
  73. [SOLVED:] Find text paste text in message box next cell (14 replies)
  74. Retrieve price from another wb instead of different sheet? code complete except exter (5 replies)
  75. Activate this popup html (2 replies)
  76. identifying duplicates on each row (4 replies)
  77. Update Cost on a smaller spreadsheet from costs on a larger spreadsheet. (2 replies)
  78. [SOLVED:] sort and extract text to another excel file (1 replies)
  79. Sleeper: Found connection problem when run VBA to direct connect Oracle Database (4 replies)
  80. assign a cell value to a variable vba loop (3 replies)
  81. VBA to delete first 3 characters and keep cell formatting (2 replies)
  82. Update chart when adding new sheets of data (5 replies)
  83. Special chars to UTF-8 (3 replies)
  84. [SOLVED:] Function to list pdf files within a folder (2 replies)
  85. Extract week start and weekend day exclude holidays & weekday excel formula (3 replies)
  86. [SOLVED:] Please help to modify my code (1 replies)
  87. How to create a GeoJSON editor with VBA (3 replies)
  88. Help -- updating listbox and worksheet data (2 replies)
  89. [SOLVED:] userform input box to print a page (4 replies)
  90. number not found ... error proofing vba macro (3 replies)
  91. [SOLVED:] MessageBox line length (4 replies)
  92. vba accessing file on server?? (3 replies)
  93. Filtering a Range into another Range (2 replies)
  94. Create UserForm with Vlookup (combobox and textbox) (11 replies)
  95. [SOLVED:] Excel VBA Automation Error (and Crash) when running macro twice (1 replies)
  96. [SOLVED:] Code to know when values in column changes (4 replies)
  97. [SOLVED:] Populating text boxes (4 replies)
  98. Help!! (6 replies)
  99. Deleting Comment Indicators for Comments in Selected Range (4 replies)
  100. Formula To Replace Suffixes (3 replies)
  101. Populate Listbox with Combobox (1 replies)
  102. Summing up values between 2 criteria in rows (8 replies)
  103. [SOLVED:] VBA to Create Data rows for Multi-Valued Columns (6 replies)
  104. Compare the last two months and remove the color in the first Number (1 replies)
  105. Problem with like (5 replies)
  106. Excel VBA MySQL (0 replies)
  107. Select CSV file and Import - UTF-8 (4 replies)
  108. Select a cell with target.row (3 replies)
  109. find and retrieve a price from a different sheet index match - vlookup? (3 replies)
  110. [SOLVED:] coping conditional format and moving the compare cell with it (5 replies)
  111. remove line (2 replies)
  112. [SOLVED:] How to use previous row's Beginning Balance in calculation (2 replies)
  113. [SOLVED:] VBA Biweekly payments and monthly interest payments (4 replies)
  114. [SOLVED:] Save specific sheets as separate workbooks (4 replies)
  115. Delete button added to new row and delete row/move sheet. (0 replies)
  116. Unique Concatenate Values (0 replies)
  117. Object not defined while trying to clear contents of row (1 replies)
  118. [SOLVED:] Array problems ... need help (7 replies)
  119. Excel Macro To Combine Multiple Sheets in one only (13 replies)
  120. Bringing together 2 sets of data (1 replies)
  121. Compare two date column in different sheets, return adjacent value in matched dates (2 replies)
  122. [SLEEPER:] Excel auto filter total (7 replies)
  123. PROTECT SHEET NAME (8 replies)
  124. Search textbox and create chart in userform (5 replies)
  125. [SOLVED:] Data Using Double Click on Header but multiple range (24 replies)
  126. Application.Run? (1 replies)
  127. [SOLVED:] macro to edit part of a cell contents (8 replies)
  128. [SOLVED:] Setting date picker to certain columns only (2 replies)
  129. [SOLVED:] Userform unload issue (1 replies)
  130. VBA codeperforming two functions, check column then count all columns & create tables (6 replies)
  131. Advance Filter : Not showing Particular Filtered Items. (1 replies)
  132. VBA Coding Related to Data Entry Form (1 replies)
  133. [SOLVED:] Application.Caller error for AutoShapeType 152 (4 replies)
  134. [SLEEPER:] Printing excel sheet to pdf (20 replies)
  135. [SOLVED:] How to change non-tabular data into tabular data with VBA (16 replies)
  136. Same details load on multiple orders (2 replies)
  137. [SOLVED:] How to add a single letter to the end of an growing number (3 replies)
  138. Excel Questions on using "Switch" formula (1 replies)
  139. [SLEEPER:] using VBA sendkeys with vmware horizon client (2 replies)
  140. [SOLVED:] Combine rows of data in to one cell (6 replies)
  141. CALLING MACROS FROM SINGLE USERFORM (3 replies)
  142. [SOLVED:] Split Function - Allow for variances (2 replies)
  143. [SOLVED:] Define Worksheet As Public Variable (4 replies)
  144. A VBA Code which sort values, remove duplicate and vlookup (1 replies)
  145. [SOLVED:] Copy Down Formulae Row (range of cells) Down to Last Row. (26 replies)
  146. Cannot pass object to sub-procedure located in worksheet? (2 replies)
  147. VBA for Date Expiry does not close WorkBook (1 replies)
  148. Single Column Arrays or Vectors (3 replies)
  149. [SOLVED:] join models (14 replies)
  150. Workbook Partial Name Match (7 replies)
  151. [SOLVED:] Compare rows of two sheets based on multiple columns (5 replies)
  152. VBA with index + match with 2 criterion issue (0 replies)
  153. Getting values from specific cells in a dynamic range (0 replies)
  154. Using VBA To Conditionally Format (0 replies)
  155. Allocating amount with invoices based on FIFO method (1 replies)
  156. VBA - Split/Extract data into specific worksheet with formatting (0 replies)
  157. [SOLVED:] Colon as part of string in Userform Label (4 replies)
  158. help (1 replies)
  159. Active Directory Bulk Check (2 replies)
  160. [SOLVED:] rename sheet and first row. (4 replies)
  161. [SOLVED:] Referencing a range into formula: explanation (2 replies)
  162. Room reservation in sort of calendar (3 replies)
  163. Code to unprotect worksheet in 2016 (3 replies)
  164. auto draw triangle from cell values in worksheet (2 replies)
  165. VBA is Stubbornly Interpreting 10/12 as Date (2 replies)
  166. [VBA-excel 2007] How to check if variable exist on userform (2 replies)
  167. Extract data from a table using two criteria variables (6 replies)
  168. [SOLVED:] VBA Matrix Operations Help Needed. (26 replies)
  169. [SOLVED:] Fisher Yates Shufflein Excel with VBA (3 replies)
  170. Search function using VBA (3 replies)
  171. [SOLVED:] Use cell ref in table formula (3 replies)
  172. [SOLVED:] PAUSE AND WAIT EXCEL VBA (6 replies)
  173. [SOLVED:] Problems with vlookup on another sheet (2 replies)
  174. [SOLVED:] Obtain text between words and populate to different cell in another sheet (1 replies)
  175. [SOLVED:] VBA code to unhide Unhide multiple columns based on multiple values in row (18 replies)
  176. [SOLVED:] formula (1 replies)
  177. Select Rows which has specific value (but now Entire Row selection) (2 replies)
  178. [SOLVED:] Excel, switching between worksheets is "jumpy" (0 replies)
  179. [SOLVED:] Renaming multiple worksheets from list (2 replies)
  180. Extracting directly from a text file into excel with specific conditions in theheader (3 replies)
  181. extracting object browser information (1 replies)
  182. [SOLVED:] Match, Find, Offset & Sum in loop not working (2 replies)
  183. [SOLVED:] VBA Sumif in R1C1 style not working (3 replies)
  184. Comparing two cell range (1 replies)
  185. [SOLVED:] Extracting Letters from the String (2 replies)
  186. [SOLVED:] Wildcard Filter Not Working For Dates (2 replies)
  187. Sum Variable types (3 replies)
  188. VBA Help (0 replies)
  189. Unable to View XLS File Created in Office 365 (10 replies)
  190. [SOLVED:] Trouble with CountIF Function in VBA, I think (5 replies)
  191. [SOLVED:] Worksheet/Workbook properties (7 replies)
  192. ByRef Array Button Click (2 replies)
  193. [SOLVED:] VBA Code for Worst Month from Daily Data (1 replies)
  194. [SOLVED:] Filling Empty Cells with Data based on Averages (2 replies)
  195. [SOLVED:] How to make a search filter in Excel Userform that displays the output in the ListBox (2 replies)
  196. [SOLVED:] VBA cannot resolve type mismatch error with vlookup (4 replies)
  197. Copy worksheets (names, data and format) from saved data file to open active workbook (4 replies)
  198. how to make exception when I get message of “if could not find the specified object” (3 replies)
  199. [SOLVED:] Unable to resolve type mismatch with userform entry (1 replies)
  200. Daily Cash-flow Forecast Planning (9 replies)
  201. Returning a Value (10 replies)
  202. Split range based on total (4 replies)
  203. coverting if formula to macro (1 replies)
  204. Sleeper: Macro to populate all the macros to the ribbon (0 replies)
  205. [SOLVED:] VBA Investment Returns - How to find last day of a month? (2 replies)
  206. [SOLVED:] Explanation about a specific function (2 replies)
  207. [SOLVED:] Type Mismatch (4 replies)
  208. Hide current Roll based on Cell value (1 replies)
  209. [SOLVED:] Need Help in VBA (4 replies)
  210. Why can't I UPDATE the SELECTED value from the ListBox? (13 replies)
  211. Need copied web workbook to overwrite to the same worksheet (1 replies)
  212. Chart generation loop issue (1 replies)
  213. [SOLVED:] Find and collate rows with repeated partial text in one column (16 replies)
  214. [SOLVED:] Run-Time error 9 Subscript out of range (7 replies)
  215. Filter multiple sheets with same headers in one sheet (0 replies)
  216. [SOLVED:] Excel VBA events only working on last element of Collection (6 replies)
  217. Simple Loop For Selecting a Range and Replacing Values (2 replies)
  218. VBA/macro to filter Pivot Table Filter Field (16 replies)
  219. Cell reference changes to make a change in URL (4 replies)
  220. [SOLVED:] Chartobjectsd and SeriesCollection (9 replies)
  221. Userform & scanner, won't go to the next field (5 replies)
  222. How to speed up a Change Event Loop (1 replies)
  223. Help next sheet macro (2 replies)
  224. [SOLVED:] Crashing UDF - debug tips needed (6 replies)
  225. Ribbon Toggle Buttons Issue (6 replies)
  226. [SOLVED:] If find any data on column P add CHECKED word on Column O (0 replies)
  227. [SOLVED:] How to draw out the WorkSheet properties? (8 replies)
  228. [SOLVED:] Extracting groups of Options button (5 replies)
  229. Pop up a help text on userform after hovering the mouse for 1 sec (5 replies)
  230. [SOLVED:] Worksheet formula Offset 1 Column Left & another Cell (7 replies)
  231. Change code to search multiple terms across columns (8 replies)
  232. compare pictures (4 replies)
  233. Need Help : How to do convert 1 table to another format (7 replies)
  234. [SOLVED:] Convert negative to positive numbers in range being copied (21 replies)
  235. VBA Query (7 replies)
  236. Saving files using Relative Filepath Location (5 replies)
  237. Conditionally copy content of adjacent cells to different worksheet (6 replies)
  238. VBA Formula with dynamic range. Please help (2 replies)
  239. Repeat Bottom Rows on every printed page of a worksheet (2 replies)
  240. Copy .CSV to .XLS and Formatting (1 replies)
  241. VBA API Macro Inconsistent (4 replies)
  242. [SOLVED:] Showing & Hiding Rows based on values (3 replies)
  243. [SOLVED:] Sum two dynamic totals (0 replies)
  244. [SOLVED:] Extracting Four Specific Data for each Row. Complex and Disorganized Raw Data. (11 replies)
  245. [SOLVED:] filter sublist from list in another column then filter that with another criterion (2 replies)
  246. [SOLVED:] Copy cell range onto new tabs sorted in groups (11 replies)
  247. need help in macro to select a column (2 replies)
  248. [SOLVED:] Workbook_Open operates inconsistenly (11 replies)
  249. How to run macro for multiple worksheets (3 replies)
  250. [SOLVED:] Pivot Table Name Changed Every time when Macro Runs (0 replies)