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. Select Random cells from range (2 replies)
  2. PLEASE HELP ME!!! (10 replies)
  3. [SOLVED:] Refer to range in cell formula (3 replies)
  4. counting number of occurrence of a value and depositing that number in another column (18 replies)
  5. Userform with listbox and checkboxes that finds values on a worksheet (1 replies)
  6. [SOLVED:] Match FileNames and then Merge those PDFs (26 replies)
  7. [SOLVED:] How to fetch data from a excel table with multiple rows. (11 replies)
  8. pick a new interior color from an array when next color is needed (6 replies)
  9. Multiple Rowsource in combo box? (7 replies)
  10. Help with random selection and variable criteria (0 replies)
  11. easy VBA seek for help! (5 replies)
  12. [SOLVED:] Pass Params on Activate event (6 replies)
  13. Array only returning first column of values (26 replies)
  14. [SOLVED:] Fill Column (11 replies)
  15. Macro for sorting by lot number, splitting table w/new header, then sort by due date (2 replies)
  16. [SOLVED:] Linking a commandbar button to a macro in an addin (3 replies)
  17. [SOLVED:] Data Conversion using Dynamic Multi-Dimensional Array (12 replies)
  18. vba - Extract Unique values from Single Column via Colllection and Dictionary (9 replies)
  19. Get first and last dates (dd/mm/jj) from year range (4 replies)
  20. VBA code: copy data from sheet and paste values onto another specidied workbook (8 replies)
  21. [SOLVED:] Changing Column Headers (15 replies)
  22. [SLEEPER:] Bad file name or number - Runtime Error 52 (5 replies)
  23. [SOLVED:] Copy Data from worksheet to another one with VBA (6 replies)
  24. copy and change date (4 replies)
  25. [SOLVED:] Cannot show merged cells (18 replies)
  26. VBA to perform lookup for individual lookup range (8 replies)
  27. [SOLVED:] Count only visible data after filtering (16 replies)
  28. Running macro on files in a folder: impossibly hard! (8 replies)
  29. [SOLVED:] Sum values vba code (10 replies)
  30. Inserting Recordeset into Access DB via VBE - Error operation must be an updatable... (1 replies)
  31. Search string if it contains words from a range then replace with adjacent cell (10 replies)
  32. Prepare hierarchical and non-numeric pivot tables in Excel (6 replies)
  33. [SLEEPER:] How to remove [TAG 001], [TAG 002], [TAG 003], etc from string (12 replies)
  34. [SLEEPER:] Delete certain rows and highlight certain cells (7 replies)
  35. Splitting up a String (17 replies)
  36. [SOLVED:] Copy value - Another Excel (1 replies)
  37. [SOLVED:] Clear all textboxes except 1 (3 replies)
  38. [SOLVED:] Between two numbers (6 replies)
  39. [SOLVED:] Interactive Way to Search Based on First Few Characters Typed (4 replies)
  40. Excel 2016 Open Read Only file (9 replies)
  41. [SOLVED:] Copy and rename multiple sheets (6 replies)
  42. Declared public variables have ceased to pick up values (9 replies)
  43. Apply AutoFilter based on selected cell in another sheet (2 replies)
  44. Is there any event allowing Cancel of closing a Window (not closing a Workbook)? (2 replies)
  45. [SOLVED:] When you have one workbook, two windows, does any event happen closing second window? (2 replies)
  46. Range.Find Issues (2 replies)
  47. [SOLVED:] How to Copy Paste Symbols-Phonetics Data to Excel sheet? (5 replies)
  48. [SOLVED:] Turning off alerts issue (2 replies)
  49. [SOLVED:] Combine common worksheet names when splitting a file (7 replies)
  50. [SOLVED:] Combo Box Index select (12 replies)
  51. VBA Array Help in filtering data with logic (1 replies)
  52. [SOLVED:] VBA- Variable declaration help (14 replies)
  53. newbie vba questions & help with posible loop for multiple cell values to sheet (3 replies)
  54. Insert a line break after word wrap (17 replies)
  55. Replacing multiple numerical values (7 replies)
  56. Subscript out of range error in VBA code (4 replies)
  57. simple copy-past (4 replies)
  58. [SOLVED:] Run-time error '424': Object Required (3 replies)
  59. [SOLVED:] Pull rows from array given two conditions (1 replies)
  60. MISSING DATA IN EXPORTING CALCULATED QUERYTable FROM ACCESS TO EXCEL USING EXCEL ADO (3 replies)
  61. Copying multiple text files into one excel but different tabs (3 replies)
  62. Date Picker VBA that will work on all versions of excel (2 replies)
  63. VBA - Collection help.. (9 replies)
  64. [SOLVED:] How to Add Different Texts to End of Excel Cells Macro (3 replies)
  65. [SLEEPER:] Combine multiple txt files (1 replies)
  66. Room Booking System (10 replies)
  67. [SOLVED:] VBA - Filling Master Template (3 replies)
  68. Formula/vba - Summary Report without Pivot (4 replies)
  69. Like expression with AND or OR (3 replies)
  70. [SOLVED:] Finding cells formatted with colour gradients of various colours (7 replies)
  71. Help VBA search (3 replies)
  72. Using non-contiguous ranges in Solver VBA (1 replies)
  73. Solver in Userform Linked in Excel (2 replies)
  74. [SLEEPER:] Convert Binary to decimal on and vice versa on VBA (15 replies)
  75. auto fit cell height for merged cells in sheet that has protected (locked) cells (4 replies)
  76. Replacing Date with Period Based on Matrix (7 replies)
  77. Sleeper: AdvancedFilter - Unique Column 1, Greater than 0 Column 3 (3 replies)
  78. [SOLVED:] Transferring selected cells to a new sheet (13 replies)
  79. Publish to Sharepoint (5 replies)
  80. Search for a string in text files. (3 replies)
  81. [SOLVED:] Delete text line with specific word from multiline cell (12 replies)
  82. [SOLVED:] Part of a string (5 replies)
  83. EXPORTING DATA TO MS ACCESS FOR SIMULTANEOUS MULTI USER (1 replies)
  84. [SOLVED:] copy multiple rows of numbers to new location on same sheet. (24 replies)
  85. Check if labels are visible (3 replies)
  86. [SOLVED:] How to define range based on the value of another cell (2 replies)
  87. [SOLVED:] I want my reset button on VBA userform to do nothing if "no" is selected (4 replies)
  88. VBA to check if object is inside or outside of freeform area (6 replies)
  89. Help!! Merging multiple Excel workbooks into one master sheet. (5 replies)
  90. Advice on comparing excel workbooks (2 replies)
  91. Please help VBA Coding for Repeat Task for Step 2 to Step 6 (1 replies)
  92. [SOLVED:] question re "for each range in target" (4 replies)
  93. [SOLVED:] Highlight cells that contain specific words (8 replies)
  94. [SLEEPER:] VBA code to copy to new workbook and insert pivot (4 replies)
  95. [SOLVED:] help adjusting code delete empty rows based on condition from sheet1 to sheet2 (9 replies)
  96. [SOLVED:] Add Roundup formula to VBA button (9 replies)
  97. UserForm to Return the MAX date in a TextBox resulting from VLOOKUP in ComboBox (26 replies)
  98. [SOLVED:] vba sum format number with currency (20 replies)
  99. [SLEEPER:] Formulas no longer work in Excel for Office 365 (2 replies)
  100. [SOLVED:] Extract numbers starting with 07 (2 replies)
  101. Multi-use UForm - can it be improved upon? (4 replies)
  102. [SOLVED:] How to Log Changes on Sheets! (5 replies)
  103. vba copy paste (1 replies)
  104. VBA Macros to Copy Data to Another Workbook (10 replies)
  105. Copy data between sheets (18 replies)
  106. VBA Error 'Range of object worksheet failed (5 replies)
  107. [SOLVED:] Reformat a table (3 replies)
  108. [SOLVED:] Identify missing numbers in sequence (8 replies)
  109. [SOLVED:] Finding/Changing Default Printer (7 replies)
  110. [SLEEPER:] Require VBA Code for filter Data after criteria match (5 replies)
  111. VBA Validation Fields and Date and Time Picker (0 replies)
  112. [SOLVED:] VBA from text to number (14 replies)
  113. Pull from Table1,Table2, Test Data, Then place in Table3 (1 replies)
  114. [SOLVED:] VBA Code not running if sheets are protected (11 replies)
  115. Customize ribbon 2013 excel (3 replies)
  116. vba advanced_Filter help (1 replies)
  117. help adjusting code combine two tables from two sheets to another sheet (10 replies)
  118. Keep userform open when opening or closing other workbooks (3 replies)
  119. Selecting (copying) specific rows up to the last column (6 replies)
  120. How to share an Excel file containing a macro on the network (4 replies)
  121. Input box to display as ****** (5 replies)
  122. VBA: Input cell data outout in three ways (3 replies)
  123. If cell is Empty! (2 replies)
  124. Pull data from one table to another (0 replies)
  125. VBA Search form (1 replies)
  126. [SOLVED:] Make Array with Full Paths to PDF Files in Parent and Subfolders (24 replies)
  127. small with condition (1 replies)
  128. [SOLVED:] User type not defined error trying to merge pdfs (0 replies)
  129. Update chart after cell gets updated (2 replies)
  130. [SOLVED:] VBA SPLIT into cells and reshape into table (11 replies)
  131. How Can I Build Chat with Vba? (0 replies)
  132. macro to save cells to another sheet (0 replies)
  133. [SOLVED:] Populate multiple textboxes (0 replies)
  134. VBA R1C1 help on vlook up (2 replies)
  135. [SOLVED:] Removing extension (.xlsm) when converting to PDF (4 replies)
  136. Using a loop to run through Adding Freeform Nodes (1 replies)
  137. Database Style (3 replies)
  138. Copy and paste images from excel to word with VBA (1 replies)
  139. VBA: Copy and paste row data in multiple column if Sheet1 ID matches with SheetY ID (10 replies)
  140. [SOLVED:] How to count, sum and subtotal values in a filtered listbox? (3 replies)
  141. VBA TextBox Upon Opening, Adding Userform, Not Prompted After Initial Save (11 replies)
  142. How are these things done inside VBA Excel? (2 replies)
  143. Open specific folder based on cell value or create folder (14 replies)
  144. Extract Data from PDF to Excel in a format (2 replies)
  145. VBA Change FileName with Numbers sequentially (1 replies)
  146. Populating listbox with selected columns (19 replies)
  147. [SOLVED:] Duplicate Entries in Excel (7 replies)
  148. VBA to execute filter for future date ranges (6 replies)
  149. VBA for highlight & extract cells addresss where harcode mannual entry (8 replies)
  150. 'Send e-mail' bolt-on to existing VBA code (2 replies)
  151. [SOLVED:] EXCEL VBA - Open the Specific file and copy the Data by Vlookup and Offset (1 replies)
  152. Horizontal cell data to Vertical cell data excel formula (5 replies)
  153. VBA Countif help Passing Criteria through Array (1 replies)
  154. [SOLVED:] UserForm Label Text Direction (3 replies)
  155. Vba to execute what was done with conditional formatting (8 replies)
  156. [SLEEPER:] Userform Textbox Number format (13 replies)
  157. [SOLVED:] Different granularity for dashboard (28 replies)
  158. [SOLVED:] combine macros and have access from my personal workbook (12 replies)
  159. Filtiring Dates in Listview (3 replies)
  160. [SOLVED:] RANGE OF CELLS TO IMAGES (1 replies)
  161. Copy and paste filtered rows (1 replies)
  162. String Manipulation to Sentence. (1 replies)
  163. [SOLVED:] Create copy button on userform that autofills information already entered on userform (9 replies)
  164. questions about ranges and refedit. (4 replies)
  165. VBA Pivot Grouping help (4 replies)
  166. Mismatch data - Dates issue for certain range (7 replies)
  167. [SOLVED:] Write array to row (not column) (7 replies)
  168. [SOLVED:] Transfering Values From Textbox to Textbox (14 replies)
  169. [SOLVED:] Formula to look for a cell phrase and add a cost (3 replies)
  170. SQL on Excel Table (5 replies)
  171. vba using on android (2 replies)
  172. Problems with Object Variable or With block variable not set (9 replies)
  173. Next without For error (39 replies)
  174. copy cell value from one sheet to another sheet (1 replies)
  175. [SOLVED:] How to get name of Option Button created dynamically (7 replies)
  176. Update Sheet2 based on date/time values in sheet1 (1 replies)
  177. Reference large spreadsheets without opening them (1 replies)
  178. Copy and paste a row in a new worksheet VBA (4 replies)
  179. Vlookup Choose for 3 table after criteria macth (5 replies)
  180. add a new event to an event change macro (7 replies)
  181. Create Bookmarks from cell names when saving as pdf (2 replies)
  182. Runtime Error (2 replies)
  183. Clear cell data that does not contain specific value (11 replies)
  184. Open latest, partial named file in folder. (4 replies)
  185. [SOLVED:] Save as pdf's (15 replies)
  186. How do you write to worksheet in Excel 2007 (4 replies)
  187. [SOLVED:] AdvanceFilter- Multiple Criteria in one Cell (7 replies)
  188. VBA - Find and find next and sum their value help. (3 replies)
  189. Update Shopping list Fills by looking up on another workbook Using VBA (2 replies)
  190. Prevent to modify file extension (3 replies)
  191. [SOLVED:] Hide and unhide columns according to number of days in my calendar (5 replies)
  192. [SOLVED:] VBA update and clear the value without delay (9 replies)
  193. [SOLVED:] ADODB not getting all the data from one field (18 replies)
  194. VBA Browse multiple workbooks how to short the code.... (3 replies)
  195. Pass parameter into SQL statement in Power Query (1 replies)
  196. Duplicate the sheet and updte the Master (2 replies)
  197. Copy Sheet to New WB but Macros still point to sheet in WB (1 replies)
  198. Paste contents into cell that has color (7 replies)
  199. [SOLVED:] How to unhide Sheets based on 3 cell values (5 replies)
  200. How to have excel add any new data in a pivot automatically (1 replies)
  201. Extract author and date from web page (3 replies)
  202. VBA open another Workbook copy and paste if condition is met (0 replies)
  203. [SOLVED:] Check if Plink.exe is active (1 replies)
  204. [SOLVED:] Shell( .exe with input files) (9 replies)
  205. logic operator bug, I've never had anything like this (2 replies)
  206. Sleeper: file with macro button to import and split the data in to multiple work bo (0 replies)
  207. Copy/Transpose/Paste Vertically Breaking on Blanks Macro (2 replies)
  208. [SOLVED:] crieria item in list to replace in another column (3 replies)
  209. Make Directory and File If doesn't exist? (4 replies)
  210. How to extract all data with same name (0 replies)
  211. If condition for stop printing sheet (1 replies)
  212. Lookup closest value azimuth (0-360°) value in specific range and return over 360° (0 replies)
  213. [SOLVED:] VBA coding help (7 replies)
  214. VBA - How to Cycle through Workbooks to Paste Columns To a Matching Worksheet (2 replies)
  215. % variation between two cells (0 replies)
  216. Change cell color based on other cell value (0 replies)
  217. VBA CODE for Subtract two cells (3 replies)
  218. Need to be able to move things in order based on sequence of events. (4 replies)
  219. Best VBA process for extracting data (2 replies)
  220. Refer to cells instead of hardcoding text and numbers (1 replies)
  221. [SLEEPER:] How to fixed box text in the excel? (1 replies)
  222. Copy all of the sheets in an array to a new workbook (5 replies)
  223. Complex Netting of Amount Against An Array (0 replies)
  224. [SOLVED:] Update Calendar Fills by Revolving Sequence Using VBA (21 replies)
  225. Popup to display warning message (7 replies)
  226. [SOLVED:] open worksheet from different worksheet cell (3 replies)
  227. Please help (7 replies)
  228. Extract unique text from cell - excel formula (11 replies)
  229. Copy from another program and past to Excel sheet (0 replies)
  230. [SOLVED:] VBA command button to auto generate outlook email (3 replies)
  231. VBA - Set background color (and text) according to column in another dataset (0 replies)
  232. Change the copy order in this VBA code (5 replies)
  233. Vba process entire row delete (11 replies)
  234. Opening XLSM file with Excel 2007 does not display content (13 replies)
  235. Debugging Offset within a Range? (5 replies)
  236. Searchable Drop-Down List Stops Working when Sheet Protected (0 replies)
  237. How can I paste specific rows and replace specific rows (10 replies)
  238. [SOLVED:] Change Value on Multiple Pivot Tables at Once (10 replies)
  239. Best way to handle duplicate records.... (2 replies)
  240. [SOLVED:] Select Current Row when a Condition is True in a For Each Loop (9 replies)
  241. [SLEEPER:] The number of users in the shared workbook (0 replies)
  242. [SOLVED:] Updating Win/Loss records with VBA Button (2 replies)
  243. [SOLVED:] Issue with VLOOKUP.....Working on 1 Cell but not the other cell.... (3 replies)
  244. [SOLVED:] Look up function vba? (10 replies)
  245. Select record and update (0 replies)
  246. After page break bottom border for all pages (0 replies)
  247. [SOLVED:] Move file by vba (3 replies)
  248. [SOLVED:] Arranging data that is in columns in a different dynamic way (31 replies)
  249. VBA Help (33 replies)
  250. Combobox's (39 replies)