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. Yearly Calendar Project (4 replies)
  2. Search with Table (0 replies)
  3. autofit cell height for merged cells (3 replies)
  4. Debug stops running macro and will only continue in step mode (3 replies)
  5. Importing pictures by directory string (1 replies)
  6. Set Range Using a Function (1 replies)
  7. [SOLVED:] Hyperlinks with changing Sheet Names (0 replies)
  8. VBA: Filtering for a date range from 2 ComboBoxes for dates (3 replies)
  9. [SOLVED:] Produce parts list from breakdown (5 replies)
  10. Flags on birthday calendar (11 replies)
  11. User defined directory not working (1 replies)
  12. Code that detects data in cells and pastes data into the next cells (3 replies)
  13. [SOLVED:] Excel Macro help - If target cell in range of cells. (1 replies)
  14. Runtime Error 438 (3 replies)
  15. Skip blank from Auto Filter (2 replies)
  16. Making 2 Dependent drop downs (1 replies)
  17. VBA pivot table error 5 (7 replies)
  18. adjusted code show the data in listbox on userform (6 replies)
  19. [SOLVED:] Button click to change shape color (10 replies)
  20. Active X Textbox Content to Userform Textbox (2 replies)
  21. Update Shared Spreadsheets (0 replies)
  22. Macro to clear hidden contents based off other cell values (4 replies)
  23. Rename New Sheet? (11 replies)
  24. VBA Code to edit and update existing data (11 replies)
  25. Application.Match gives 'Type Mismatch' only on descending date values, match type=-1 (3 replies)
  26. VBA to Recalculate Grand Total (2 replies)
  27. Transform data type in column (1 replies)
  28. Excel vba merge cells based on duplicate cell data (5 replies)
  29. Formulas NameManager (0 replies)
  30. Excel help copy and paste from sheets then move to next row (1 replies)
  31. Input user form to change cell value (1 replies)
  32. [SOLVED:] 2 separate change events code issue (Floating Cmd Button & List box selection) (7 replies)
  33. Crank Nicholson Method (2 replies)
  34. Crank Nicholson (2 replies)
  35. [SOLVED:] VBA Code to stop loop if cell / range is blank (2 replies)
  36. [SOLVED:] Printout VBA (3 replies)
  37. Creation of File list in a new Workbook (4 replies)
  38. [SOLVED:] Format transfer to sheet 2 after match in sheet1 (5 replies)
  39. Userform - Compile Error: Invalid qualifier (2 replies)
  40. [SOLVED:] VLOOKUP Not Updating when Data Repeated (8 replies)
  41. Filepath to reference cell value (4 replies)
  42. [SOLVED:] Create a File list with metadata (9 replies)
  43. Two userforms in one sheet (11 replies)
  44. My chart "hides" from view sometimes after running or when idle. (0 replies)
  45. How can I control when and if my chart updates and not updates? (15 replies)
  46. [SOLVED:] Use .Range("A1:A10000") to end of records? (11 replies)
  47. VLOOKUP not working properly (5 replies)
  48. Findvalue from 2 searchstrings (3 replies)
  49. Excel to JSON -- bracketing (5 replies)
  50. [SOLVED:] Excel VBA code to Delete 'Heading 1' from Word Document (2 replies)
  51. Array issues - one vs two dimensional (1 replies)
  52. [SOLVED:] VBA Code to Run Code Across Multiple Worksheets at One Time (11 replies)
  53. Print to PDF file (6 replies)
  54. [SOLVED:] VBA to replace previous table and check if one cells value is equal to the previous o (6 replies)
  55. Why is my code showing error?? (5 replies)
  56. Word file - filled using excel and send by email as attachment (1 replies)
  57. Loop through a folder and copy data from files to another WB (6 replies)
  58. User Form - Many Text Boxes - Restrict One Text Box with Password for Editing (1 replies)
  59. Export as CSV file (0 replies)
  60. [SOLVED:] Declaring Variable Type - Excel 2013 (4 replies)
  61. VBA how to superscript characters in a string following an apostrophe? (12 replies)
  62. Search data using Userform and then scroll through matching records (9 replies)
  63. [SOLVED:] Help import from csv file (21 replies)
  64. Copy data from one sheet to another sheet where the values are matching (2 replies)
  65. VBA filter and cell formatting (0 replies)
  66. On editing protected view programmatically , display setting are getting changed . (2 replies)
  67. [SOLVED:] Multiple selections from drop down list (6 replies)
  68. [SOLVED:] BeforeSave and Userform: Issues with saving the excel file (12 replies)
  69. VBA Advanced filter help..... Criteria excluding a list (7 replies)
  70. [SOLVED:] Need help with logic (7 replies)
  71. [SOLVED:] VBA Code to add groupings to subtotals (10 replies)
  72. [SOLVED:] Copy .pdf files from one location to a new folder based on a list of cell (4 replies)
  73. Run-time error 438: Object doesn't support this property or method (6 replies)
  74. Error Handling for InputBoxes (1 replies)
  75. VBA code not working in 365 (5 replies)
  76. [SOLVED:] Userform open from one worksheet and referencing another worksheet (2 replies)
  77. [SOLVED:] VBA Code to remove Data embedded in the "Pick From Drop Down List" (9 replies)
  78. [SOLVED:] VBA code for selecting data from statement to output sheet (10 replies)
  79. [SOLVED:] Copy and paste VBA (4 replies)
  80. VBA problem (5 replies)
  81. Copy Multiple Files from Absolute Paths to SharePoint with Same File Names (1 replies)
  82. Updating a Chart while VBA is running (0 replies)
  83. [SOLVED:] How to get the first & last range value for this type of data...? (1 replies)
  84. Control Tip Text (9 replies)
  85. application.run - return value byRef (5 replies)
  86. [SOLVED:] Copy / Paste data ranges to specific locations (7 replies)
  87. Number help (2 replies)
  88. VBA scrip to sort data inside sheet (4 replies)
  89. Count colored cells in a range using columns and rows, output result (2 replies)
  90. Cell content as part of filename (5 replies)
  91. Matching data from columns with offset multiple row data in other worksheet (3 replies)
  92. Extract Items from String and then Sort (5 replies)
  93. Modify macro to output to Combobox (3 replies)
  94. Caption label (1 replies)
  95. Excel Sumproduct Count Blank Cell as well... (4 replies)
  96. Multiple dropdown list (7 replies)
  97. [SOLVED:] Problem with hiding rows (2 replies)
  98. [SOLVED:] SAVING RANGE AS PDF FOR MULTIPLE FILES (1 replies)
  99. [SOLVED:] How to Selection.Insert Shift:=xlDown with keep destination formatting? (7 replies)
  100. [SOLVED:] VBA code to set print preferences (11 replies)
  101. [SOLVED:] [R1C1] Formula with a loop index in VBA (7 replies)
  102. Reconciliation based on recurring values (3 replies)
  103. Get name of procedure (9 replies)
  104. Select Random cells from range (2 replies)
  105. PLEASE HELP ME!!! (10 replies)
  106. [SOLVED:] Refer to range in cell formula (3 replies)
  107. counting number of occurrence of a value and depositing that number in another column (18 replies)
  108. Userform with listbox and checkboxes that finds values on a worksheet (1 replies)
  109. [SOLVED:] Match FileNames and then Merge those PDFs (26 replies)
  110. [SOLVED:] How to fetch data from a excel table with multiple rows. (11 replies)
  111. pick a new interior color from an array when next color is needed (6 replies)
  112. Multiple Rowsource in combo box? (7 replies)
  113. Help with random selection and variable criteria (0 replies)
  114. easy VBA seek for help! (5 replies)
  115. [SOLVED:] Pass Params on Activate event (6 replies)
  116. Array only returning first column of values (26 replies)
  117. [SOLVED:] Fill Column (11 replies)
  118. Macro for sorting by lot number, splitting table w/new header, then sort by due date (2 replies)
  119. [SOLVED:] Linking a commandbar button to a macro in an addin (3 replies)
  120. [SOLVED:] Data Conversion using Dynamic Multi-Dimensional Array (12 replies)
  121. vba - Extract Unique values from Single Column via Colllection and Dictionary (9 replies)
  122. Get first and last dates (dd/mm/jj) from year range (4 replies)
  123. VBA code: copy data from sheet and paste values onto another specidied workbook (8 replies)
  124. [SOLVED:] Changing Column Headers (15 replies)
  125. [SLEEPER:] Bad file name or number - Runtime Error 52 (5 replies)
  126. [SOLVED:] Copy Data from worksheet to another one with VBA (6 replies)
  127. copy and change date (4 replies)
  128. [SOLVED:] Cannot show merged cells (18 replies)
  129. VBA to perform lookup for individual lookup range (8 replies)
  130. Count only visible data after filtering (16 replies)
  131. Running macro on files in a folder: impossibly hard! (8 replies)
  132. [SOLVED:] Sum values vba code (10 replies)
  133. Inserting Recordeset into Access DB via VBE - Error operation must be an updatable... (1 replies)
  134. Search string if it contains words from a range then replace with adjacent cell (10 replies)
  135. Prepare hierarchical and non-numeric pivot tables in Excel (6 replies)
  136. How to remove [TAG 001], [TAG 002], [TAG 003], etc from string (12 replies)
  137. Delete certain rows and highlight certain cells (7 replies)
  138. Splitting up a String (17 replies)
  139. [SOLVED:] Copy value - Another Excel (1 replies)
  140. [SOLVED:] Clear all textboxes except 1 (3 replies)
  141. [SOLVED:] Between two numbers (6 replies)
  142. [SOLVED:] Interactive Way to Search Based on First Few Characters Typed (4 replies)
  143. Excel 2016 Open Read Only file (9 replies)
  144. [SOLVED:] Copy and rename multiple sheets (6 replies)
  145. Declared public variables have ceased to pick up values (9 replies)
  146. Apply AutoFilter based on selected cell in another sheet (2 replies)
  147. Is there any event allowing Cancel of closing a Window (not closing a Workbook)? (2 replies)
  148. [SOLVED:] When you have one workbook, two windows, does any event happen closing second window? (2 replies)
  149. Range.Find Issues (2 replies)
  150. [SOLVED:] How to Copy Paste Symbols-Phonetics Data to Excel sheet? (5 replies)
  151. [SOLVED:] Turning off alerts issue (2 replies)
  152. [SOLVED:] Combine common worksheet names when splitting a file (7 replies)
  153. [SOLVED:] Combo Box Index select (12 replies)
  154. VBA Array Help in filtering data with logic (1 replies)
  155. [SOLVED:] VBA- Variable declaration help (14 replies)
  156. newbie vba questions & help with posible loop for multiple cell values to sheet (3 replies)
  157. Insert a line break after word wrap (17 replies)
  158. Replacing multiple numerical values (7 replies)
  159. Subscript out of range error in VBA code (4 replies)
  160. simple copy-past (4 replies)
  161. [SOLVED:] Run-time error '424': Object Required (3 replies)
  162. [SOLVED:] Pull rows from array given two conditions (1 replies)
  163. MISSING DATA IN EXPORTING CALCULATED QUERYTable FROM ACCESS TO EXCEL USING EXCEL ADO (3 replies)
  164. Copying multiple text files into one excel but different tabs (3 replies)
  165. Date Picker VBA that will work on all versions of excel (2 replies)
  166. VBA - Collection help.. (9 replies)
  167. [SOLVED:] How to Add Different Texts to End of Excel Cells Macro (3 replies)
  168. combine multiple txt files (1 replies)
  169. Room Booking System (10 replies)
  170. [SOLVED:] VBA - Filling Master Template (3 replies)
  171. Formula/vba - Summary Report without Pivot (4 replies)
  172. Like expression with AND or OR (3 replies)
  173. [SOLVED:] Finding cells formatted with colour gradients of various colours (7 replies)
  174. Help VBA search (3 replies)
  175. Using non-contiguous ranges in Solver VBA (1 replies)
  176. Solver in Userform Linked in Excel (2 replies)
  177. Convert Binary to decimal on and vice versa on VBA (15 replies)
  178. auto fit cell height for merged cells in sheet that has protected (locked) cells (4 replies)
  179. Replacing Date with Period Based on Matrix (7 replies)
  180. Sleeper: AdvancedFilter - Unique Column 1, Greater than 0 Column 3 (3 replies)
  181. [SOLVED:] Transferring selected cells to a new sheet (13 replies)
  182. Publish to Sharepoint (5 replies)
  183. Search for a string in text files. (3 replies)
  184. [SOLVED:] Delete text line with specific word from multiline cell (12 replies)
  185. [SOLVED:] Part of a string (5 replies)
  186. EXPORTING DATA TO MS ACCESS FOR SIMULTANEOUS MULTI USER (1 replies)
  187. [SOLVED:] copy multiple rows of numbers to new location on same sheet. (24 replies)
  188. Check if labels are visible (3 replies)
  189. [SOLVED:] How to define range based on the value of another cell (2 replies)
  190. [SOLVED:] I want my reset button on VBA userform to do nothing if "no" is selected (4 replies)
  191. VBA to check if object is inside or outside of freeform area (6 replies)
  192. Help!! Merging multiple Excel workbooks into one master sheet. (5 replies)
  193. Advice on comparing excel workbooks (2 replies)
  194. Please help VBA Coding for Repeat Task for Step 2 to Step 6 (1 replies)
  195. [SOLVED:] question re "for each range in target" (4 replies)
  196. [SOLVED:] Highlight cells that contain specific words (8 replies)
  197. VBA code to copy to new workbook and insert pivot (4 replies)
  198. [SOLVED:] help adjusting code delete empty rows based on condition from sheet1 to sheet2 (9 replies)
  199. [SOLVED:] Add Roundup formula to VBA button (9 replies)
  200. UserForm to Return the MAX date in a TextBox resulting from VLOOKUP in ComboBox (26 replies)
  201. [SOLVED:] vba sum format number with currency (20 replies)
  202. Formulas no longer work in Excel for Office 365 (2 replies)
  203. [SOLVED:] Extract numbers starting with 07 (2 replies)
  204. Multi-use UForm - can it be improved upon? (4 replies)
  205. [SOLVED:] How to Log Changes on Sheets! (5 replies)
  206. vba copy paste (1 replies)
  207. VBA Macros to Copy Data to Another Workbook (10 replies)
  208. Copy data between sheets (18 replies)
  209. VBA Error 'Range of object worksheet failed (5 replies)
  210. [SOLVED:] Reformat a table (3 replies)
  211. [SOLVED:] Identify missing numbers in sequence (8 replies)
  212. [SOLVED:] Finding/Changing Default Printer (7 replies)
  213. Require VBA Code for filter Data after criteria match (5 replies)
  214. VBA Validation Fields and Date and Time Picker (0 replies)
  215. [SOLVED:] VBA from text to number (14 replies)
  216. Pull from Table1,Table2, Test Data, Then place in Table3 (1 replies)
  217. [SOLVED:] VBA Code not running if sheets are protected (11 replies)
  218. Customize ribbon 2013 excel (3 replies)
  219. vba advanced_Filter help (1 replies)
  220. help adjusting code combine two tables from two sheets to another sheet (10 replies)
  221. Keep userform open when opening or closing other workbooks (3 replies)
  222. Selecting (copying) specific rows up to the last column (6 replies)
  223. How to share an Excel file containing a macro on the network (4 replies)
  224. Input box to display as ****** (5 replies)
  225. VBA: Input cell data outout in three ways (3 replies)
  226. If cell is Empty! (2 replies)
  227. Pull data from one table to another (0 replies)
  228. VBA Search form (1 replies)
  229. [SOLVED:] Make Array with Full Paths to PDF Files in Parent and Subfolders (24 replies)
  230. small with condition (1 replies)
  231. [SOLVED:] User type not defined error trying to merge pdfs (0 replies)
  232. Update chart after cell gets updated (2 replies)
  233. [SOLVED:] VBA SPLIT into cells and reshape into table (11 replies)
  234. How Can I Build Chat with Vba? (0 replies)
  235. macro to save cells to another sheet (0 replies)
  236. [SOLVED:] Populate multiple textboxes (0 replies)
  237. VBA R1C1 help on vlook up (2 replies)
  238. [SOLVED:] Removing extension (.xlsm) when converting to PDF (4 replies)
  239. Using a loop to run through Adding Freeform Nodes (1 replies)
  240. Database Style (3 replies)
  241. Copy and paste images from excel to word with VBA (1 replies)
  242. VBA: Copy and paste row data in multiple column if Sheet1 ID matches with SheetY ID (10 replies)
  243. [SOLVED:] How to count, sum and subtotal values in a filtered listbox? (3 replies)
  244. VBA TextBox Upon Opening, Adding Userform, Not Prompted After Initial Save (11 replies)
  245. How are these things done inside VBA Excel? (2 replies)
  246. Open specific folder based on cell value or create folder (14 replies)
  247. Extract Data from PDF to Excel in a format (2 replies)
  248. VBA Change FileName with Numbers sequentially (1 replies)
  249. Populating listbox with selected columns (19 replies)
  250. [SOLVED:] Duplicate Entries in Excel (7 replies)