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. export and print multipe specific sheets as pdf (15 replies)
  2. get Sunday's date between 2 dates (2 replies)
  3. Command button to go to another sheet with drop button click (1 replies)
  4. [SOLVED:] vba code for an interface (4 replies)
  5. Applying VBA code written in module to all sheets in workbook (3 replies)
  6. Computing Monthly Weighted Average (10 replies)
  7. Header/Footer sticking to other ranges (1 replies)
  8. Save As function randomly replaces my file path, Error 1004 (4 replies)
  9. Worksheet Change event not working unless cell is manually changed (1 replies)
  10. Simple If Statement: Comparing function argument (1 replies)
  11. Workbook.SaveAs function, appends number to similar named files (1 replies)
  12. [SOLVED:] error on Password User form by workbook Entry (9 replies)
  13. Creating a Pivot Table Based on Two Tables (2 replies)
  14. Return specific cell in that row using row number (3 replies)
  15. [SOLVED:] loop and sum (8 replies)
  16. [SOLVED:] Changing Data Layout Excel VBA (2 replies)
  17. [SOLVED:] Searchable listbox - Multi column - additem to second column only works first time (5 replies)
  18. PDF Merger Sequence (0 replies)
  19. Vba, How can code the excel file to save as only and disable to save directly file (2 replies)
  20. Macro works via step through but does not on button click (2 replies)
  21. Getting selected items in embedded listbox (3 replies)
  22. [SOLVED:] Progress Bar VBA (24 replies)
  23. [SOLVED:] simple password protection with User Form, with possibility user can change Passwort. (0 replies)
  24. Importing files will format data (5 replies)
  25. VBA - Search For Value Across Multiple Worksheets (83 replies)
  26. Using userforms (14 replies)
  27. [SOLVED:] Delete worksheet activex listbox (12 replies)
  28. Problem comparing dates in VBA (1 replies)
  29. Graphical hiearchy (7 replies)
  30. Calendar with userform input stores irrelevant data to its table (5 replies)
  31. Sorting Help (2 replies)
  32. [SOLVED:] Conditional Formatting on a table based on a different table VBA (16 replies)
  33. [SOLVED:] VBA - Disable/ activate command button depending on Text box value (3 replies)
  34. [SOLVED:] Delete rows when copying table (7 replies)
  35. [SOLVED:] Ordering worksheet tabs in a specific order (6 replies)
  36. VBA to make formula for parent child (7 replies)
  37. User Form (2 replies)
  38. Rename the add-in caption on menu bar (0 replies)
  39. [SOLVED:] Get All Most Recent Dates per Month in a Single Column VBA (16 replies)
  40. [SOLVED:] Loop through listbox to insert to sheet (6 replies)
  41. I need help on scrolling down web pages through vba query tables (0 replies)
  42. [SOLVED:] PIVOT TABLE TROUBLES - Code runs on one workbook but not the other (2 replies)
  43. Sleeper: Importing multiple files to excel (0 replies)
  44. VBA Newbie looking for linear or polynomial fit to missing dats (19 replies)
  45. [SOLVED:] find listbox column Average (2 replies)
  46. [SOLVED:] sum digits (9 replies)
  47. [SOLVED:] update listbox (4 replies)
  48. PDF to excel (1 replies)
  49. [SOLVED:] Issue creating pivot table from table data (2 replies)
  50. [SOLVED:] Autofit last column in a table (6 replies)
  51. VBA Help using value in sheet 1 to hide unhide row in sheet 2 (9 replies)
  52. [SOLVED:] Excel - Edit contents of a string (7 replies)
  53. [SOLVED:] Excel - Make user opened file the active workbook (13 replies)
  54. [SOLVED:] select next emtpy column (10 replies)
  55. [SOLVED:] Find Last Value (not first) (9 replies)
  56. [SOLVED:] Hide specific rows in various worksheets depending on Summary worksheet cell value (3 replies)
  57. Duplicate Values in Data Validation (7 replies)
  58. VBA Pasting from table to different sheets without using sheets("x").Select HELP!!! (3 replies)
  59. Building up sentence variable within cells (4 replies)
  60. [SOLVED:] concatenate variable values (1 replies)
  61. [SOLVED:] Hide textbox with selected item in combobox (5 replies)
  62. 3 Reference Formulas Not Returning a Result (14 replies)
  63. Hyperlink warning message (9 replies)
  64. [SOLVED:] Complete data of a master table without overwriting given data (12 replies)
  65. Text in textbox only updates once (1 replies)
  66. [SOLVED:] How to set currency with different starting values (68 replies)
  67. Writing array to sheet (10 replies)
  68. After clicking the linked cell to move back linked cell without using F5+Enter (2 replies)
  69. Split comma to rows (15 replies)
  70. [SOLVED:] Insert Picture from Directory on Cell Value Changed by Formula (20 replies)
  71. VBA script to search a text in google maps (0 replies)
  72. Add Table to Data Model (Pivot Table) (0 replies)
  73. Trim rows in multiple sheets (2 replies)
  74. Conditional Formatting using formula as condition (4 replies)
  75. [SOLVED:] How to pull XML data into another excel sheet using VBA? (54 replies)
  76. Cut Data Once It Has Been Selected (3 replies)
  77. [SOLVED:] index/match based on variable range (2 replies)
  78. [SOLVED:] Change font size of rows in a range with bold letters (20 replies)
  79. [SOLVED:] Data Validation based on Condition(s) in Excel VBA (15 replies)
  80. [SOLVED:] Write part of 2D Array to Sheet (3 replies)
  81. [SOLVED:] Putting a time limit on QueryTable.Refresh (1 replies)
  82. [SOLVED:] Part of a string (7 replies)
  83. [SOLVED:] Formula to fill down used range (5 replies)
  84. Only the string (3 replies)
  85. [SOLVED:] Excel Formula to compare between actual values and target values (3 replies)
  86. sumifs filtered data (4 replies)
  87. Basic VBA Function to calculate the volume of a cone (5 replies)
  88. [SOLVED:] Split Cell into multiple column via VBA (8 replies)
  89. [SOLVED:] Excel keeps calculating (3 replies)
  90. [SOLVED:] Creating a single Table with different formulas Excel VBA (78 replies)
  91. [SOLVED:] Copy files by name from a folder to another (5 replies)
  92. code running on more than 1 sheet (2 replies)
  93. Copy to new workbook and remove blank rows (1 replies)
  94. VBA to add numbers in columns from various workbooks (11 replies)
  95. Macro to autofilter data from several sheets in workbook and copy to new worksheet (1 replies)
  96. Set Last Modified date & time to preset value on Save or Save As (9 replies)
  97. VBA MACRO Button click using a class instead of ID (4 replies)
  98. Creating dynamic List on Workbook Startup (13 replies)
  99. Run time error '1004' Cannot access 'Macroed-Upload_Temp.xlsx' (0 replies)
  100. For Each Then Next (5 replies)
  101. Coming to the dark Side (25 replies)
  102. [SOLVED:] First Login Last Logout - Formula (2 replies)
  103. Looping Through Two Columns (9 replies)
  104. vba find the latest date and a corresponding value (7 replies)
  105. [SOLVED:] VBA to select cell in active row (14 replies)
  106. Vba code on looping (0 replies)
  107. [SOLVED:] Macro Copy & Paste: Numeric to Alphanumeric (3 replies)
  108. [Beginner] Select and Cut with conditions (1 replies)
  109. Copy & Paste to the next empy cell. (Vba Code not Working) (1 replies)
  110. How to get dates of all mondays between 2 dates? (5 replies)
  111. copy and paste question (46 replies)
  112. How to copy and insert shapes with increase in series of text inside of shape ie 1,2, (2 replies)
  113. [SOLVED:] Moving data between two sheets VBA (26 replies)
  114. When changing the active worksheet - need VBA that will make it's chart display? (5 replies)
  115. [SOLVED:] Combine countifs & Subtotal (5 replies)
  116. [SOLVED:] Need help copying cells from one sheet to another.. (41 replies)
  117. [SOLVED:] notification by vba (4 replies)
  118. Customer Statement of Account (3 replies)
  119. VBA for New Format (0 replies)
  120. [SOLVED:] insert data for open positions (4 replies)
  121. [SOLVED:] Advance filtering unique records (5 replies)
  122. VBA for inserting Rows with conditions (4 replies)
  123. Early vs. Late Binding (4 replies)
  124. from mastersheet to other sheets (find the last blank raw) (3 replies)
  125. [SOLVED:] Conditional expression (3 replies)
  126. Having troubles with XlFillDefault (4 replies)
  127. [SOLVED:] Create new column (4 replies)
  128. Help automatically refreshing a year using VBA (7 replies)
  129. [SOLVED:] Formatting issues (29 replies)
  130. Consolidate Pivot Table Cache - VBA (1 replies)
  131. VBA to move JPGs from sub-folders to destination folder using a list (0 replies)
  132. Copy files from one Location to another (0 replies)
  133. Creating a Search Concat for Sharepoint files (0 replies)
  134. populate combo box with conditions (5 replies)
  135. VBA Code to highlight Odd and Even numbers (18 replies)
  136. Run macros on whole workbook (2 replies)
  137. Query (0 replies)
  138. Cell equal value new value of active cell which is a drop down (2 replies)
  139. [SOLVED:] Use the same Variable in the module (2 replies)
  140. On time assistance required (2 replies)
  141. Stop save if table has empty cells (3 replies)
  142. Parse text to array (7 replies)
  143. Sleeper: Keep a timestamped log when any worksheet is unprotected? (1 replies)
  144. [SOLVED:] Error 13 - Mismatch in UserForm update Application.Match with mixed Data (2 replies)
  145. [SOLVED:] Copy Workbook Name (7 replies)
  146. Cell back color (3 replies)
  147. [SOLVED:] Update Schedule Sheet with Jobs (1 replies)
  148. [SOLVED:] Named Ranges Error - Please help! (1 replies)
  149. VBA - Macro to open a file based on part of text in cell (15 replies)
  150. [SOLVED:] Conditional Format Calendar Events (1 replies)
  151. Advice on 'OnTime' (4 replies)
  152. Replace non-contiguous column range with Offset column range in Chart SeriesCollectio (0 replies)
  153. [SOLVED:] VBA entering a nested formula with text (4 replies)
  154. [SOLVED:] Calendar Times Not in Order (3 replies)
  155. Create an array removing duplicates from list but keeping last occurence (10 replies)
  156. HELP! Cant figure out how to modify code based on new requirement (3 replies)
  157. Getting script Error 9 Run time error while declaring variable of Sheet (7 replies)
  158. [SOLVED:] Replace table with Userform (34 replies)
  159. Copy Rows data to column (1 replies)
  160. [SOLVED:] Excel VBA Userform Comboboxes not populating with external data range (3 replies)
  161. vba, how to code to select cell after certain filter field (3 replies)
  162. SetFocus with Frames not Working (9 replies)
  163. Help me please! Basic Excel macro! (7 replies)
  164. programatically added controls do not show up (17 replies)
  165. fixing summing and subtracting among sheets in the same range (0 replies)
  166. Azure Connection via VB error (2 replies)
  167. Need help (If Statement) (4 replies)
  168. Auto save workbook when locked cell is modified (1 replies)
  169. Looping through worksheets to sort (2 replies)
  170. [SOLVED:] Help on Moving file to another folder, using partial filename (37 replies)
  171. Delete Image (1 replies)
  172. VBA in excel : making a Stock list (5 replies)
  173. How do i add a string in a column like "1 week" or "12 months" into cell with a date (2 replies)
  174. [SLEEPER:] VBA Hierarchy (1 replies)
  175. Formatting question (12 replies)
  176. Loop through slicers in PivotTable/PivotChart and export to PowerPoint? (1 replies)
  177. COUNTIFS in VBA with data on multiple sheets (4 replies)
  178. Excel Camera Tool (7 replies)
  179. How do I search a spread sheet for a time (4 replies)
  180. Multi selection list (1 replies)
  181. Excel VBA upload via SFTP (3 replies)
  182. [SOLVED:] VBA Excel: Ranges (4 replies)
  183. VBA Excel : Boolean loop to check last full column (7 replies)
  184. Looking for a VBA code/Macro to Export Pivot Data into a CSV File on click of button (1 replies)
  185. Match worksheet function in VBA searching on multiple criteria (11 replies)
  186. [SOLVED:] VBA - Pivot table and charts - Automation (4 replies)
  187. [SOLVED:] Need to show and hide named ranges based on cell value (5 replies)
  188. Dynamic Hyperlink VBA (1 replies)
  189. VBA Do While Loop Question (3 replies)
  190. How to combine hidden sheets using VBA (1 replies)
  191. Copied Excel Macro to VBA code. (3 replies)
  192. [SOLVED:] Offset in a double nested loop. (4 replies)
  193. VBA Help splitting data based on a ID # (3 replies)
  194. Autofilling sequential numbers counting from inputted number in a userform (3 replies)
  195. vb dynamic print data in worksheet based on selected from listbox (0 replies)
  196. VBA SORT ORDER CRASHES EXCEL (0 replies)
  197. VBA code not executing and excel have to be shut down by endtask (4 replies)
  198. - Office 365 - ListBox MultiPage (0 replies)
  199. Code for copy/paste from list to new sheets (0 replies)
  200. Part of a string (5 replies)
  201. Insert cell at specific rows by string (4 replies)
  202. delete entire row (1 replies)
  203. Editable Auto Numbering (4 replies)
  204. Finding a value by date and time. Quickly without looping. (23 replies)
  205. Identifying Declining Sales by Sku (2 replies)
  206. [SOLVED:] A Question on VBA input box (3 replies)
  207. Transfer Multiple Data From Multiple Rows to one Column (Transpose form) (2 replies)
  208. [SOLVED:] VBA: Select cell thats two columns ahead and make changes to it (and current cell) (2 replies)
  209. [SOLVED:] Nesting MsgBox gives Syntax Error? (2 replies)
  210. COPY AND PASTE OF DATA (1 replies)
  211. Search specific Numbers with Different criteria (6 replies)
  212. 2 column condition move duplicates to new sheet (14 replies)
  213. [SOLVED:] Code Not called on button click (7 replies)
  214. Conditional sum with DATE in VBA (3 replies)
  215. Split the data into multiple excel Files based on the column Filters (0 replies)
  216. Final Results of VBA Loop overwriting all previous iteration results (1 replies)
  217. [SOLVED:] VBA import from csv - copy into existing cells rather than insert new (3 replies)
  218. Vlookup in VBA: Creating dynamic List and lookup Multiple Values (7 replies)
  219. [SOLVED:] Can't refer to Add-in Worksheet for Goal Seek function (1 replies)
  220. conditional formating (6 replies)
  221. info macro for MAC OS import html jpeg (0 replies)
  222. Changing ActiveX control properties based on cell text (30 replies)
  223. EXCEL 360 vba code print hidden excel sheets (6 replies)
  224. How to offset a curve in VBA (1 replies)
  225. [SOLVED:] VBA: If And Then Else Run-Time error '13' (2 replies)
  226. Create Powerpoint Slides and Add Titles and links (0 replies)
  227. Macro for saving active work books to new file type (7 replies)
  228. VBA To Autofill a formula across multiple specific columns (1 replies)
  229. Transferring data from a table on one sheet to another and appending the existing dat (2 replies)
  230. [SOLVED:] PLS Help For Each loop (detailed info of the problem) (8 replies)
  231. How to transfer data from an array to a matrix? (2 replies)
  232. VBA Code Help Needed (0 replies)
  233. ".findformat.font.Italic=false" code needed (10 replies)
  234. VBA Macro Named Pipe IPC (1 replies)
  235. Insert row with template row of formulas (3 replies)
  236. Trying to reference a range of cells inside of a table and call a function OnChange (1 replies)
  237. If conditions are met, copy to new worksheet (4 replies)
  238. Copy data from one workbook to another using VBA (3 replies)
  239. Copy Paste Shapes from one worksheet to another using Clipboard - Excel VBA (4 replies)
  240. Macro toggle button (4 replies)
  241. Automatically fill calender (1 replies)
  242. Reveal all matches with FIND function (2 replies)
  243. [SOLVED:] Applying conditional formatting on range of criteria dependent cells (6 replies)
  244. [SOLVED:] VBA code for vlookup in multiple worksheets (2 replies)
  245. [SOLVED:] Week number instead of Day Dates (2 replies)
  246. List Files (Specific File Type) from Folder & Sub-folders to Excel w/ VBA (0 replies)
  247. Converting DOS Commands to VBA Function (2 replies)
  248. Cell Address Goal Seek (0 replies)
  249. [SOLVED:] Seek matching text in cells and if match found enter info in third cell (2 replies)
  250. VBA Code needed. if more than 90 days, Message Box Expired, Elseif still valid (0 replies)