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:] Split Cell into multiple column via VBA (8 replies)
  2. [SOLVED:] Excel keeps calculating (3 replies)
  3. [SOLVED:] Creating a single Table with different formulas Excel VBA (78 replies)
  4. [SOLVED:] Copy files by name from a folder to another (5 replies)
  5. code running on more than 1 sheet (2 replies)
  6. Copy to new workbook and remove blank rows (1 replies)
  7. VBA to add numbers in columns from various workbooks (11 replies)
  8. Macro to autofilter data from several sheets in workbook and copy to new worksheet (1 replies)
  9. [SLEEPER:] Set Last Modified date & time to preset value on Save or Save As (9 replies)
  10. VBA MACRO Button click using a class instead of ID (4 replies)
  11. Creating dynamic List on Workbook Startup (13 replies)
  12. Run time error '1004' Cannot access 'Macroed-Upload_Temp.xlsx' (0 replies)
  13. For Each Then Next (5 replies)
  14. Coming to the dark Side (25 replies)
  15. [SOLVED:] First Login Last Logout - Formula (2 replies)
  16. Looping Through Two Columns (9 replies)
  17. vba find the latest date and a corresponding value (7 replies)
  18. [SOLVED:] VBA to select cell in active row (14 replies)
  19. Vba code on looping (0 replies)
  20. [SOLVED:] Macro Copy & Paste: Numeric to Alphanumeric (3 replies)
  21. [Beginner] Select and Cut with conditions (1 replies)
  22. Copy & Paste to the next empy cell. (Vba Code not Working) (1 replies)
  23. How to get dates of all mondays between 2 dates? (5 replies)
  24. copy and paste question (46 replies)
  25. How to copy and insert shapes with increase in series of text inside of shape ie 1,2, (2 replies)
  26. [SOLVED:] Moving data between two sheets VBA (26 replies)
  27. When changing the active worksheet - need VBA that will make it's chart display? (5 replies)
  28. [SOLVED:] Combine countifs & Subtotal (5 replies)
  29. [SOLVED:] Need help copying cells from one sheet to another.. (41 replies)
  30. [SOLVED:] notification by vba (4 replies)
  31. Customer Statement of Account (3 replies)
  32. VBA for New Format (0 replies)
  33. [SOLVED:] insert data for open positions (4 replies)
  34. [SOLVED:] Advance filtering unique records (5 replies)
  35. VBA for inserting Rows with conditions (4 replies)
  36. Early vs. Late Binding (4 replies)
  37. from mastersheet to other sheets (find the last blank raw) (3 replies)
  38. [SOLVED:] Conditional expression (3 replies)
  39. Having troubles with XlFillDefault (4 replies)
  40. [SOLVED:] Create new column (4 replies)
  41. Help automatically refreshing a year using VBA (7 replies)
  42. [SOLVED:] Formatting issues (29 replies)
  43. Consolidate Pivot Table Cache - VBA (1 replies)
  44. VBA to move JPGs from sub-folders to destination folder using a list (0 replies)
  45. Copy files from one Location to another (0 replies)
  46. Creating a Search Concat for Sharepoint files (0 replies)
  47. populate combo box with conditions (5 replies)
  48. VBA Code to highlight Odd and Even numbers (18 replies)
  49. Run macros on whole workbook (2 replies)
  50. Query (0 replies)
  51. Cell equal value new value of active cell which is a drop down (2 replies)
  52. [SOLVED:] Use the same Variable in the module (2 replies)
  53. On time assistance required (2 replies)
  54. Stop save if table has empty cells (3 replies)
  55. Parse text to array (7 replies)
  56. Sleeper: Keep a timestamped log when any worksheet is unprotected? (1 replies)
  57. [SOLVED:] Error 13 - Mismatch in UserForm update Application.Match with mixed Data (2 replies)
  58. [SOLVED:] Copy Workbook Name (7 replies)
  59. Cell back color (3 replies)
  60. [SOLVED:] Update Schedule Sheet with Jobs (1 replies)
  61. [SOLVED:] Named Ranges Error - Please help! (1 replies)
  62. VBA - Macro to open a file based on part of text in cell (15 replies)
  63. [SOLVED:] Conditional Format Calendar Events (1 replies)
  64. Advice on 'OnTime' (4 replies)
  65. Replace non-contiguous column range with Offset column range in Chart SeriesCollectio (0 replies)
  66. [SOLVED:] VBA entering a nested formula with text (4 replies)
  67. [SOLVED:] Calendar Times Not in Order (3 replies)
  68. Create an array removing duplicates from list but keeping last occurence (10 replies)
  69. HELP! Cant figure out how to modify code based on new requirement (3 replies)
  70. Getting script Error 9 Run time error while declaring variable of Sheet (7 replies)
  71. [SOLVED:] Replace table with Userform (34 replies)
  72. Copy Rows data to column (1 replies)
  73. [SOLVED:] Excel VBA Userform Comboboxes not populating with external data range (3 replies)
  74. vba, how to code to select cell after certain filter field (3 replies)
  75. [SLEEPER:] SetFocus with Frames not Working (9 replies)
  76. Help me please! Basic Excel macro! (7 replies)
  77. programatically added controls do not show up (17 replies)
  78. fixing summing and subtracting among sheets in the same range (0 replies)
  79. Azure Connection via VB error (2 replies)
  80. Need help (If Statement) (4 replies)
  81. Auto save workbook when locked cell is modified (1 replies)
  82. Looping through worksheets to sort (2 replies)
  83. [SOLVED:] Help on Moving file to another folder, using partial filename (37 replies)
  84. Delete Image (1 replies)
  85. VBA in excel : making a Stock list (5 replies)
  86. How do i add a string in a column like "1 week" or "12 months" into cell with a date (2 replies)
  87. [SLEEPER:] VBA Hierarchy (1 replies)
  88. Formatting question (12 replies)
  89. Loop through slicers in PivotTable/PivotChart and export to PowerPoint? (1 replies)
  90. COUNTIFS in VBA with data on multiple sheets (4 replies)
  91. Excel Camera Tool (7 replies)
  92. How do I search a spread sheet for a time (4 replies)
  93. Multi selection list (1 replies)
  94. Excel VBA upload via SFTP (3 replies)
  95. [SOLVED:] VBA Excel: Ranges (4 replies)
  96. VBA Excel : Boolean loop to check last full column (7 replies)
  97. Looking for a VBA code/Macro to Export Pivot Data into a CSV File on click of button (1 replies)
  98. Match worksheet function in VBA searching on multiple criteria (11 replies)
  99. [SOLVED:] VBA - Pivot table and charts - Automation (4 replies)
  100. [SOLVED:] Need to show and hide named ranges based on cell value (5 replies)
  101. [SLEEPER:] Dynamic Hyperlink VBA (1 replies)
  102. VBA Do While Loop Question (3 replies)
  103. How to combine hidden sheets using VBA (1 replies)
  104. Copied Excel Macro to VBA code. (3 replies)
  105. [SOLVED:] Offset in a double nested loop. (4 replies)
  106. VBA Help splitting data based on a ID # (3 replies)
  107. Autofilling sequential numbers counting from inputted number in a userform (3 replies)
  108. vb dynamic print data in worksheet based on selected from listbox (0 replies)
  109. VBA SORT ORDER CRASHES EXCEL (0 replies)
  110. VBA code not executing and excel have to be shut down by endtask (4 replies)
  111. - Office 365 - ListBox MultiPage (0 replies)
  112. Code for copy/paste from list to new sheets (0 replies)
  113. Part of a string (5 replies)
  114. Insert cell at specific rows by string (4 replies)
  115. delete entire row (1 replies)
  116. Editable Auto Numbering (4 replies)
  117. Finding a value by date and time. Quickly without looping. (23 replies)
  118. Identifying Declining Sales by Sku (2 replies)
  119. [SOLVED:] A Question on VBA input box (3 replies)
  120. Transfer Multiple Data From Multiple Rows to one Column (Transpose form) (2 replies)
  121. [SOLVED:] VBA: Select cell thats two columns ahead and make changes to it (and current cell) (2 replies)
  122. [SOLVED:] Nesting MsgBox gives Syntax Error? (2 replies)
  123. COPY AND PASTE OF DATA (1 replies)
  124. Search specific Numbers with Different criteria (6 replies)
  125. 2 column condition move duplicates to new sheet (14 replies)
  126. [SOLVED:] Code Not called on button click (7 replies)
  127. Conditional sum with DATE in VBA (3 replies)
  128. Split the data into multiple excel Files based on the column Filters (0 replies)
  129. Final Results of VBA Loop overwriting all previous iteration results (1 replies)
  130. [SOLVED:] VBA import from csv - copy into existing cells rather than insert new (3 replies)
  131. Vlookup in VBA: Creating dynamic List and lookup Multiple Values (7 replies)
  132. [SOLVED:] Can't refer to Add-in Worksheet for Goal Seek function (1 replies)
  133. conditional formating (6 replies)
  134. info macro for MAC OS import html jpeg (0 replies)
  135. Changing ActiveX control properties based on cell text (30 replies)
  136. EXCEL 360 vba code print hidden excel sheets (6 replies)
  137. How to offset a curve in VBA (1 replies)
  138. [SOLVED:] VBA: If And Then Else Run-Time error '13' (2 replies)
  139. Create Powerpoint Slides and Add Titles and links (0 replies)
  140. Macro for saving active work books to new file type (7 replies)
  141. VBA To Autofill a formula across multiple specific columns (1 replies)
  142. Transferring data from a table on one sheet to another and appending the existing dat (2 replies)
  143. [SOLVED:] PLS Help For Each loop (detailed info of the problem) (8 replies)
  144. How to transfer data from an array to a matrix? (2 replies)
  145. VBA Code Help Needed (0 replies)
  146. ".findformat.font.Italic=false" code needed (10 replies)
  147. VBA Macro Named Pipe IPC (1 replies)
  148. [SOLVED:] Insert row with template row of formulas (3 replies)
  149. Trying to reference a range of cells inside of a table and call a function OnChange (1 replies)
  150. [SLEEPER:] If conditions are met, copy to new worksheet (4 replies)
  151. Copy data from one workbook to another using VBA (3 replies)
  152. [SLEEPER:] Copy Paste Shapes from one worksheet to another using Clipboard - Excel VBA (4 replies)
  153. Macro toggle button (4 replies)
  154. Automatically fill calender (1 replies)
  155. Reveal all matches with FIND function (2 replies)
  156. [SOLVED:] Applying conditional formatting on range of criteria dependent cells (6 replies)
  157. [SOLVED:] VBA code for vlookup in multiple worksheets (2 replies)
  158. [SOLVED:] Week number instead of Day Dates (2 replies)
  159. List Files (Specific File Type) from Folder & Sub-folders to Excel w/ VBA (0 replies)
  160. Converting DOS Commands to VBA Function (2 replies)
  161. Cell Address Goal Seek (0 replies)
  162. [SOLVED:] Seek matching text in cells and if match found enter info in third cell (2 replies)
  163. VBA Code needed. if more than 90 days, Message Box Expired, Elseif still valid (0 replies)
  164. [SOLVED:] VBA code to prompt message " file in use" please wait (5 replies)
  165. Find and Replace not working (0 replies)
  166. VBA: Export to PDF combination of cells (0 replies)
  167. Formula for sale (0 replies)
  168. I need VBA code (5 replies)
  169. Lookup a date range by Matching a column data set in a table & fetch respective data (0 replies)
  170. [SOLVED:] byref argument type mismatch (1 replies)
  171. Case with boolean (2 replies)
  172. [SOLVED:] Why does my Array only fill half way? (5 replies)
  173. Changing first name to initial only, adding second initial and combining repeats (3 replies)
  174. [SOLVED:] Data type mismatch with VBA Range.Copy & Range.PasteSpecial (2 replies)
  175. [SOLVED:] Keep 1 Record every 5 duplicate (4 replies)
  176. [SOLVED:] Use a variable for subroutine name (6 replies)
  177. Auto copy and paste query table (0 replies)
  178. VBA macro to copy from various sheet to a new file (1 replies)
  179. [SOLVED:] Declaring a variable using part of a filepath name (3 replies)
  180. Noob to vba - loop not looking at all (2 replies)
  181. Help?! Run-time error 6 overflow (6 replies)
  182. Speed Up VBA Macro (2 replies)
  183. [SOLVED:] Modifying existing form - how to add date picker (11 replies)
  184. Seperate Data by trade ID and Date (0 replies)
  185. Seeking help to make cell ranges dynamic (4 replies)
  186. [SOLVED:] VBA function - Inputting multiple cells instead of a complete range of cells? (5 replies)
  187. VBA Printing only columns with data (0 replies)
  188. vba excel macro for print button (1 replies)
  189. Looping Through Pivot Items (0 replies)
  190. Ensure that only unique values are extracted (2 replies)
  191. Search and Extract related data from TXT file and append into Excel (3 replies)
  192. [SOLVED:] Embedded Templates (12 replies)
  193. [SOLVED:] Editing part of a string (2 replies)
  194. Combining Multiple Worksheets with Same Table Headers (3 replies)
  195. Sleeper: Macro to compare two workbook (3 replies)
  196. EXCEL syntax isue (2 replies)
  197. Select cells with input box and unlock them in a protected worksheet (15 replies)
  198. [SOLVED:] Using Structured Cell References (4 replies)
  199. Selecting Pivot Table Range with Dynamic Data (1 replies)
  200. Extract Crossing new Sheet (2 replies)
  201. vba Help - extract Matching value (3 replies)
  202. Out of memory - find and replace part of hyperlink (0 replies)
  203. If Pivot Item = "" then skip (0 replies)
  204. [SLEEPER:] Adjusting code calling data in worksheet (3 replies)
  205. Import data to excel (0 replies)
  206. URGENT HELP PLEASE Copying same data to multiple rows (0 replies)
  207. [SOLVED:] Loop a sort function (2 replies)
  208. VBA to check if cell changed (1 replies)
  209. [SOLVED:] Single column into matrix (2 replies)
  210. Resizing a table to size 1 row (7 replies)
  211. VBA form question (6 replies)
  212. Sleeper: Trying to Sort "Multiple Rows" together (2 replies)
  213. Changing column types (1 replies)
  214. Caculate From One Cell & a Dimension Table (1 replies)
  215. [SOLVED:] Filling one Cell from another Cell (3 replies)
  216. [SOLVED:] Merge multiple Excel files into ONE WORKSHEET (14 replies)
  217. How can I modify this code to use a cell value when naming the new workbooks? (1 replies)
  218. COUNTIF Column based in VBA (1 replies)
  219. Automatically updating date cell unless row is blank (2 replies)
  220. Extract unique values from column based on criteria (0 replies)
  221. MACRO/VBA - Extract unique values to different worksheet that meets a criteria (0 replies)
  222. VBA - capacity smoothing (4 replies)
  223. Using Index Match with an unknown range (5 replies)
  224. [SOLVED:] A Class Module to store Images from a folder for later reuse in Workbook Excel VBA (31 replies)
  225. VBA to compare values in 2 cells and post a value in another (1 replies)
  226. Importing Images/Pictures/Shapes from a Closed Excel Workbook (12 replies)
  227. Sleeper: Overcoming ADO Recordset 64 Characters limitation for Fields (13 replies)
  228. VBA Pasting values to different cells in the same named range (7 replies)
  229. How can I write VBA macro for bchain() and bdh()? (3 replies)
  230. PDF creating and past copy different folder (0 replies)
  231. Remove "Filters" from Macro Script (2 replies)
  232. [SOLVED:] VBA Conditional formatting - multiple adjacent cells if specific text on left (10 replies)
  233. Parse rows to sheets (1 replies)
  234. [SOLVED:] AverageIfs to compare AM vs PM hours (4 replies)
  235. Macro IF statements (1 replies)
  236. [SOLVED:] IF Statement using VBA (5 replies)
  237. Copy cell data from one protected file to another (1 replies)
  238. [SOLVED:] sort data within the same cell (1 replies)
  239. Setting Linked cell to another work sheet (6 replies)
  240. VBA userform listbox - hard set range to specific sheet (2 replies)
  241. Make code more variable (8 replies)
  242. [SOLVED:] Match Error 2042 (2 replies)
  243. [SOLVED:] Export pivot table to individual PDF (2 replies)
  244. Question about clear, clear contents (11 replies)
  245. Reference to Lists in another workbook (1 replies)
  246. [SOLVED:] VBA coding for Excel problem (4 replies)
  247. [SOLVED:] Worksheet_BeforeDoubleClick (1 replies)
  248. [SOLVED:] Create a border around a range for specific criteria (3 replies)
  249. Help reversing calculations. (2 replies)
  250. Removing parts before each item (4 replies)