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. Runtime 1004 Error SaveAs Workbook Failed (3 replies)
  2. Copying data from one worksheet to another base on the header name. (1 replies)
  3. Sending emails with data from cells (including bcc) (2 replies)
  4. Simple Copy and Update Cell Value Every Minute (23 replies)
  5. [SOLVED:] Userform for Project closing (4 replies)
  6. [SOLVED:] Count Rows From Specific Column - Row Number (2 replies)
  7. Auto-Size Pasted Picture/Snippet to Fit Cell Height and Width (2 replies)
  8. Excel VBA Seek Error Solution (4 replies)
  9. Excel VBA: Format and change cell value based on specific values in cell (0 replies)
  10. Formula Evaluation In Excel (3 replies)
  11. Excel file only to open on designated computers (1 replies)
  12. Copying Rows based on two columns having matching data (0 replies)
  13. how to further divide out how this is saved? (0 replies)
  14. Help with filling out webform from excel sheet (0 replies)
  15. How to increment a column with a selected range (8 replies)
  16. VBA Code that deletes entire row if "Received" is selected from Drop-Down List (1 replies)
  17. [SOLVED:] Save to Network drive using UNC format (2 replies)
  18. How can I get my second range to transfer as an offset? (5 replies)
  19. [SOLVED:] Transpose Data In Columns (3 replies)
  20. [SOLVED:] Matching 2 columns (2 replies)
  21. [SOLVED:] Issuing retrieving an "hour value" from worksheet using VBA (2 replies)
  22. Range setting for sort (2 replies)
  23. Deleting cell contents based on a partial formula. (2 replies)
  24. [SOLVED:] Match Overlap Date Range and multiple criteria - Need to match extra criteria (4 replies)
  25. Copy several cells into one cell (0 replies)
  26. Find and format only specific text/numbers (0 replies)
  27. VBA Convert textnumber to number format (1 replies)
  28. Converting columns to rows (6 replies)
  29. [SOLVED:] Conditional Formatting range selection (2 replies)
  30. [SOLVED:] Copying data with changing rows. (5 replies)
  31. Named Range Help - Excel 2013 (1 replies)
  32. Vba data for chart (4 replies)
  33. Select Multiple entry and remove in dropodown in excel vba (1 replies)
  34. [SOLVED:] intersect range and table.listcolumn - need to find if cell is in table column (1 replies)
  35. Copy Columns in Selected Sheets to a New Table with the data (1 replies)
  36. Can't get my code to offset (1 replies)
  37. Excel Formula/Macro: Fetch data from multiple rows and columns with a single key (1 replies)
  38. Google Maps Static API in Excel (0 replies)
  39. Duplicate entire workbook into 3 copies and leave only specific sheets in the copies (1 replies)
  40. VBA code. Copy certain cells with a number of conditions (1 replies)
  41. [SOLVED:] VBA Code needed to insert rows based on pricepoints (5 replies)
  42. 1 Email, Multiple Recipients, No Duplicates (0 replies)
  43. Importing data from multiple files by VBA (8 replies)
  44. [SLEEPER:] VBA is it possible to use a integer like function with cells (1 replies)
  45. Grade calculator this should be easy fix (4 replies)
  46. VBA IE automation: error on getting iframe (0 replies)
  47. [SOLVED:] Loop to match headers on separate sheets, copy and paste revisited (3 replies)
  48. Form Controls Reset to Default on Worksheet (0 replies)
  49. Extracting data from .txt file to excel using vba (0 replies)
  50. Shorten (0 replies)
  51. Insert the different picture into all worksheets (1 replies)
  52. Formula with named ranges not working (8 replies)
  53. [SLEEPER:] Divide number under certain conditions (11 replies)
  54. Splitting Uneven Text Strings (2 replies)
  55. Lookup and return Names for Duplicate Orders (3 replies)
  56. [SLEEPER:] Help with VBA Code (2 replies)
  57. [SOLVED:] Delete row if cell entries in 4 columns match (12 replies)
  58. help with select case (3 replies)
  59. Delete duplicates based on partial match (4 replies)
  60. VBA Assistance Needed (1 replies)
  61. create and print files automatically (1 replies)
  62. [SOLVED:] VBA changes "Rows" to "rows" (3 replies)
  63. VBA Print area problem (1 replies)
  64. VBA Set File path to a cell reference in the workbook (6 replies)
  65. VBA to Auto-populate the Sheet "Protect" password field(s) (0 replies)
  66. [SOLVED:] Radar Scoring (4 replies)
  67. Help with VBA code to copy formatting into clipboard (7 replies)
  68. [SLEEPER:] VBA Error handling (7 replies)
  69. search for a string in a column on a different worksheet (1 replies)
  70. Excel VBA Don't show Sampling - Output range will overwrite existing data (2 replies)
  71. VBA - copy specific cells with criteria to multiple workbooks (get filename from cell (3 replies)
  72. [SOLVED:] VBA copy from a variable sheet (8 replies)
  73. Excel 2010 / VBA/ problem with code to create listbox in userform (2 replies)
  74. VBA to extract & combine data from multiple excel file from a specific folder (0 replies)
  75. VBA Macro To Scan Headers and Paste Them Into Specific Column On Master Template (4 replies)
  76. opening 2010 file in VBA (2 replies)
  77. EDITTING THE LIST FROM COMBOX AND CHANGE TO NEW VALUE (0 replies)
  78. VBA Help to Reverse a String without StrReverse function (6 replies)
  79. Repeat VBA code for each cell (5 replies)
  80. VBA program to find the number 15 (5 replies)
  81. Split Data in Column A into Separate Workbooks (1 replies)
  82. Message in cell when criteria is met (2 replies)
  83. CONDITIONAL FORMATING IF CELL HAS ROUND FORMULA (5 replies)
  84. [SOLVED:] Delete after coma when spicify workd does not exists (5 replies)
  85. forgot the password of Excel (1 replies)
  86. Adding to a Cell Which Time Decays (30 replies)
  87. Loop through folder to fill a table (2 replies)
  88. Excel VBA attaching print area as PDF (1 replies)
  89. Protect & Unprotect Sheet in AutoCall Macro (3 replies)
  90. [SOLVED:] How to Reference a String in a Cell (2 replies)
  91. Develop VBA program to find and divide numbers (0 replies)
  92. [SOLVED:] Replacing a Date Extracted From a String (1 replies)
  93. Excel file open by specific ID number (4 replies)
  94. [SOLVED:] Next without For error (2 replies)
  95. Excel VBA macro to paste values (1 replies)
  96. Bring picture to front (1 replies)
  97. Sports scheduling helper (1 replies)
  98. [SLEEPER:] Jumping to intermittent last cells in a column (6 replies)
  99. [SOLVED:] Export data to workbook with criteria with few selected columns(not all rows) (1 replies)
  100. Converting a logic in R to Excel VBA (0 replies)
  101. Only FOR JULY (07-01-18 to 07-31-18 ) as per formula available in cell (1 replies)
  102. Copy rows to new tab based on column value (0 replies)
  103. [SOLVED:] Macro not finding next available blank line (5 replies)
  104. Time delay Stock Data (0 replies)
  105. [SOLVED:] VBA Makro Load Data from Website with Java Script (0 replies)
  106. [SOLVED:] Updating PT Slicers is Causing Macro to Fail (1 replies)
  107. Checking format of a selected Range (0 replies)
  108. [SOLVED:] Angle of a trend line (2 replies)
  109. If statement to copy data to correct row (5 replies)
  110. Need Help VBA Find Certain Value (0 replies)
  111. [SOLVED:] requesting help on restructuring code to work on extracting data w. int color red (4 replies)
  112. Need to build a macro with the following logic. Don't know how to start! (1 replies)
  113. Preventing closing a workbook (8 replies)
  114. complex slicer (8 replies)
  115. Macro does not copy to the next row on the destination sheet (1 replies)
  116. Counting Consecutive numbers > 100 in a column by multiple criteria (0 replies)
  117. [SOLVED:] Getting last modified date shown in footer and cell (0 replies)
  118. need help leaning or restructuring macro for highlighighting duplicates on large data (5 replies)
  119. Creating automatic chart using other sheet's data? (1 replies)
  120. Adding Slide in Powerpoint via Excel VBA (0 replies)
  121. How to store an embedded wave file into a variable (1 replies)
  122. Overview values pivot table (8 replies)
  123. Change code to include range of cells (0 replies)
  124. [SLEEPER:] Creating CAD files using Excel. (2 replies)
  125. [SOLVED:] Create x,y points from mouse clicks (6 replies)
  126. Automatically save on insert/modify cell data. (5 replies)
  127. Macros not enabled etc. Runtime Error 1004 (2 replies)
  128. [SOLVED:] Need help with highlighting duplicates of data in 3 columns, Please (2 replies)
  129. [SLEEPER:] Copy Sheet From file to workbook, and save it as origin name in different file (1 replies)
  130. Option Enabled Search (4 replies)
  131. [SOLVED:] I Need help to reconstruct code to add to existing code, please (4 replies)
  132. Highlighting cells that contain specific characters with VBA (3 replies)
  133. [SOLVED:] Conditional Data Validation issue (1 replies)
  134. Insert and Delete rows based on value (1 replies)
  135. [SOLVED:] vba conditional formatting - compare range of adjacent cells (2 replies)
  136. [SOLVED:] expand and complete series excel (2 replies)
  137. Inserting Multiple Rows in Excel based on cell selection (1 replies)
  138. vba help to shorten the my code... (7 replies)
  139. Need to Match two or more rows values based on their ID in another cell (0 replies)
  140. Cancel querytable.refresh (2 replies)
  141. Floating point question, exactness of integers (0 replies)
  142. [SOLVED:] Trying to Make Macros Run More Efficiently (11 replies)
  143. [SOLVED:] Excel Calculation issues with UDF (3 replies)
  144. Combine 2 sheets into 1 PDF file (3 replies)
  145. [SOLVED:] inputbox coding for invalid selection(s) - column (2 replies)
  146. [SOLVED:] Automatically enter the value of a formula in adjacent cell (5 replies)
  147. Not able to use the find command in vba ,Please help (6 replies)
  148. [SLEEPER:] Download and extract zip file, and open file in it (15 replies)
  149. Dependent Combo Box in userform (1 replies)
  150. Help with production counter in VBA (1 replies)
  151. problem with api call (0 replies)
  152. Format Object (2 replies)
  153. VBA with a lot of condition statement (3 replies)
  154. Renaming a closed excel file by info in it, Excel VBA (0 replies)
  155. Expanding between two dates (start and end) along with other information (1 replies)
  156. Creating comma separated list from multiple columns (3 replies)
  157. VBA: Workbook won't open until the macro is completely finished (1 replies)
  158. VBA reset all pages in multipage (4 replies)
  159. Auto filling data w/ VBA (0 replies)
  160. Modify Macro to have sheets added in particular order (15 replies)
  161. modify vba code (1 replies)
  162. Search for number in another Excel file and get adjacent cell (0 replies)
  163. search for words or symbols in files (2 replies)
  164. [SLEEPER:] Facing Run-time error-13 "Type Mismatch" while edit and update user (3 replies)
  165. Urgent help needed - "Runtime error 9: subscript out of range" (6 replies)
  166. Compare and replace- English and French Translation- Optimization. (4 replies)
  167. [SOLVED:] Conditional Formating Issue (3 replies)
  168. Copy data from Pivot table(except headings) to a new tab using VBA (1 replies)
  169. Clearing a Shape from a Chart (0 replies)
  170. Not VBA - INDEX MATCH MAX DATE Question!!! :) (1 replies)
  171. Excel Graph Paper Not Measuring Correctly (0 replies)
  172. Help! (3 replies)
  173. Unique Variable Name for File (1 replies)
  174. Search string or substring from range (1 replies)
  175. Duplicate Values only on ListBox (6 replies)
  176. [SOLVED:] Loop to Cut Down on Long Code (2 replies)
  177. Insert new row in excel which is protected (11 replies)
  178. Excel VBA CDO Email (4 replies)
  179. Find copy and paste into same worksheet (9 replies)
  180. overloaded excel workbook - ETL replacement ? (1 replies)
  181. Transpose and insert a column to a row on a different sheet (14 replies)
  182. Count values in rows based on column name (1 replies)
  183. [SOLVED:] Date Lookup Problem (1 replies)
  184. find all path between any two nodes (1 replies)
  185. Paste Link is greyed out during Paste Special (3 replies)
  186. Delete Rows based on Input Box Enrty (1 replies)
  187. [SOLVED:] Copied Table Missing First Column (5 replies)
  188. How to group Files in windows explorer with VBA / VBScrip (a .bat file) (0 replies)
  189. Need assistance pls (5 replies)
  190. [SOLVED:] VBA Code to open PDF file using LastModifiedDate (19 replies)
  191. Excel vba code to iterate through list and match to total (2 replies)
  192. [SOLVED:] Analyse a subset of numeric Array only (4 replies)
  193. [SOLVED:] Select Folder and Rename Files according to list in excel using VBA (1 replies)
  194. [SOLVED:] Adding Email Addresses From Names Rages to Lotus Notes (2 replies)
  195. Required Conditional formatting (0 replies)
  196. [SOLVED:] If cell is N/A, how to replace it with the average value of the cells above and below (13 replies)
  197. Loop Format (Not Looping) (1 replies)
  198. Modify the code in the userform (0 replies)
  199. [SOLVED:] Search Replace in Text files - Loop to Next Search & Replacement (14 replies)
  200. VBA not running correctly in Excel 2016 (worked perfectly 2010) (2 replies)
  201. Excel VBA creating emails via web browser (2 replies)
  202. [SOLVED:] Finding Min and Max Times for Each Date (8 replies)
  203. Want some idea on transposing function (5 replies)
  204. [SOLVED:] Shell Command results in Runtime Error 5 (7 replies)
  205. User Form to Select Pivot Table Filters (0 replies)
  206. [SOLVED:] String || How to do selection.replace with space? (9 replies)
  207. Help with Compile error: Else with out if (1 replies)
  208. If cells in a column contain a value, input text into another column. (2 replies)
  209. Split the excel based on headings (2 replies)
  210. Delete multiple files, based on cell value. (1 replies)
  211. [SOLVED:] Split the excel based on headings list (5 replies)
  212. [SOLVED:] Switch Values Between Sheets (5 replies)
  213. Help: VBA Training to pull data from online database to worksheets (0 replies)
  214. [SOLVED:] if and match formula (9 replies)
  215. BEG FOR HELP-EXCEL VBA CODE/FORMULA FOR A LIST (3 replies)
  216. Unique Random Number Generation (5 replies)
  217. VBA Script seems working at first glance, but does not.. (2 replies)
  218. Multiple similar If Statements (5 replies)
  219. [SLEEPER:] Want to convert markovitz excel variance model to VBA (0 replies)
  220. Filtering on checkbox text (3 replies)
  221. run macro in workbook1 then go to workbook2 to run macro (1 replies)
  222. How do I fix this VBA Code? (1 replies)
  223. Compare Main List and Sub List, included new items in sub list to main list (0 replies)
  224. VBA website scraping - multiple link clicks to show full table (0 replies)
  225. Help with VBA Code: cell values and matching values (0 replies)
  226. [SOLVED:] Date Format Help (5 replies)
  227. Run-Time 1004 Array Copy Error Charts to PPT (1 replies)
  228. Class module for userform command buttons (2 replies)
  229. [SLEEPER:] vba macro to loop through find and return search criteria (0 replies)
  230. Insert a date in a cell in one and only possible format (1 replies)
  231. Sorting a multicolumn listbox (2 replies)
  232. Transpose an array - type mismatch error (8 replies)
  233. Count unique values with three conditions (4 replies)
  234. Run Time Error 438 (1 replies)
  235. [SOLVED:] NEED HELP MODIFYING EXISTING EVENT CODE BY ADDING ANOTHER CODE RUN AS ONE CODE. (17 replies)
  236. Reading in a Text File (3 replies)
  237. [SOLVED:] Two different additions alternatively (2 replies)
  238. Copying Sheet into Master Sheet (0 replies)
  239. [SLEEPER:] Using a Userform with Multilple Checkboxes to complete a Range of Cells (9 replies)
  240. Using Dynamic Ranges (without range address) inside a Formula (15 replies)
  241. Transfer data from one workbook to another (0 replies)
  242. Macro auto filter to create report pasting hidden rows. Help (5 replies)
  243. [SOLVED:] VBA remove all records from master sheet while auto refreshing and auto archival (4 replies)
  244. Compare Two Sheets and Extract Differences (4 replies)
  245. [SOLVED:] Excel VBA Email with PDF attachments (5 replies)
  246. Have a shortcut key to command bar (10 replies)
  247. [SOLVED:] Clear contents with in a range in Excel through VB (2 replies)
  248. VBA Pivot Calcfield (0 replies)
  249. Excel VBA Delete after timer (9 replies)
  250. Send Textbox Text to Array (3 replies)