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. XML substitution of values (2 replies)
  2. listbox population based on search value (7 replies)
  3. Deleting rows with specific text (10 replies)
  4. Check first five characters and replace offset (4 replies)
  5. vba add (2 replies)
  6. Create text files with file names from excel column (7 replies)
  7. Check game numbers (3 replies)
  8. vba new (2 replies)
  9. Text to Rows Macro : Subscript out of range (11 replies)
  10. Excel Won't recognise as date (mm/dd/yyyy) (3 replies)
  11. ASSIGN MULTIPLE VARIABLE FROM SINGLE VALUES IN ARRAY (7 replies)
  12. VBA in shared workbooks (1 replies)
  13. Excel.Action (0 replies)
  14. Pivot Table, Calculated Item - not working on large file (0 replies)
  15. EXCEL FORMULA NOT UPDATING CORRECTLY WHEN COPIED FROM ONE YEAR TO THE NEXT. (0 replies)
  16. Need help with my VBA Dictionary task (1 replies)
  17. VBA FOR INSERTING ROWS (3 replies)
  18. Enter a password for multiple protected work books (1 replies)
  19. HOW TO COMBINE 2 MACRO INTO 1 (0 replies)
  20. Sleeper: Images Gallery in UserForm (0 replies)
  21. VBA Nest If Statement help (1 replies)
  22. Append an order number in a text file with a string and then save (1 replies)
  23. VBA Help, Automatically entering passwords on multiple workbooks (3 replies)
  24. [SOLVED:] User Defined Function vba (4 replies)
  25. Run-time error ‘-2147467259 (80004005)’ (7 replies)
  26. [SOLVED:] VBA - Use variable from InputBox in formula? (4 replies)
  27. vba for next loop (4 replies)
  28. [SOLVED:] filtering with * as one of the multiple criteria (2 replies)
  29. [SLEEPER:] Merge files in one folder to a master worksheet and update (5 replies)
  30. Extracting data from same cell in dierent workheets and files inside a folder or sub (0 replies)
  31. VBA code to click on Image button in IE (0 replies)
  32. Help with analysing consistencies in data set (4 replies)
  33. [SOLVED:] Doubleclick add row (3 replies)
  34. I want to automatically create pdf and send via outlook email to different addresses (0 replies)
  35. Get Active directory Username Details in Textbox2 based on Textbox1 Value (1 replies)
  36. Seeking help for creating a nested loop with condition (2 replies)
  37. [SOLVED:] VBA to resize cells with wrapped text (6 replies)
  38. [SOLVED:] Dynamic range help for conditional formatting rows (2 replies)
  39. Print reports from a drop-down list in Excel into one pdf (0 replies)
  40. COMBOBOX Change code not working properly (0 replies)
  41. [SOLVED:] Deleting Ovals - Logic: If they are above row 70 (2 replies)
  42. [SOLVED:] Is there a consistent way to get a sequential list of controls (5 replies)
  43. [SOLVED:] VBA Inputs restricted to specific decimal ending values (4 replies)
  44. VBA to copy a Specif sheet from multiple other workbooks in MAC (0 replies)
  45. [SOLVED:] Sum Cell range based on Worksheet title with wildcard. (3 replies)
  46. Problem: Compare two excel files and mark new text. (0 replies)
  47. [SOLVED:] Run-Time Error '1004" (3 replies)
  48. matrix rank (1 replies)
  49. Googletranslate() (0 replies)
  50. Run several Fast Fourier Transformations in a row (5 replies)
  51. [SOLVED:] VBA Message box to display column titles based upon totals (5 replies)
  52. [SOLVED:] Explanation VBA code [Activate+Loop] (2 replies)
  53. VBA Run-Time Error 13 - Mismatch??? (1 replies)
  54. VBA copy and paste with criteria and different sheets (0 replies)
  55. Insert Picture With Cell Reference In Excel VBA Dont Show In Other Computers (Help) (5 replies)
  56. [SOLVED:] Data Validation in a MessageBox - VBA (2 replies)
  57. [SOLVED:] Macro timing issue (1 replies)
  58. [SOLVED:] Problem with date comparisson (2 replies)
  59. [SOLVED:] Save Attachments from Current Open Outlook Email (1 replies)
  60. VBA button work 3 activity at one click? (26 replies)
  61. #NAME? Error with VBA (3 replies)
  62. [SOLVED:] How to assign a variable value in to another variable (2 replies)
  63. reference cell font color and value (1 replies)
  64. Macro to auto-copy a cell and paste it in a another cell at particular times (2 replies)
  65. [SOLVED:] Downloading images (3 replies)
  66. vba code analysing different workbooks (2 replies)
  67. How prevent open Excel file automatically when open connection to an Excel file (5 replies)
  68. Encryption Decoding VBA String (2 replies)
  69. [SOLVED:] VBA to group and identify (2 replies)
  70. [SOLVED:] Date Format (2 replies)
  71. matching words from transliteration and replacing using vba (6 replies)
  72. Reset Cell Value to Zero every day (after midnight) (3 replies)
  73. Formula instead of Pivot Table (1 replies)
  74. [SLEEPER:] Copy Cell Values to Columns if Criteria is Matched in VBA (1 replies)
  75. [SOLVED:] Unable to Control Cursor at End of Script (2 replies)
  76. [SOLVED:] VBA Code to loop once (Do While) Replacing Array, Object Error (1 replies)
  77. Excel VBA conditional insert of page breaks (1 replies)
  78. VBA code that Unhide sheet that are hidden using (xlSheetHidden) (6 replies)
  79. Create Report based on criteria match (4 replies)
  80. Find match from range and copy/paste values to destination row where match found (1 replies)
  81. [SOLVED:] Excel MDI vs SDI (14 replies)
  82. [SOLVED:] Opening and editing mutiple csv files (2 replies)
  83. [SOLVED:] Invalid image error :481 (14 replies)
  84. Specific range date on this code (1 replies)
  85. [SOLVED:] Question: Passing objects to sub-procedures (9 replies)
  86. Transforming dataset into a different layout (Formula if possible?) (5 replies)
  87. [SOLVED:] Formula to Return value when a cell falls between two values (2 replies)
  88. Macro to auto copy a cell and paste it in a particular column (1 replies)
  89. Can't change Range.value (5 replies)
  90. Combine rows if there is a blank cell under column A (1 replies)
  91. Extract data to another sheet according to different filtering conditions (using vba) (1 replies)
  92. [SOLVED:] Need help- Sort columns within rows numerically. Cells contain text as well as number (9 replies)
  93. [SOLVED:] Filter a text file and produce a new one (26 replies)
  94. VBA for click on BUTTON Internet DOCUMENT (1 replies)
  95. Floating box Help (1 replies)
  96. [SOLVED:] Need Assistance with Pivot Table Change (6 replies)
  97. [SOLVED:] Help with Split Function (13 replies)
  98. [SOLVED:] Function does not work. Where is the mistake? (3 replies)
  99. Find corresponding value in database, the copy whole row to update it. (1 replies)
  100. Filter a table using a different name each time and paste the results in a new file (0 replies)
  101. Compatibility Checker & Recalculate formula Messages (3 replies)
  102. Auto-Filtering A Dynamic Table and Copy-Pasting to Word Template (0 replies)
  103. Need help comparing numbers and generating a temporary 'no data found' message. (2 replies)
  104. [SOLVED:] Compare values in 2 columns, if values match copy value in adjacent cell to new colum (3 replies)
  105. How to get a cell property? (2 replies)
  106. VBA with counting files (3 replies)
  107. [SOLVED:] Avoid selection and select in format number (8 replies)
  108. [SOLVED:] An application.EnableEvents issue. Help needed. (5 replies)
  109. [SOLVED:] Refactoring & issue with row (2 replies)
  110. Combination algorithm for this condition (2 replies)
  111. EXCEL USER FORM (Update Existing Date and Time) (2 replies)
  112. Size of Files (1 replies)
  113. Copy data from "All Levels" sheet to Master Sheet. (14 replies)
  114. How to use VBA to set up equal number of Rows per Page for a worksheet for print (1 replies)
  115. copy/paste data from nth column into two columns (1 replies)
  116. Formatting the data with the help of VBA Macro (0 replies)
  117. Searching multiple values (0 replies)
  118. Dynamicaly Linked Cells based on the Month (0 replies)
  119. Using VBA to insert a row if condition is met in Excel (0 replies)
  120. Sleeper: Print as a PDF then combine with existing PDF (1 replies)
  121. Search directory using a *word to find and open the latest zip (1 replies)
  122. Sleeper: Range.Address length issue (2 replies)
  123. Add column containing an xl-addin function to a table imported from a Web page (0 replies)
  124. [SOLVED:] macro to create a range name (2 replies)
  125. Range.Address length issue (1 replies)
  126. Insert a row and copy data if condition is met (0 replies)
  127. Create Hyperlink and Copy data from files. (0 replies)
  128. EntireRow.Copy Issues VBA (3 replies)
  129. Format repeated lines in excel with a lighter font (1 replies)
  130. Specific range date on a code with counting subjects (1 replies)
  131. [SOLVED:] Look up value and copy variable coulmn (9 replies)
  132. Copying and sorting rows from multiple tabs to another tab (2 replies)
  133. Random with critaria (4 replies)
  134. Variable declaration (4 replies)
  135. Export to file with different extensions (1 replies)
  136. Copy and Export to CSV of Pivot Table output results (16 replies)
  137. Move files with path as argument (2 replies)
  138. [SLEEPER:] Create Text File with FSO and VBA CreateTextFile (2 replies)
  139. Max characters allowed on status bar? (8 replies)
  140. [SOLVED:] Speed up Macro (23 replies)
  141. [SLEEPER:] Find numbers whose sum is a number given (1 replies)
  142. [SOLVED:] Macro to copy cell without leaving cell (4 replies)
  143. [SOLVED:] Macro to subtotal A2 until blank cell - cany anyone please help? (1 replies)
  144. [SOLVED:] Runtime error (5 replies)
  145. [SOLVED:] Add words to a list in column A relative to a list of selected names in column B (1 replies)
  146. [SOLVED:] Help with an Excel VBA Script (Excel 2010) (3 replies)
  147. [SOLVED:] Need to highlight the entire rows once duplicate values found in two separate columns (3 replies)
  148. copy data from .csv file to other excel files (1 replies)
  149. need macro to update Master Calendar file copying data from numerous identical files. (0 replies)
  150. MACRO to Copy all Sheets from Folder (1 replies)
  151. Excel macro to Automatically generate the data and save file (2 replies)
  152. MATCHING CODE (1 replies)
  153. Excel VB Attachment available or not and Email sending Log (5 replies)
  154. Loop record macro though all worksheets (5 replies)
  155. VBA Code Help with Command Button (10 replies)
  156. How to Application.FileDialog(msoFileDialogFolderPicker) for https:// Sharepoint file (2 replies)
  157. Looping through folder with excel files, extract specific cells values to master file (0 replies)
  158. Unlimited Sub () (1 replies)
  159. VBA macro help (0 replies)
  160. [SOLVED:] IF statment looking at 2 different cells (2 replies)
  161. Problem sorting each table in workbook (0 replies)
  162. Create csv files for rows corresponding to each ID in excel using VBA (0 replies)
  163. Numeric value mysteriously appearing in the VBA editor immediate window. (10 replies)
  164. Application.FileDialog(msoFileDialogFolderPicker) with Network Folder Path (7 replies)
  165. [SOLVED:] Needed help in running the macro very urgent (2 replies)
  166. Hi I need to amend this code (0 replies)
  167. [SLEEPER:] VBA to ZIP and password protect individual folder in the path. (5 replies)
  168. Stop calculating a column once the date has passed (2 replies)
  169. [SOLVED:] Pasting columns to the next blank columns (2 replies)
  170. QR Code creation (1 replies)
  171. Find value in another sheet and get cell value in same row (3 replies)
  172. Reset Input Sheet (1 replies)
  173. Add New Column & Formula & Bold Indicated Value after Last Column (0 replies)
  174. [SLEEPER:] Default Insert Hyperlink by VBA input box (0 replies)
  175. Searching for Multiple Values using Match and Index (2 replies)
  176. Autopopulating columns until one column reaches a certain value, then stopping (3 replies)
  177. Formula Using A Variable in File & Pah (1 replies)
  178. HELP Excel VBA Easy Code Popup MISSING!!! (2 replies)
  179. Filter pivot item by date - type mismatch (0 replies)
  180. Mean of a MOVING Range (6 replies)
  181. [SOLVED:] Delete the Value in Sheet 2 that does not exist in Sheet 1 (13 replies)
  182. IF(AND statement works - changing to an IF( and IF(OR causes a False - also is there (3 replies)
  183. [SOLVED:] autorun marcos if condition is met (7 replies)
  184. Move to next column in a loop (2 replies)
  185. VBA range.value and looping issues with selecting a range of cells (0 replies)
  186. round formula vba (0 replies)
  187. Copy worksheet to another workbook (0 replies)
  188. [SOLVED:] Formatting issue when putting data into charts (1 replies)
  189. Please help me. Import data from a scripted web page (0 replies)
  190. VBA novice needing help!! (2 replies)
  191. VBA scripting for PDF (1 replies)
  192. Range in macro (3 replies)
  193. [SOLVED:] Data Validation formula issues (1 replies)
  194. VBA to autofilter with Array (2 replies)
  195. Data Validations and Indirect (1 replies)
  196. Need to compare two string columns based on similarities and return a value (1 replies)
  197. "Compile error: Method or data member not found" assistance (1 replies)
  198. Find Text and Extract (3 replies)
  199. [SOLVED:] Looping through all possible combinations of two ranges (7 replies)
  200. 2010 macro runs slow in 2016 and display result is different (9 replies)
  201. Subtract values in column VBA (19 replies)
  202. Send an email from excel (0 replies)
  203. Pivot table with 2 sheets (3 replies)
  204. Filter excel data without hiding a Graph (1 replies)
  205. [SOLVED:] Search & Index (2 replies)
  206. [SOLVED:] Advice re class modules (7 replies)
  207. Copy Rows - If it Contains a Word Listed in Column A Data Table (1 replies)
  208. Open closed protected excel workbook from other workbook with SQL statement (0 replies)
  209. Filter and delete rows based on value from a cell (1 replies)
  210. Sleeper: Extraction of key entities using VBA (13 replies)
  211. Extract product-price from URL in Excel VB (0 replies)
  212. Excel/VBA app hangs up temporarily when tabbing past last unlocked cell (2 replies)
  213. [SOLVED:] Issue with References (1 replies)
  214. Wrong number of arguments or invalid property assignments in Excel ->word (0 replies)
  215. [SOLVED:] How to Get Array Length... (11 replies)
  216. [SOLVED:] Struggling with Countifs formula (3 replies)
  217. [SOLVED:] VBA to check and delete the entire row (2 replies)
  218. How to return data from a complex nested populated VBA Array (7 replies)
  219. Cash flow analysis: Help selecting a cell based on a certain $ threshold (1 replies)
  220. How to use image recognition for finding buttons on an internet explorer page? (0 replies)
  221. Userform Read only to Read/Write (4 replies)
  222. How to show the last row in this code (0 replies)
  223. Best way for deploy excel with .net dll reference (0 replies)
  224. [SOLVED:] Cut and past a selected row to another worksheet (2 replies)
  225. [SOLVED:] VBA to create a folder and move (8 replies)
  226. [SOLVED:] Dynamically adding check boxes based on worksheet name, updating error (1 replies)
  227. Get row of Checkboxes (7 replies)
  228. Intermittent issue with a UDF, Google address extractor. (0 replies)
  229. Formula on MS Exel sheet Vlookup ,H_lookup , For Entropy and enthalphy (0 replies)
  230. Array Problem (Swapping array value based on determined row) (1 replies)
  231. [SOLVED:] Find ALL cells containing multiple words then display a corresponding cell (6 replies)
  232. Issues with using autofill in vb macro (1 replies)
  233. excel vba (0 replies)
  234. [SOLVED:] When Ranks change in a Range (5 replies)
  235. innerHTML not returned? (2 replies)
  236. [SOLVED:] Loop to find cell, then using that cell reference to clear a range (12 replies)
  237. Accessing File Properties in an audio file (2 replies)
  238. How to unhide a sheet - xlveryhidden (1 replies)
  239. Sub or Function not defined compile error help (11 replies)
  240. [SOLVED:] copy data between worksheets based on list selection (4 replies)
  241. Userform | write new row for ComboBox and TextBox entries ONLY when user adds content (2 replies)
  242. [SOLVED:] Using form control checkboxes to clear ranges on other pages- VBA Excel (3 replies)
  243. Open several files from list of paths (2 replies)
  244. Combine multiple pdf files into one file using Excel (1 replies)
  245. VBA Code - Referencing to a Different Sheet (9 replies)
  246. Add a cell reference in newly created worksheets created by VBA indexed by row (2 replies)
  247. [SOLVED:] If Column A ıs Empty and if Column I has a data copy them to Column A .. (3 replies)
  248. VBA help - not sure which getelement to use for scraping website (0 replies)
  249. [SOLVED:] Delete a filtered auxiliary column while maintaining the filtered range. (6 replies)
  250. [SOLVED:] Export Sheets as CSV and Keep Workbook Open (2 replies)