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. Move file to new folder based on cell value, create folder if not already exist (6 replies)
  2. [SOLVED:] excel macro help (3 replies)
  3. Change ActiveX Image Control from UserForm (5 replies)
  4. Formula to import and sort data from other sheet based on dates (1 replies)
  5. Getting max value from a dictionary (35 replies)
  6. [SOLVED:] Trying to return Table Column rather than Sheet Column from Find method (2 replies)
  7. VBA Dynamic array (1 replies)
  8. Help with find/replace loop. (2 replies)
  9. Sleeper: Make a more complex VLOOKUP formula (3 replies)
  10. Button Click (11 replies)
  11. Count Listview subitems based on condition (8 replies)
  12. [VBA] (Challange) Match dates between two workbooks and export data (2 replies)
  13. [SOLVED:] vba userform textbox Value from date picker (Monthview) (3 replies)
  14. [SOLVED:] Having trouble performing a few tasks in VBA, possibly need a loop? (3 replies)
  15. Custom Save Button (3 replies)
  16. LISTDATA MISSING FROM COMBOBOX PROPERTIES (1 replies)
  17. Check combos values and add if not already added (4 replies)
  18. VBA COPY PASTE DYNAMIC RANGE EXCEPT HEADERS (3 replies)
  19. [SOLVED:] VBA CODE TO INSERT CHECKMARK ON ANOTHER SHEET (2 replies)
  20. VBA: Create a List of Userforms and make check visible one's (6 replies)
  21. VBA error on clearing cells (7 replies)
  22. Fill Listview form 3 identical sheets (with same headers) (12 replies)
  23. Userform to filter ,add and edit data (0 replies)
  24. Pivot table data sorting in percentage problem (0 replies)
  25. Normalising Data in Excel with VBA (6 replies)
  26. [SOLVED:] need help on using results from formula to use in case macro (3 replies)
  27. [SOLVED:] Opening unknown File names in known Folder (2 replies)
  28. [SOLVED:] Save customrange to csv file (4 replies)
  29. Transponse each n rows + merge rows periodically (1 replies)
  30. Header/Footer Print settings optimization (0 replies)
  31. Index Match and Wildcard * (0 replies)
  32. [SOLVED:] Hide rows based on username (3 replies)
  33. Multiply VBA InputBox value by cell value derived from json API URL Web Query (2 replies)
  34. VBA Conditional Formatting (3 replies)
  35. How to get Percentage (0 replies)
  36. Macro to create detailed payment schedule using summary list of bank facilities (4 replies)
  37. Complicated VBA (1 replies)
  38. [SOLVED:] Listview specific rows conditional formatting (11 replies)
  39. VB Script (22 replies)
  40. [SOLVED:] Adding line numbers to VBE Code using MZ-Tools (5 replies)
  41. [SOLVED:] Setting Header/Footer issues (3 replies)
  42. Send a file to the dropbox with a macro (7 replies)
  43. VBA Code for numbers colors-for different format cell criteria (10 replies)
  44. Macro for a variable range sum if formula (11 replies)
  45. drag & drop merge with copy-paste-code (0 replies)
  46. execute netsh with "Run as administrator" in VBA (0 replies)
  47. copy and paste based on a value present in two sheets (0 replies)
  48. [SOLVED:] insert formula via loop including cell contents in a range (2 replies)
  49. 1004 error on delete picture on mouseover VBA (1 replies)
  50. [SOLVED:] input data from vba userform textbox to a spreadsheet cell depending on the time/date (20 replies)
  51. [SOLVED:] Visualize state of ADODB recordset in statusbar (3 replies)
  52. [SOLVED:] Display 3 donut charts based on combobox (2 replies)
  53. [SOLVED:] Excel Ribbon (3 replies)
  54. Splitting data by range (4 replies)
  55. [SOLVED:] Include 3 sheets only in filtering (6 replies)
  56. Application.FileSearch replacement (1 replies)
  57. [SOLVED:] Object variable or With block variable not set -Run-Time error 91 (3 replies)
  58. [SOLVED:] Multiple concerns with my Sheets (11 replies)
  59. [SOLVED:] If values equal zero command. (2 replies)
  60. [SOLVED:] Excel to Text File (3 replies)
  61. FORMULA TO COMBINE MULTIPLES CELLS (1 replies)
  62. [SOLVED:] SQLiteForExcel Help (1 replies)
  63. Size with Chart property of format picture in VBA (1 replies)
  64. [SOLVED:] Change ActiveCell within a selected range (1 replies)
  65. VBA to compare and update data on Master Sheet/workbook from another Sheet/workbook (2 replies)
  66. Insert symbol into text box - in the active textbox where the mouse cursor is located (3 replies)
  67. scraping vba dropdownlist (1 replies)
  68. Use of the WorksheetFunction INDEX and MATCH (3 replies)
  69. [SOLVED:] Transfer worksheet to another workbook (0 replies)
  70. Doevent and buttons (0 replies)
  71. XML substitution of values (2 replies)
  72. listbox population based on search value (7 replies)
  73. Deleting rows with specific text (10 replies)
  74. Check first five characters and replace offset (4 replies)
  75. vba add (2 replies)
  76. Create text files with file names from excel column (7 replies)
  77. Check game numbers (3 replies)
  78. vba new (2 replies)
  79. Text to Rows Macro : Subscript out of range (11 replies)
  80. Excel Won't recognise as date (mm/dd/yyyy) (3 replies)
  81. ASSIGN MULTIPLE VARIABLE FROM SINGLE VALUES IN ARRAY (7 replies)
  82. VBA in shared workbooks (1 replies)
  83. Excel.Action (0 replies)
  84. Pivot Table, Calculated Item - not working on large file (0 replies)
  85. EXCEL FORMULA NOT UPDATING CORRECTLY WHEN COPIED FROM ONE YEAR TO THE NEXT. (0 replies)
  86. Need help with my VBA Dictionary task (1 replies)
  87. VBA FOR INSERTING ROWS (3 replies)
  88. Enter a password for multiple protected work books (1 replies)
  89. HOW TO COMBINE 2 MACRO INTO 1 (0 replies)
  90. Sleeper: Images Gallery in UserForm (0 replies)
  91. VBA Nest If Statement help (1 replies)
  92. Append an order number in a text file with a string and then save (1 replies)
  93. VBA Help, Automatically entering passwords on multiple workbooks (3 replies)
  94. [SOLVED:] User Defined Function vba (4 replies)
  95. Run-time error ‘-2147467259 (80004005)’ (7 replies)
  96. [SOLVED:] VBA - Use variable from InputBox in formula? (4 replies)
  97. vba for next loop (4 replies)
  98. [SOLVED:] filtering with * as one of the multiple criteria (2 replies)
  99. Merge files in one folder to a master worksheet and update (5 replies)
  100. Extracting data from same cell in dierent workheets and files inside a folder or sub (0 replies)
  101. VBA code to click on Image button in IE (0 replies)
  102. Help with analysing consistencies in data set (4 replies)
  103. [SOLVED:] Doubleclick add row (3 replies)
  104. I want to automatically create pdf and send via outlook email to different addresses (0 replies)
  105. Get Active directory Username Details in Textbox2 based on Textbox1 Value (1 replies)
  106. Seeking help for creating a nested loop with condition (2 replies)
  107. [SOLVED:] VBA to resize cells with wrapped text (6 replies)
  108. [SOLVED:] Dynamic range help for conditional formatting rows (2 replies)
  109. Print reports from a drop-down list in Excel into one pdf (0 replies)
  110. COMBOBOX Change code not working properly (0 replies)
  111. [SOLVED:] Deleting Ovals - Logic: If they are above row 70 (2 replies)
  112. [SOLVED:] Is there a consistent way to get a sequential list of controls (5 replies)
  113. [SOLVED:] VBA Inputs restricted to specific decimal ending values (4 replies)
  114. VBA to copy a Specif sheet from multiple other workbooks in MAC (0 replies)
  115. [SOLVED:] Sum Cell range based on Worksheet title with wildcard. (3 replies)
  116. Problem: Compare two excel files and mark new text. (0 replies)
  117. [SOLVED:] Run-Time Error '1004" (3 replies)
  118. matrix rank (1 replies)
  119. Googletranslate() (0 replies)
  120. Run several Fast Fourier Transformations in a row (5 replies)
  121. [SOLVED:] VBA Message box to display column titles based upon totals (5 replies)
  122. [SOLVED:] Explanation VBA code [Activate+Loop] (2 replies)
  123. VBA Run-Time Error 13 - Mismatch??? (1 replies)
  124. VBA copy and paste with criteria and different sheets (0 replies)
  125. Insert Picture With Cell Reference In Excel VBA Dont Show In Other Computers (Help) (5 replies)
  126. [SOLVED:] Data Validation in a MessageBox - VBA (2 replies)
  127. [SOLVED:] Macro timing issue (1 replies)
  128. [SOLVED:] Problem with date comparisson (2 replies)
  129. [SOLVED:] Save Attachments from Current Open Outlook Email (1 replies)
  130. VBA button work 3 activity at one click? (26 replies)
  131. #NAME? Error with VBA (3 replies)
  132. [SOLVED:] How to assign a variable value in to another variable (2 replies)
  133. reference cell font color and value (1 replies)
  134. Macro to auto-copy a cell and paste it in a another cell at particular times (2 replies)
  135. [SOLVED:] Downloading images (3 replies)
  136. vba code analysing different workbooks (2 replies)
  137. How prevent open Excel file automatically when open connection to an Excel file (5 replies)
  138. Encryption Decoding VBA String (2 replies)
  139. [SOLVED:] VBA to group and identify (2 replies)
  140. [SOLVED:] Date Format (2 replies)
  141. matching words from transliteration and replacing using vba (6 replies)
  142. Reset Cell Value to Zero every day (after midnight) (3 replies)
  143. Formula instead of Pivot Table (1 replies)
  144. Copy Cell Values to Columns if Criteria is Matched in VBA (1 replies)
  145. [SOLVED:] Unable to Control Cursor at End of Script (2 replies)
  146. [SOLVED:] VBA Code to loop once (Do While) Replacing Array, Object Error (1 replies)
  147. Excel VBA conditional insert of page breaks (1 replies)
  148. VBA code that Unhide sheet that are hidden using (xlSheetHidden) (6 replies)
  149. Create Report based on criteria match (4 replies)
  150. Find match from range and copy/paste values to destination row where match found (1 replies)
  151. [SOLVED:] Excel MDI vs SDI (14 replies)
  152. [SOLVED:] Opening and editing mutiple csv files (2 replies)
  153. [SOLVED:] Invalid image error :481 (14 replies)
  154. Specific range date on this code (1 replies)
  155. [SOLVED:] Question: Passing objects to sub-procedures (9 replies)
  156. Transforming dataset into a different layout (Formula if possible?) (5 replies)
  157. [SOLVED:] Formula to Return value when a cell falls between two values (2 replies)
  158. Macro to auto copy a cell and paste it in a particular column (1 replies)
  159. Can't change Range.value (5 replies)
  160. Combine rows if there is a blank cell under column A (1 replies)
  161. Extract data to another sheet according to different filtering conditions (using vba) (1 replies)
  162. [SOLVED:] Need help- Sort columns within rows numerically. Cells contain text as well as number (9 replies)
  163. [SOLVED:] Filter a text file and produce a new one (26 replies)
  164. VBA for click on BUTTON Internet DOCUMENT (1 replies)
  165. Floating box Help (1 replies)
  166. [SOLVED:] Need Assistance with Pivot Table Change (6 replies)
  167. [SOLVED:] Help with Split Function (13 replies)
  168. [SOLVED:] Function does not work. Where is the mistake? (3 replies)
  169. Find corresponding value in database, the copy whole row to update it. (1 replies)
  170. Filter a table using a different name each time and paste the results in a new file (0 replies)
  171. Compatibility Checker & Recalculate formula Messages (3 replies)
  172. Auto-Filtering A Dynamic Table and Copy-Pasting to Word Template (0 replies)
  173. Need help comparing numbers and generating a temporary 'no data found' message. (2 replies)
  174. [SOLVED:] Compare values in 2 columns, if values match copy value in adjacent cell to new colum (3 replies)
  175. How to get a cell property? (2 replies)
  176. VBA with counting files (3 replies)
  177. [SOLVED:] Avoid selection and select in format number (8 replies)
  178. [SOLVED:] An application.EnableEvents issue. Help needed. (5 replies)
  179. [SOLVED:] Refactoring & issue with row (2 replies)
  180. Combination algorithm for this condition (2 replies)
  181. EXCEL USER FORM (Update Existing Date and Time) (2 replies)
  182. Size of Files (1 replies)
  183. Copy data from "All Levels" sheet to Master Sheet. (14 replies)
  184. How to use VBA to set up equal number of Rows per Page for a worksheet for print (1 replies)
  185. copy/paste data from nth column into two columns (1 replies)
  186. Formatting the data with the help of VBA Macro (0 replies)
  187. Searching multiple values (0 replies)
  188. Dynamicaly Linked Cells based on the Month (0 replies)
  189. Using VBA to insert a row if condition is met in Excel (0 replies)
  190. Sleeper: Print as a PDF then combine with existing PDF (1 replies)
  191. Search directory using a *word to find and open the latest zip (1 replies)
  192. Sleeper: Range.Address length issue (2 replies)
  193. Add column containing an xl-addin function to a table imported from a Web page (0 replies)
  194. [SOLVED:] macro to create a range name (2 replies)
  195. Range.Address length issue (1 replies)
  196. Insert a row and copy data if condition is met (0 replies)
  197. Create Hyperlink and Copy data from files. (0 replies)
  198. EntireRow.Copy Issues VBA (3 replies)
  199. Format repeated lines in excel with a lighter font (1 replies)
  200. Specific range date on a code with counting subjects (1 replies)
  201. [SOLVED:] Look up value and copy variable coulmn (9 replies)
  202. Copying and sorting rows from multiple tabs to another tab (2 replies)
  203. Random with critaria (4 replies)
  204. Variable declaration (4 replies)
  205. Export to file with different extensions (1 replies)
  206. Copy and Export to CSV of Pivot Table output results (16 replies)
  207. Move files with path as argument (2 replies)
  208. Create Text File with FSO and VBA CreateTextFile (2 replies)
  209. Max characters allowed on status bar? (8 replies)
  210. [SOLVED:] Speed up Macro (23 replies)
  211. Find numbers whose sum is a number given (1 replies)
  212. [SOLVED:] Macro to copy cell without leaving cell (4 replies)
  213. [SOLVED:] Macro to subtotal A2 until blank cell - cany anyone please help? (1 replies)
  214. [SOLVED:] Runtime error (5 replies)
  215. [SOLVED:] Add words to a list in column A relative to a list of selected names in column B (1 replies)
  216. [SOLVED:] Help with an Excel VBA Script (Excel 2010) (3 replies)
  217. [SOLVED:] Need to highlight the entire rows once duplicate values found in two separate columns (3 replies)
  218. copy data from .csv file to other excel files (1 replies)
  219. need macro to update Master Calendar file copying data from numerous identical files. (0 replies)
  220. MACRO to Copy all Sheets from Folder (1 replies)
  221. Excel macro to Automatically generate the data and save file (2 replies)
  222. MATCHING CODE (1 replies)
  223. Excel VB Attachment available or not and Email sending Log (5 replies)
  224. Loop record macro though all worksheets (5 replies)
  225. VBA Code Help with Command Button (10 replies)
  226. How to Application.FileDialog(msoFileDialogFolderPicker) for https:// Sharepoint file (2 replies)
  227. Looping through folder with excel files, extract specific cells values to master file (0 replies)
  228. Unlimited Sub () (1 replies)
  229. VBA macro help (0 replies)
  230. [SOLVED:] IF statment looking at 2 different cells (2 replies)
  231. Problem sorting each table in workbook (0 replies)
  232. Create csv files for rows corresponding to each ID in excel using VBA (0 replies)
  233. Numeric value mysteriously appearing in the VBA editor immediate window. (10 replies)
  234. Application.FileDialog(msoFileDialogFolderPicker) with Network Folder Path (7 replies)
  235. [SOLVED:] Needed help in running the macro very urgent (2 replies)
  236. Hi I need to amend this code (0 replies)
  237. VBA to ZIP and password protect individual folder in the path. (5 replies)
  238. Stop calculating a column once the date has passed (2 replies)
  239. [SOLVED:] Pasting columns to the next blank columns (2 replies)
  240. QR Code creation (1 replies)
  241. Find value in another sheet and get cell value in same row (3 replies)
  242. Reset Input Sheet (1 replies)
  243. Add New Column & Formula & Bold Indicated Value after Last Column (0 replies)
  244. Default Insert Hyperlink by VBA input box (0 replies)
  245. Searching for Multiple Values using Match and Index (2 replies)
  246. Autopopulating columns until one column reaches a certain value, then stopping (3 replies)
  247. Formula Using A Variable in File & Pah (1 replies)
  248. HELP Excel VBA Easy Code Popup MISSING!!! (2 replies)
  249. Filter pivot item by date - type mismatch (0 replies)
  250. Mean of a MOVING Range (6 replies)