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. [SOLVED:] Function to get list of Excel files in a folder (4 replies)
  2. [SOLVED:] help for homework (2 replies)
  3. [SOLVED:] Optimizing Copying Sheets & Printing (4 replies)
  4. Still Stuck On A loop (24 replies)
  5. Exporting an multidimensional array from an Ecxel file to a new Excel file (.xls) (1 replies)
  6. VBA: How to use listbox properly. (1 replies)
  7. [SOLVED:] Spell Check in Excel-Auto Select First Recommendation Using VBA (5 replies)
  8. [SOLVED:] Help with macro to set vertical alignment in Excel without affecting text indents (2 replies)
  9. Auto click OK button (1 replies)
  10. Excel report generation and export to pdf (1 replies)
  11. Minsweeper VBA code Problem (7 replies)
  12. [SOLVED:] Data Validation (3 replies)
  13. Export Crystal Report to pdf (0 replies)
  14. Moving different rows data to one row based on criteria to optimise on printing (22 replies)
  15. [SOLVED:] Message bar detection. (9 replies)
  16. [SOLVED:] Vba code to copy and paste dynamic range from mulitple workbooks to one workbook (8 replies)
  17. Skip heading rows with Range Offset (2 replies)
  18. Sleeper: How do I break a link after saving to new workbook (7 replies)
  19. How do I move files into latest created subfolder (3 replies)
  20. [SOLVED:] Need help with Macro VBA code in Excel (2 replies)
  21. VBA for binking Text inside a Shape in Excel (1 replies)
  22. Filter Pivot table by each customer and auto email invoices unpaid (1 replies)
  23. Using Marlett for optional selections - multiple ranges (2 replies)
  24. [SOLVED:] Date filter in table (2 replies)
  25. Locking Cell Format (1 replies)
  26. [SOLVED:] How to modify this code to place the checkbox in the first cell of each column? (9 replies)
  27. [SOLVED:] Save workbooksheet as .CSV with some variables (2 replies)
  28. [SOLVED:] Copy/paste values in column if condition is met (2 replies)
  29. Isolating errors 2 (9 replies)
  30. Hi , how to select sheets (17 replies)
  31. [SOLVED:] Database or object is read-only (1 replies)
  32. Adjust macro (problem) (1 replies)
  33. [SOLVED:] Cell selection issue (6 replies)
  34. Get data from two worksheets using form (0 replies)
  35. [SOLVED:] NEED A LOOP TO COPY DATA (3 replies)
  36. Can I “include” another file or module in a sub or function? (9 replies)
  37. How to correct this error (7 replies)
  38. Excel to Pdfs Not saving correctly (6 replies)
  39. [SOLVED:] Renaming inserted Object (2 replies)
  40. Numbering a unique sort (2 replies)
  41. [SOLVED:] Even Vectors - Panel Data (9 replies)
  42. VBA code to generate report based on criteria (4 replies)
  43. ActiveX Combo Box and Pivot Table using Visual Basic Issue (4 replies)
  44. [SOLVED:] De-selecting cells after Paste (8 replies)
  45. move files from one folder to another whose file names are listed in an excel file (2 replies)
  46. [SOLVED:] Find and Replace based on Selection only (3 replies)
  47. Modification of VBA code (1 replies)
  48. VBA to relocate XML blocks (7 replies)
  49. Create Summary sheet from multiple tabs & run macro on certain tabs (1 replies)
  50. ICOLOR TAB (0 replies)
  51. [SOLVED:] VBA to dynamically select EACH block/range of cells on a worksheet, then copy/paste? (14 replies)
  52. Help with VBA code in data entry form (3 replies)
  53. Subtotal at each PageBreak (2 replies)
  54. How to copy an entire row from 1 sheet to another (2 replies)
  55. VBA code to determine if a specific excel-based tool is used as add-in and locked? (5 replies)
  56. Excel Table of Contents/Summary Help (3 replies)
  57. [SOLVED:] Coding Efficiency (2) (3 replies)
  58. [SOLVED:] VBA User Form To Select Column To Copy Cells Into If Destination Is Blank (2 replies)
  59. Work hours between 2 dates(not working -VBA) (22 replies)
  60. [SOLVED:] Highlight duplicate data blocks (4 replies)
  61. [SOLVED:] Highlight the first row in every data block (4 replies)
  62. [SOLVED:] Print Userform (5 replies)
  63. VBA - Want to load Red colored text from a cell into an array (16 replies)
  64. Copy data from another worksheet if it doesn't exist in current worksheet (6 replies)
  65. [SOLVED:] Subscript out of range problem (14 replies)
  66. [SOLVED:] Extract matching data values and copy to new location (2 replies)
  67. [SOLVED:] Autofill Destination Offset (0 replies)
  68. [SOLVED:] Need Help With Show/Hide Check Boxes (2 replies)
  69. [SOLVED:] VBA copy and paste Vlookup (7 replies)
  70. Method 'SaveAs' of object '_Workbook' failed (2 replies)
  71. VBA code for determing if worksheets (OR) cells within a worksheets are protected? (4 replies)
  72. select item with macro (1 replies)
  73. Transpose Data Blocks To the Right (5 replies)
  74. [SOLVED:] Workbook open from specific folder (7 replies)
  75. [SOLVED:] Function in VBA (Excel) - Want a dynamic behavior depending on parameter (3 replies)
  76. [SOLVED:] Excel and splwow64.exe issues (9 replies)
  77. Creating and Save new workbook based on cell value (0 replies)
  78. [SOLVED:] Range changes values unexpectedly as code executes (2 replies)
  79. copy and paste into next blank cell of table (7 replies)
  80. Help creating a file joining different other files (10 replies)
  81. [SOLVED:] Need Help in making minor modification to an excel vba code. (6 replies)
  82. [SOLVED:] find/retrieve price from closed WB and copy to current workbook (4 replies)
  83. [SOLVED:] Generate multiple TXTs files (6 replies)
  84. "orientaion" parameter in vba SORT (9 replies)
  85. [SOLVED:] Display MsgBox "Macro is running" when macro is running (2 replies)
  86. [SOLVED:] Shared excel userform (1 replies)
  87. Alternative for sendkey (0 replies)
  88. Sleeper: Matching Algorithm - Gale Shapley, Almost complete - Excel Matching (2 replies)
  89. [SOLVED:] DATE DIFF function in years (6 replies)
  90. How to analyze big data with Excel (59 replies)
  91. [SOLVED:] Format decimal places based on columns from same row (8 replies)
  92. Could I have done this quicker? (9 replies)
  93. Unmerge VBA with dates (2 replies)
  94. Optimize macro performance (10 replies)
  95. Calculate Percent Error (4 replies)
  96. [SOLVED:] Format Cells based on start & end date! (2 replies)
  97. Need Help - Find Variable Text from Cell B in Cell A, then Bold/Color. (2 replies)
  98. Efficient coding with Loop (2 replies)
  99. Need help with VBA code for entering cell value based on another cell value (3 replies)
  100. VBA to merge specific sheet of different workbooks into one multisheet master file (8 replies)
  101. Need Help With Automating Data Validation Selection (0 replies)
  102. [SOLVED:] Importing data from a MySQL database (1 replies)
  103. How can I chart the moon data against the tide data (12 replies)
  104. Place formulae on each row where dates meet criteria (13 replies)
  105. restore workbook after Application.Visible = False (9 replies)
  106. Need help combining multiple sheets into a single summary page (1 replies)
  107. [SOLVED:] Qucik help (2 replies)
  108. [SLEEPER:] Code retrives https:// in Windows Explorer instead of windows explorer drive (3 replies)
  109. [SOLVED:] Run-Time error when saving (4 replies)
  110. This code takes 5 seconds to run. Any suggestions on how to get that down to 3? (4 replies)
  111. Combine Excel sheets w/ same name into one (0 replies)
  112. [SOLVED:] Needs Help With For Next Loop (7 replies)
  113. Run Regression on Filtered Data Set (3 replies)
  114. [SOLVED:] Switch between Putty and Xshell using same Loginbutton (10 replies)
  115. [SOLVED:] How to create a list out of wide table (5 replies)
  116. FSO Object used in VBA code? (3 replies)
  117. [SOLVED:] Select Sheets Array If (7 replies)
  118. [SOLVED:] Need Help With Input Box To Open File in Specified Path (26 replies)
  119. Avoiding the DocumentsPane to show up on startup (4 replies)
  120. [SOLVED:] Need advice with manuals and instructions (2 replies)
  121. VBA Lock rows upon checkbox click on multi-sheets (15 replies)
  122. [SOLVED:] VBA Page Break Issue (2 replies)
  123. [SOLVED:] Highlight Duplicates (3 replies)
  124. VBA code to copy data from one sheet and paste it in a specific location (5 replies)
  125. Insert a picture in an multiple image control with one click based on dropdown list (1 replies)
  126. Copy rows from Outlook to Excel (0 replies)
  127. [SOLVED:] how to remove saturday and sunday when calculating start dates (13 replies)
  128. Problems writing data to worksheet (14 replies)
  129. Helped Needed: Linear/nonlinear Optimization with Solver (2 replies)
  130. Need help for copy columns to new sheet with new order and two or more criteria (2 replies)
  131. Excel Macro to copy data from a specified multiple ranges of a workbook to another wb (3 replies)
  132. Pivot Table Filter Button - VBA HELP (0 replies)
  133. Needs help with VBA for 2 specifics detailed functions (5 replies)
  134. [SOLVED:] Needs Help With Calling All Tabs (5 replies)
  135. Excel picture object chart paste in specific ppt as per slide name/number through VBA (4 replies)
  136. Checking for multiple conditions (9 replies)
  137. [SOLVED:] STRUGGLING VLOOKUP in VBA (2 replies)
  138. Need he;p with code error, .SaveAs (1 replies)
  139. [SOLVED:] Needs Help With Conditional Renaming for Several Tabs (8 replies)
  140. Help needed: Vlookup formula with a dynamic range (5 replies)
  141. Macro to delete line in excel after third / sign. (2 replies)
  142. [SOLVED:] Excel 4 Macro Page.Setup Error (1 replies)
  143. [SOLVED:] Stuck with defining range for calculation (2 replies)
  144. Frightened to tunnel! (1 replies)
  145. Studying VBA for Excel and getting frustrated by objects/properties... (2 replies)
  146. Save Document's most recent version (3 replies)
  147. [SOLVED:] Multiple buttons using a single macro (4 replies)
  148. [SOLVED:] How to copy sheets from workbook to new open workbook and rename new workbook accordi (4 replies)
  149. convert date/number (19 replies)
  150. Conbining IF Then Conditions in Excel (7 replies)
  151. If Elseif to toggle (8 replies)
  152. macro to select different sheet tabs (2 replies)
  153. [SOLVED:] stripChar is not working (2 replies)
  154. VBA: Am i doing something wrong with While...wend? (8 replies)
  155. [SOLVED:] Find and Replace macro is not working (2 replies)
  156. size of photo based on the height of row and make center based on the column width (7 replies)
  157. Sum/ABS (4 replies)
  158. VBA Macro button to open a folder derived from the (partial) name in a selected cell (3 replies)
  159. [SOLVED:] Code runs when VBA Editor is open, but doesn't work when closed (3 replies)
  160. Unpivot data? (8 replies)
  161. Generate workbook (10 replies)
  162. [SOLVED:] Conditional Formatting (2 replies)
  163. Calculation incomplete message issues (1 replies)
  164. [SOLVED:] change word spacing in a messagbox (7 replies)
  165. [SOLVED:] Subscript out of range (4 replies)
  166. [SOLVED:] PROCESSING External Excel Files (5 replies)
  167. VBA: Counting an "if" loop to get average. (3 replies)
  168. If cells starts with a number and exceeds a certain number of characters (8 replies)
  169. [SOLVED:] VBA save as function as new workbook (5 replies)
  170. Copy & Paste (1 replies)
  171. [SOLVED:] Combine strings and place in separate sheet (4 replies)
  172. Need a macro for copy pasting with transpose (0 replies)
  173. Compare two sheets and exclude existing in the second sheet (2 replies)
  174. vba find text paste text in message box next cell (14 replies)
  175. Retrieve price from another wb instead of different sheet? code complete except exter (5 replies)
  176. Activate this popup html (2 replies)
  177. identifying duplicates on each row (4 replies)
  178. Update Cost on a smaller spreadsheet from costs on a larger spreadsheet. (2 replies)
  179. [SOLVED:] sort and extract text to another excel file (1 replies)
  180. Sleeper: Found connection problem when run VBA to direct connect Oracle Database (4 replies)
  181. assign a cell value to a variable vba loop (3 replies)
  182. VBA to delete first 3 characters and keep cell formatting (2 replies)
  183. Update chart when adding new sheets of data (5 replies)
  184. Special chars to UTF-8 (3 replies)
  185. [SOLVED:] Function to list pdf files within a folder (2 replies)
  186. Extract week start and weekend day exclude holidays & weekday excel formula (3 replies)
  187. [SOLVED:] Please help to modify my code (1 replies)
  188. How to create a GeoJSON editor with VBA (3 replies)
  189. Help -- updating listbox and worksheet data (2 replies)
  190. [SOLVED:] userform input box to print a page (4 replies)
  191. number not found ... error proofing vba macro (3 replies)
  192. [SOLVED:] MessageBox line length (4 replies)
  193. vba accessing file on server?? (3 replies)
  194. Filtering a Range into another Range (2 replies)
  195. Create UserForm with Vlookup (combobox and textbox) (11 replies)
  196. [SOLVED:] Excel VBA Automation Error (and Crash) when running macro twice (1 replies)
  197. [SOLVED:] Code to know when values in column changes (4 replies)
  198. [SOLVED:] Populating text boxes (4 replies)
  199. Help!! (6 replies)
  200. Deleting Comment Indicators for Comments in Selected Range (4 replies)
  201. Formula To Replace Suffixes (3 replies)
  202. Populate Listbox with Combobox (1 replies)
  203. Summing up values between 2 criteria in rows (8 replies)
  204. [SOLVED:] VBA to Create Data rows for Multi-Valued Columns (6 replies)
  205. Compare the last two months and remove the color in the first Number (1 replies)
  206. Problem with like (5 replies)
  207. Excel VBA MySQL (0 replies)
  208. Select CSV file and Import - UTF-8 (4 replies)
  209. Select a cell with target.row (3 replies)
  210. find and retrieve a price from a different sheet index match - vlookup? (3 replies)
  211. [SOLVED:] coping conditional format and moving the compare cell with it (5 replies)
  212. remove line (2 replies)
  213. [SOLVED:] How to use previous row's Beginning Balance in calculation (2 replies)
  214. [SOLVED:] VBA Biweekly payments and monthly interest payments (4 replies)
  215. [SOLVED:] Save specific sheets as separate workbooks (4 replies)
  216. Delete button added to new row and delete row/move sheet. (0 replies)
  217. Unique Concatenate Values (0 replies)
  218. Object not defined while trying to clear contents of row (1 replies)
  219. [SOLVED:] Array problems ... need help (7 replies)
  220. Excel Macro To Combine Multiple Sheets in one only (13 replies)
  221. Bringing together 2 sets of data (1 replies)
  222. Compare two date column in different sheets, return adjacent value in matched dates (2 replies)
  223. vba excel auto filter total (7 replies)
  224. PROTECT SHEET NAME (8 replies)
  225. Search textbox and create chart in userform (5 replies)
  226. Sorting Data Using Double Click on Header but multiple range (24 replies)
  227. Application.Run? (1 replies)
  228. [SOLVED:] macro to edit part of a cell contents (8 replies)
  229. [SOLVED:] Setting date picker to certain columns only (2 replies)
  230. [SOLVED:] Userform unload issue (1 replies)
  231. VBA codeperforming two functions, check column then count all columns & create tables (6 replies)
  232. Advance Filter : Not showing Particular Filtered Items. (1 replies)
  233. VBA Coding Related to Data Entry Form (1 replies)
  234. [SOLVED:] Application.Caller error for AutoShapeType 152 (4 replies)
  235. Printing excel sheet to pdf (20 replies)
  236. [SOLVED:] How to change non-tabular data into tabular data with VBA (16 replies)
  237. Same details load on multiple orders (2 replies)
  238. [SOLVED:] How to add a single letter to the end of an growing number (3 replies)
  239. Excel Questions on using "Switch" formula (1 replies)
  240. using VBA sendkeys with vmware horizon client (2 replies)
  241. [SOLVED:] Combine rows of data in to one cell (6 replies)
  242. CALLING MACROS FROM SINGLE USERFORM (3 replies)
  243. [SOLVED:] Split Function - Allow for variances (2 replies)
  244. [SOLVED:] Define Worksheet As Public Variable (4 replies)
  245. A VBA Code which sort values, remove duplicate and vlookup (1 replies)
  246. [SOLVED:] Copy Down Formulae Row (range of cells) Down to Last Row. (26 replies)
  247. Cannot pass object to sub-procedure located in worksheet? (2 replies)
  248. VBA for Date Expiry does not close WorkBook (1 replies)
  249. Single Column Arrays or Vectors (3 replies)
  250. [SOLVED:] join models (14 replies)