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. Merge Multiple Workbooks into One (3 replies)
  2. VLOOKUP to the left (2 replies)
  3. the color of cells (5 replies)
  4. [SOLVED:] Detect the same value on cell and merge them (6 replies)
  5. [SOLVED:] About WorkSheet_Change Event VBA (1 replies)
  6. [SOLVED:] Best way to hide rows depending on cell value? (16 replies)
  7. Dynamic diagramm (14 replies)
  8. [SOLVED:] Date Series Fill (13 replies)
  9. VBA please Support (12 replies)
  10. VBA to create-rename new sheets in a workbook and export them individually as CSV (6 replies)
  11. VBA: Copy and Past between different instances (7 replies)
  12. Help create Macro remove multi-lines duplicate characters (1 replies)
  13. [SOLVED:] Using String variables within a formula in VBA (7 replies)
  14. Macro breaking when any edits to sheet are made (4 replies)
  15. [SOLVED:] Combining multiple Named Ranges into one (8 replies)
  16. [SOLVED:] Need an advice for Insert new Row in other Sheet in VBA (2 replies)
  17. User form Help (5 replies)
  18. Formula for counting most frequent values (1 replies)
  19. VBA how to: Multi line text in cell to column (7 replies)
  20. [SOLVED:] Linear interpolation. retrieving the wrong data. (2 replies)
  21. [SOLVED:] Form Control Listbox help (12 replies)
  22. Use VBA to send XML API (0 replies)
  23. Search for file name in all drives (9 replies)
  24. [SOLVED:] Macro to update macro buttons (3 replies)
  25. Macro captures scrap and submits it to another book. Please Help improve. (1 replies)
  26. [SOLVED:] Email Range in Body of Email - Not pasting the data (9 replies)
  27. VBA Code required to see if workbook is opened or not. (5 replies)
  28. Need an advice for VLOOKUP function in VBA (2 replies)
  29. Looping through code (7 replies)
  30. how to move xls files in same named folders by vba (1 replies)
  31. [SOLVED:] Need VBA Help! (3 replies)
  32. DropBox getting dropdown menu from filtered table (2 replies)
  33. VBA that allows sorting of data by user (2 replies)
  34. Copy to new WorkSheet and name as specific dates (5 replies)
  35. Search and replace (1 replies)
  36. Filter the microsoft date and time picker control output (3 replies)
  37. [SOLVED:] VBA for Excel: automated correction of wrong decimal separator (8 replies)
  38. [SOLVED:] Assistance with bringing specific items from text file into Excel (2 replies)
  39. VBA to insert SUMIFS formula with row number updated when inserted (2 replies)
  40. Median with a Condition on Text Selection that Differs Only by Ending Number (4 replies)
  41. Copy selective columns from one worksheet to another in the same workbook (2 replies)
  42. Search Matching Value (1 replies)
  43. [SOLVED:] Set Columns Names in ListBoxes (2 replies)
  44. Userform Listbox Filter using comboBox (29 replies)
  45. CHOOSE with HLOOKUP (3 replies)
  46. [SOLVED:] Insert picture into image control (8 replies)
  47. insert formula - Run-time error '1004' - Application defined or object-defined error (17 replies)
  48. HELP: VBA Listbox - highlight selected states of AU and display some basic info (12 replies)
  49. [SOLVED:] VBA for picking only one value from an SQL base (2 replies)
  50. Re: Track Changes - Text and Formulas with user name and time stamp (1 replies)
  51. Display Data from Two Sheets (0 replies)
  52. Coloring range of cells under colored cels (15 replies)
  53. Restrict entry to textbox (9 replies)
  54. Excel VBA Listbox with additional item number column (11 replies)
  55. [SOLVED:] Index/Match with multiple criteria (4 replies)
  56. [SOLVED:] Help! edit multi-cells with conditions. Thank all of you! (3 replies)
  57. [SOLVED:] Clear cell after Worksheet_Change Analysis (4 replies)
  58. VBA/Excel Workbook Help (2 replies)
  59. VBA - copying & pasting data using file path (11 replies)
  60. from a formula to a macro (1 replies)
  61. Referencing List, how can i find the closest match? (4 replies)
  62. [SOLVED:] VBA Lookup, how to return multiple columns? (2 replies)
  63. [SOLVED:] generate random and unique value of cells (3 replies)
  64. [SOLVED:] Rearranging Words within a Cell (15 replies)
  65. VBA pull first 4 digits until the bottom of the data (1 replies)
  66. Create a list of unique values from multiple workbooks (1 replies)
  67. Copy rows and column headings to new workbook based on cell value (7 replies)
  68. Dataset updates changing the pivot table (1 replies)
  69. VBA Code optimization- Speed up this Macro (2 replies)
  70. [SOLVED:] Change Textbox and Combobox Back Color (7 replies)
  71. [SOLVED:] Sorting Rows by certain columns using VBA (or not?) (2 replies)
  72. Addition of cells as path (1 replies)
  73. Filter Value from Column and paste selection as value in another Sheet VBA (2 replies)
  74. [SOLVED:] Linear interpolation (9 replies)
  75. [SOLVED:] Pivot Table grouping (4 replies)
  76. Graph Data Labels - how to avoid line break (1 replies)
  77. Copy whole frame content to worksheet (3 replies)
  78. [SOLVED:] Help with limiting VBA range (4 replies)
  79. [SOLVED:] Copy column from one sheet to another then sort and remove multiple delimiters (7 replies)
  80. [SOLVED:] Copy + Paste to Last Row based on Last Row of adjacent Column (2 replies)
  81. VBA: Folder & File Lister (1 replies)
  82. Attendance Spreadsheet - Custom point reduction (8 replies)
  83. Find list of words occurred (7 replies)
  84. [SOLVED:] Adding new lines in multiple spreadsheets (5 replies)
  85. [SOLVED:] Condensing code - Using Arrays for Loops (5 replies)
  86. VBA Code to link spreadsheet data (12 replies)
  87. Reverse INDEX and MATCH (2 replies)
  88. Sleeper: Converting Index Match function to VBA code (1 replies)
  89. [SOLVED:] Create a Project Scheduler With Excel (44 replies)
  90. [SOLVED:] automatically consolidate data from different sheets to 1 combined sheet (4 replies)
  91. VBA Get a value from a cell and compare to multiple conditions ElseIf (4 replies)
  92. Method 'Copy' of object'_Worksheet' failed PROBLEM (6 replies)
  93. [SOLVED:] BeforeSave loops and workbook closes (2 replies)
  94. Generating an array, and using Vlookup to loop through this array (VBA) (40 replies)
  95. [SOLVED:] Time Conversion (20 replies)
  96. VBA to copy range from one sheet to another. (1 replies)
  97. [SOLVED:] Looking for help to identify matches across multiple columns (5 replies)
  98. VBA macro to set up dynamic print area (6 replies)
  99. Allocation of Data - URGENT HELP (2 replies)
  100. [SOLVED:] Format Shape menu appears after a printpreview. (3 replies)
  101. [SOLVED:] Move matching rows to existing sheets (9 replies)
  102. code for copying from multiple files and paste in master file (1 replies)
  103. Excel Threads in Windows (3 replies)
  104. [SOLVED:] Populate ListBox from Multiple sheets (13 replies)
  105. [SOLVED:] Help with paste special (2 replies)
  106. vba for keeping first 4 characters and removing duplicates (2 replies)
  107. Copy, paste and sum data from multiple worksheets to one worksheet (8 replies)
  108. VBA Code to link to Oracle (1 replies)
  109. Dynamic pivot table (3 replies)
  110. [SOLVED:] Splitting data from one column into other 4 columns in excel (15 replies)
  111. Public Variables in Object Modules (14 replies)
  112. Graphing on a MAC With VBA (9 replies)
  113. Compare a column of data on one ws to another ws and append non-match data (7 replies)
  114. Comparison for Reconciliation (10 replies)
  115. VBA - Macro has to run twice for it to work. (1 replies)
  116. Joint different set of data (6 replies)
  117. Filtering Column with Multiple Criteria (5 replies)
  118. How to set cookies using web browser userform (0 replies)
  119. [SOLVED:] Delete row if cell is not a number (6 replies)
  120. Check if Attachments was added (3 replies)
  121. ExportedUI File to EXE File. (1 replies)
  122. [SOLVED:] Address SPLIT (11 replies)
  123. [SOLVED:] VBA Code to open a folder when ctrl + right click is pressed (19 replies)
  124. [SOLVED:] If statement with non numeric cells (7 replies)
  125. [SOLVED:] SUMIFS with sum range dependent on another cell value (6 replies)
  126. VBA: Copy Cell to another and remove last 2 characters (3 replies)
  127. VBA To Combine A Combination of Values To Get One Target Value (6 replies)
  128. VBA Lookup? (13 replies)
  129. VBA code help (current code too slow and freezes) (6 replies)
  130. [SOLVED:] Detecting Duplicate entries (10 replies)
  131. [SOLVED:] Display Print Dialog with "Selection" as Default (4 replies)
  132. Error Message: Cannot open file -- File Format/Extension Error -- Troubleshooting (2 replies)
  133. Linked tables and Slicer in Excel (2 replies)
  134. [SOLVED:] Copy Paste Values from multiple workbooks to multiple sheets in one workbook (10 replies)
  135. Macro for form control/LOCKED CHECKBOX FOR CERTAIN DOMAN USER (1 replies)
  136. VBA for color coding a cell based on values in other cells (2 replies)
  137. [SOLVED:] Please Help. trying to check for specific text in cell value :S (2 replies)
  138. Code for pasting as per criteria (9 replies)
  139. Use Getopenfilename function to browse the file. (1 replies)
  140. how can i open external excel file by using button in userform (12 replies)
  141. application.windows object (4 replies)
  142. Unique ID for new userform's entries (27 replies)
  143. ListBox dependent on 2 ComboBox (ComboBox1&2) selections (1 replies)
  144. Color chart caption with VBA (6 replies)
  145. [SOLVED:] Userform output range (5 replies)
  146. [SOLVED:] how can do this: if any userform closed(x) then mainform.show (19 replies)
  147. Some VBA help please (20 replies)
  148. [SOLVED:] Help with Index Match function! (3 replies)
  149. Handle Spelling Errors (11 replies)
  150. Sort Text and Consolidate (4 replies)
  151. [SOLVED:] Individual zoomfactor for each sheet (5 replies)
  152. [SOLVED:] Help on filtering an excel based Column C and send email for every filtered item (8 replies)
  153. Any ideas on how to improve this Userform (1 replies)
  154. [SOLVED:] Matching a string with a partial string using match function (4 replies)
  155. Disable New Excel Auto-save Feature(Not auto recovery) (5 replies)
  156. Convert to PDF, SaveAs, Attach to Outlook Email (1 replies)
  157. Compile Error: User-defined type not defined (6 replies)
  158. Code to update a KPI based on a worksheet (5 replies)
  159. [SOLVED:] Code for pasting according to criteria (4 replies)
  160. OCR Data extraction with VBA from Web site HELP! (0 replies)
  161. VBA userform combobox and vlookup to fill another cells (1 replies)
  162. CX-Server CDMDDE Visual Basic Macro Errors (6 replies)
  163. [SOLVED:] concatenate formula (2 replies)
  164. VBS Program Debug (1 replies)
  165. table and charts in full screen (1 replies)
  166. [SOLVED:] In Automatic Calculation Mode, spreadsheet still does Manual Calculation?? (8 replies)
  167. Simple EXcel Macro help (3 replies)
  168. [SOLVED:] Using a Variable in a named range (8 replies)
  169. Replace a text with a future data (6 replies)
  170. VBA - update entry in other workbook if ID matches (3 replies)
  171. Exporting excel worksheet to word keeping exact formatting (1 replies)
  172. [SOLVED:] VBA Help with Macro to autofit visible columns starting at row 4 (2 replies)
  173. [SOLVED:] Results of OptionButtons by GroupName (21 replies)
  174. Import data from excel files with specific file name into another excel sheet (8 replies)
  175. Named Ranges.! (7 replies)
  176. Unable to click on button HTML (0 replies)
  177. [SOLVED:] Excel Slow performance (71 replies)
  178. Web Vba issue (0 replies)
  179. Pivot table help (12 replies)
  180. [SOLVED:] Query Table - Extract Data From Text File by Column - TextFileColumnDataTypes (3 replies)
  181. Sending Email with Email body in a cell keeping the formatting. (11 replies)
  182. [SOLVED:] Copy Paste to visible cells only with different sheets / workbooks (3 replies)
  183. Error copying multiple worksheets using VBA (3 replies)
  184. [SOLVED:] Filter On Date With Headers (7 replies)
  185. VBA to stop pivot tables refreshing before power queries with autorefresh (1 replies)
  186. Compress four rows into one row (8 replies)
  187. [SOLVED:] Table transpose (5 replies)
  188. Web scraping with complex chronological events (0 replies)
  189. [SOLVED:] Format data in Excel with subtotal (15 replies)
  190. [SOLVED:] One Row.Delete works, another doesn't (5 replies)
  191. Macro to Convert Flat Data to Database - Amendment to existing code required (0 replies)
  192. index match between 2 workbooks (3 replies)
  193. Using checkboxes to copy rows from one sheet to another in the same relative order (1 replies)
  194. Writing a macro to capture values on a spreadsheet and add them to totals on another (2 replies)
  195. VBa code to transfer rows base on a sequential number (9 replies)
  196. [SOLVED:] Excel VBA to Transpose lists (4 replies)
  197. VBA Function - Last Row (19 replies)
  198. [SOLVED:] Coloring rows through value in column (6 replies)
  199. Hide Worksheets dependant on domain name (16 replies)
  200. [SOLVED:] VBA to operate on an external drive + files dispatching in folders (20 replies)
  201. Rewriting Referenced Data for VBA Pivot Table (3 replies)
  202. A neat timesaver for Immediate ("debug") Window - abbreviations (2 replies)
  203. Need code to merge PDF files in a folder using adobe acrobat (2 replies)
  204. Cell locking macro not working (1 replies)
  205. [SOLVED:] combine selected worksheet into one worksheet (4 replies)
  206. Using RANK on a range of data - need an exception (1 replies)
  207. select radio buttons in IE (0 replies)
  208. Encrypt password for database access (2 replies)
  209. Subscript out of range and SaveAs Method error (Revised) (9 replies)
  210. [SOLVED:] VBA check if a specific value has been entered into range (3 replies)
  211. [SOLVED:] Selection not displayed when combobox item is selected (14 replies)
  212. [SOLVED:] Insert Pics Macro Not Working on All Cells unless name manually typed in (7 replies)
  213. [SOLVED:] VBA code to paste data to a row with today's date in column A in another sheet (12 replies)
  214. [SOLVED:] Blank cell (3 replies)
  215. [SOLVED:] IF then (1 replies)
  216. [SOLVED:] Countif using arrays (5 replies)
  217. Parsing data to several sheets (6 replies)
  218. [SOLVED:] how can i save userform settings (12 replies)
  219. [SOLVED:] Help with formula please (3 replies)
  220. Vba code for partial transpose (3 replies)
  221. What are your favorite Excel VBA automation success stories? (0 replies)
  222. [SOLVED:] How to display a chart on a certain position (e.g. centre of screen). (7 replies)
  223. [SOLVED:] Monitoring Remote Workbook for Changes (2 replies)
  224. Dividing data records fairly into clients based on categories and amounts (10 replies)
  225. VBA Code to Run Other VBA Codes in Multiple Workbooks (8 replies)
  226. [SOLVED:] For Loop does not seem to be working (8 replies)
  227. [SOLVED:] FileSystem Object, Folder.Files.Count Does Not Match Files.Item Count (10 replies)
  228. VBA code to delete rows based on value (7 replies)
  229. Getting Problems in Making a Query from SharePoint (0 replies)
  230. [SOLVED:] Shorten loop using boolean (3 replies)
  231. [SOLVED:] is it possible: If Me.Controls("CommandButton" & i).clicked (2 replies)
  232. VBA Help, to Pick first Column Data and its file name (1 replies)
  233. Trying to copy all sheets into one combined sheet (1 replies)
  234. [SOLVED:] sum of variable range stop working (2 replies)
  235. Quote Generator - Advice (3 replies)
  236. Subscript out of range and SaveAs Method error (14 replies)
  237. create and store pdf, attach to email and send, with loop (7 replies)
  238. [SOLVED:] Macro To copy and paste data from a list to corresponding worksheet and cells (2 replies)
  239. Cell Value Confusion. (2 replies)
  240. [SOLVED:] Delete zeros (2 replies)
  241. Sleeper: VBA If formula help (7 replies)
  242. Identify employees late login (3 replies)
  243. [SOLVED:] Can't call several subs in a macro (6 replies)
  244. RTF field in Excel by keeping formatting (5 replies)
  245. Timer + Stop Watch (3 replies)
  246. [SOLVED:] Loop thru all sheets and copy a value (2 replies)
  247. [SOLVED:] Copy and Paste Macro help please (2 replies)
  248. Change Sheet name (3 replies)
  249. Macro is not recording sheet protection password (3 replies)
  250. VBA getElementById doesn't work correctly (1 replies)