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. [SOLVED:] BeforeSave loops and workbook closes (2 replies)
  2. Generating an array, and using Vlookup to loop through this array (VBA) (40 replies)
  3. [SOLVED:] Time Conversion (20 replies)
  4. VBA to copy range from one sheet to another. (1 replies)
  5. [SOLVED:] Looking for help to identify matches across multiple columns (5 replies)
  6. VBA macro to set up dynamic print area (6 replies)
  7. Allocation of Data - URGENT HELP (2 replies)
  8. [SOLVED:] Format Shape menu appears after a printpreview. (3 replies)
  9. [SOLVED:] Move matching rows to existing sheets (9 replies)
  10. code for copying from multiple files and paste in master file (1 replies)
  11. Excel Threads in Windows (3 replies)
  12. [SOLVED:] Populate ListBox from Multiple sheets (13 replies)
  13. [SOLVED:] Help with paste special (2 replies)
  14. vba for keeping first 4 characters and removing duplicates (2 replies)
  15. [SLEEPER:] Copy, paste and sum data from multiple worksheets to one worksheet (8 replies)
  16. VBA Code to link to Oracle (1 replies)
  17. Dynamic pivot table (3 replies)
  18. [SOLVED:] Splitting data from one column into other 4 columns in excel (15 replies)
  19. Public Variables in Object Modules (14 replies)
  20. Graphing on a MAC With VBA (9 replies)
  21. Compare a column of data on one ws to another ws and append non-match data (7 replies)
  22. Comparison for Reconciliation (10 replies)
  23. VBA - Macro has to run twice for it to work. (1 replies)
  24. [SLEEPER:] Joint different set of data (6 replies)
  25. Filtering Column with Multiple Criteria (5 replies)
  26. How to set cookies using web browser userform (0 replies)
  27. [SOLVED:] Delete row if cell is not a number (6 replies)
  28. Check if Attachments was added (3 replies)
  29. ExportedUI File to EXE File. (1 replies)
  30. [SOLVED:] Address SPLIT (11 replies)
  31. [SOLVED:] VBA Code to open a folder when ctrl + right click is pressed (19 replies)
  32. [SOLVED:] If statement with non numeric cells (7 replies)
  33. [SOLVED:] SUMIFS with sum range dependent on another cell value (6 replies)
  34. VBA: Copy Cell to another and remove last 2 characters (3 replies)
  35. VBA To Combine A Combination of Values To Get One Target Value (6 replies)
  36. VBA Lookup? (13 replies)
  37. VBA code help (current code too slow and freezes) (6 replies)
  38. [SOLVED:] Detecting Duplicate entries (10 replies)
  39. [SOLVED:] Display Print Dialog with "Selection" as Default (4 replies)
  40. Error Message: Cannot open file -- File Format/Extension Error -- Troubleshooting (2 replies)
  41. Linked tables and Slicer in Excel (2 replies)
  42. [SOLVED:] Copy Paste Values from multiple workbooks to multiple sheets in one workbook (10 replies)
  43. Macro for form control/LOCKED CHECKBOX FOR CERTAIN DOMAN USER (1 replies)
  44. VBA for color coding a cell based on values in other cells (2 replies)
  45. [SOLVED:] Please Help. trying to check for specific text in cell value :S (2 replies)
  46. Code for pasting as per criteria (9 replies)
  47. Use Getopenfilename function to browse the file. (1 replies)
  48. [SLEEPER:] How can i open external excel file by using button in userform (12 replies)
  49. application.windows object (4 replies)
  50. Unique ID for new userform's entries (27 replies)
  51. ListBox dependent on 2 ComboBox (ComboBox1&2) selections (1 replies)
  52. Color chart caption with VBA (6 replies)
  53. [SOLVED:] Userform output range (5 replies)
  54. [SOLVED:] how can do this: if any userform closed(x) then mainform.show (19 replies)
  55. Some VBA help please (20 replies)
  56. [SOLVED:] Help with Index Match function! (3 replies)
  57. Handle Spelling Errors (11 replies)
  58. Sort Text and Consolidate (4 replies)
  59. [SOLVED:] Individual zoomfactor for each sheet (5 replies)
  60. [SOLVED:] Help on filtering an excel based Column C and send email for every filtered item (8 replies)
  61. Any ideas on how to improve this Userform (1 replies)
  62. [SOLVED:] Matching a string with a partial string using match function (4 replies)
  63. Disable New Excel Auto-save Feature(Not auto recovery) (5 replies)
  64. Convert to PDF, SaveAs, Attach to Outlook Email (1 replies)
  65. Compile Error: User-defined type not defined (6 replies)
  66. Code to update a KPI based on a worksheet (5 replies)
  67. [SOLVED:] Code for pasting according to criteria (4 replies)
  68. OCR Data extraction with VBA from Web site HELP! (0 replies)
  69. VBA userform combobox and vlookup to fill another cells (1 replies)
  70. CX-Server CDMDDE Visual Basic Macro Errors (6 replies)
  71. [SOLVED:] concatenate formula (2 replies)
  72. VBS Program Debug (1 replies)
  73. table and charts in full screen (1 replies)
  74. [SOLVED:] In Automatic Calculation Mode, spreadsheet still does Manual Calculation?? (8 replies)
  75. Simple EXcel Macro help (3 replies)
  76. [SOLVED:] Using a Variable in a named range (8 replies)
  77. Replace a text with a future data (6 replies)
  78. VBA - update entry in other workbook if ID matches (3 replies)
  79. Exporting excel worksheet to word keeping exact formatting (1 replies)
  80. [SOLVED:] VBA Help with Macro to autofit visible columns starting at row 4 (2 replies)
  81. [SOLVED:] Results of OptionButtons by GroupName (21 replies)
  82. [SLEEPER:] Import data from excel files with specific file name into another excel sheet (8 replies)
  83. Named Ranges.! (7 replies)
  84. Unable to click on button HTML (0 replies)
  85. [SOLVED:] Excel Slow performance (71 replies)
  86. Web Vba issue (0 replies)
  87. Pivot table help (12 replies)
  88. [SOLVED:] Query Table - Extract Data From Text File by Column - TextFileColumnDataTypes (3 replies)
  89. Sending Email with Email body in a cell keeping the formatting. (11 replies)
  90. [SOLVED:] Copy Paste to visible cells only with different sheets / workbooks (3 replies)
  91. Error copying multiple worksheets using VBA (3 replies)
  92. [SOLVED:] Filter On Date With Headers (7 replies)
  93. VBA to stop pivot tables refreshing before power queries with autorefresh (1 replies)
  94. Compress four rows into one row (8 replies)
  95. [SOLVED:] Table transpose (5 replies)
  96. Web scraping with complex chronological events (0 replies)
  97. [SOLVED:] Format data in Excel with subtotal (15 replies)
  98. [SOLVED:] One Row.Delete works, another doesn't (5 replies)
  99. Macro to Convert Flat Data to Database - Amendment to existing code required (0 replies)
  100. index match between 2 workbooks (3 replies)
  101. Using checkboxes to copy rows from one sheet to another in the same relative order (1 replies)
  102. Writing a macro to capture values on a spreadsheet and add them to totals on another (2 replies)
  103. VBa code to transfer rows base on a sequential number (9 replies)
  104. [SOLVED:] Excel VBA to Transpose lists (4 replies)
  105. VBA Function - Last Row (19 replies)
  106. [SOLVED:] Coloring rows through value in column (6 replies)
  107. Hide Worksheets dependant on domain name (16 replies)
  108. [SOLVED:] VBA to operate on an external drive + files dispatching in folders (20 replies)
  109. Rewriting Referenced Data for VBA Pivot Table (3 replies)
  110. A neat timesaver for Immediate ("debug") Window - abbreviations (2 replies)
  111. Need code to merge PDF files in a folder using adobe acrobat (2 replies)
  112. Cell locking macro not working (1 replies)
  113. [SOLVED:] combine selected worksheet into one worksheet (4 replies)
  114. Using RANK on a range of data - need an exception (1 replies)
  115. select radio buttons in IE (0 replies)
  116. Encrypt password for database access (2 replies)
  117. Subscript out of range and SaveAs Method error (Revised) (9 replies)
  118. [SOLVED:] VBA check if a specific value has been entered into range (3 replies)
  119. [SOLVED:] Selection not displayed when combobox item is selected (14 replies)
  120. [SOLVED:] Insert Pics Macro Not Working on All Cells unless name manually typed in (7 replies)
  121. [SOLVED:] VBA code to paste data to a row with today's date in column A in another sheet (12 replies)
  122. [SOLVED:] Blank cell (3 replies)
  123. [SOLVED:] IF then (1 replies)
  124. [SOLVED:] Countif using arrays (5 replies)
  125. Parsing data to several sheets (6 replies)
  126. [SOLVED:] how can i save userform settings (12 replies)
  127. [SOLVED:] Help with formula please (3 replies)
  128. Vba code for partial transpose (3 replies)
  129. What are your favorite Excel VBA automation success stories? (0 replies)
  130. [SOLVED:] How to display a chart on a certain position (e.g. centre of screen). (7 replies)
  131. [SOLVED:] Monitoring Remote Workbook for Changes (2 replies)
  132. Dividing data records fairly into clients based on categories and amounts (10 replies)
  133. VBA Code to Run Other VBA Codes in Multiple Workbooks (8 replies)
  134. [SOLVED:] For Loop does not seem to be working (8 replies)
  135. [SOLVED:] FileSystem Object, Folder.Files.Count Does Not Match Files.Item Count (10 replies)
  136. VBA code to delete rows based on value (7 replies)
  137. Getting Problems in Making a Query from SharePoint (0 replies)
  138. [SOLVED:] Shorten loop using boolean (3 replies)
  139. [SOLVED:] is it possible: If Me.Controls("CommandButton" & i).clicked (2 replies)
  140. VBA Help, to Pick first Column Data and its file name (1 replies)
  141. Trying to copy all sheets into one combined sheet (1 replies)
  142. [SOLVED:] sum of variable range stop working (2 replies)
  143. Quote Generator - Advice (3 replies)
  144. Subscript out of range and SaveAs Method error (14 replies)
  145. create and store pdf, attach to email and send, with loop (7 replies)
  146. [SOLVED:] Macro To copy and paste data from a list to corresponding worksheet and cells (2 replies)
  147. Cell Value Confusion. (2 replies)
  148. [SOLVED:] Delete zeros (2 replies)
  149. Sleeper: VBA If formula help (7 replies)
  150. Identify employees late login (3 replies)
  151. [SOLVED:] Can't call several subs in a macro (6 replies)
  152. RTF field in Excel by keeping formatting (5 replies)
  153. Timer + Stop Watch (3 replies)
  154. [SOLVED:] Loop thru all sheets and copy a value (2 replies)
  155. [SOLVED:] Copy and Paste Macro help please (2 replies)
  156. Change Sheet name (3 replies)
  157. Macro is not recording sheet protection password (3 replies)
  158. VBA getElementById doesn't work correctly (1 replies)
  159. If Formula not working as expected (5 replies)
  160. vba help to copy specific colulmn.. from a sheet (1 replies)
  161. adding selected rows into a sheet with a specific selection (4 replies)
  162. Control strings (7 replies)
  163. Advance Filter using VBA (9 replies)
  164. how to make CommandButton1.Rotation = 90 in office 2016 (4 replies)
  165. [SOLVED:] Move File to Folder if filename matches foldername (5 replies)
  166. [SOLVED:] Need help with Do While Loop or If this AND that then.... (6 replies)
  167. [SLEEPER:] VBA code in Cash Flow forecast (24 replies)
  168. Macro to convert from Paste Bottom-Up to Top-Down? (8 replies)
  169. Move cells to another worksheet (2 replies)
  170. [SOLVED:] Unzip files to a folder udf (3 replies)
  171. [SOLVED:] Searching with recursion (13 replies)
  172. [SOLVED:] VBA code mysteriously timing out (2 replies)
  173. VBA Macro - Use relative ranges to graph (7 replies)
  174. [SOLVED:] #Name? error for TextJoin UDF (9 replies)
  175. MSO File Picker Help (2 replies)
  176. VBA code for lookup table (7 replies)
  177. [SOLVED:] vba Double for each Loop combining task (1 replies)
  178. [SLEEPER:] Vertical Column with possibility to filter (3 replies)
  179. modifying function cohort/matrix of ratings migration (0 replies)
  180. VBA Conditional Formating (2 replies)
  181. USER-FORM FILTER DATA EDIT (1 replies)
  182. [SOLVED:] Sort/ transfer data (6 replies)
  183. [SOLVED:] Procedure Too Large - Compile Error (14 replies)
  184. Search string in two columns in different excel sheets and copy the matching data (1 replies)
  185. [SOLVED:] VBA VLOOKUP ON Historic trades (6 replies)
  186. [SOLVED:] VBA FILTER (10 replies)
  187. [SOLVED:] Need help duplicating a row (if not already duplicated) (2 replies)
  188. [SOLVED:] vba help on vlookup (8 replies)
  189. Export all the sheets in excel to images individually files (4 replies)
  190. Add Data Field in Pivot Table (2 replies)
  191. Disable Overtype / Insert Ability in VB Editor for Excel 2016 … (2 replies)
  192. Empty a Module within Excel 2016 … (7 replies)
  193. [SOLVED:] Two rankings (8 replies)
  194. [SOLVED:] Populating colums based on cell value and conditions (21 replies)
  195. VBA Use hidden cell to run IF Statement (3 replies)
  196. [SOLVED:] Pivot Table Error with VBA Code (5 replies)
  197. [SOLVED:] Highlighting a cell if there is a match with another cell (9 replies)
  198. [SOLVED:] Looping through ActiveX checkboxes and adding items to ActiveX List Box (5 replies)
  199. Subscript out of range (4 replies)
  200. [SOLVED:] Auto Save excel workbook every 5 minutes (8 replies)
  201. Can you speed up my vba that copy and pastes the header amongst worksheets? (1 replies)
  202. Trying to copy a macro into another workbook (14 replies)
  203. [SOLVED:] Simple for each loop problem (3 replies)
  204. [SOLVED:] How to Send a HTML Email using Word Email Template using Excel Macro (3 replies)
  205. Compare two strings for similarity or highlight differences in Excel (12 replies)
  206. Run-Time error "7" out of memory (1 replies)
  207. VBA To Check That Value Appears In Single Cell Range Before Starting Macro (9 replies)
  208. Change marker size for all series in a plot (VBA) (2 replies)
  209. [SOLVED:] Copy and Move files to existing Sub-folders based on filename/Sub-folders's Name (9 replies)
  210. [SOLVED:] Convert to a number (3 replies)
  211. [SOLVED:] Take out space (22 replies)
  212. [SOLVED:] How to send email in excel using content in word as email body (7 replies)
  213. [SOLVED:] VBA code to cycle through sheets (9 replies)
  214. Reading and Writing to dat file via forms (6 replies)
  215. VBA: referencing cell in one worksheet and using it as range start for another sheet (6 replies)
  216. [SOLVED:] Running Macros from ComboBox with Items from a Range (3 replies)
  217. Function to update a cell in another worksheet giving #1004 error (5 replies)
  218. [SOLVED:] VBA Code assistance to separate a workbook into several different files. (10 replies)
  219. Autofilter failed (3 replies)
  220. [SOLVED:] VBA code attach an excel file to outlook with a variable file path (7 replies)
  221. VBA code running too slow in Excel 2013 (13 replies)
  222. [SOLVED:] Format Issue (6 replies)
  223. Find and Change Values (11 replies)
  224. [SOLVED:] Break up column A content between column A and B (6 replies)
  225. Help with filter by date (5 replies)
  226. [SOLVED:] VBA function to return MySQL Data (5 replies)
  227. vba adding image after clicking on the textbox (2 replies)
  228. [SOLVED:] Select working(Active) range with mouse (14 replies)
  229. [SOLVED:] Need help with Question, is it possible to Call modules to work or loop through? (32 replies)
  230. [SOLVED:] need macro added to current to automatically move to next row for next search and (6 replies)
  231. userform icon in taskbar problem in win10 office 2016 bit 32 (11 replies)
  232. excel vba macro to apply filter multiple column using header names (13 replies)
  233. [SOLVED:] Split function in vba (6 replies)
  234. Run macro on all files (1 replies)
  235. VBA to update a table from another table (2 replies)
  236. Subscript out of range (2 replies)
  237. [SOLVED:] Handling Formula Errors & Formula Length Limit (20 replies)
  238. [SOLVED:] Pull specific data based on If statements (3 replies)
  239. [SOLVED:] Save Outlook attachment into an Excel cell, as OLEObject in VBA (4 replies)
  240. [SOLVED:] Modified a function that is called in another function, now getting runtime error? (5 replies)
  241. [SOLVED:] Angles between 2 lines (6 replies)
  242. Get (some of) Excel Clipboard contents via Windows clipboard "XML Spreadsheet" format (1 replies)
  243. Vba Compile Error :( (15 replies)
  244. Find out row and column range (3 replies)
  245. [SOLVED:] Create 2 Dimensional Array from "For" Loop (8 replies)
  246. [SOLVED:] Extract part of a line and paste in another cell (3 replies)
  247. [SOLVED:] Remove symbol (2 replies)
  248. [SOLVED:] Copy range to blank cell (10 replies)
  249. Open all CSV files in folder, and merge to one master file. (7 replies)
  250. [SOLVED:] Array limits? (6 replies)