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. [SOLVED:] Delete the Value in Sheet 2 that does not exist in Sheet 1 (13 replies)
  2. IF(AND statement works - changing to an IF( and IF(OR causes a False - also is there (3 replies)
  3. [SOLVED:] autorun marcos if condition is met (7 replies)
  4. Move to next column in a loop (2 replies)
  5. VBA range.value and looping issues with selecting a range of cells (0 replies)
  6. round formula vba (0 replies)
  7. Copy worksheet to another workbook (0 replies)
  8. [SOLVED:] Formatting issue when putting data into charts (1 replies)
  9. Please help me. Import data from a scripted web page (0 replies)
  10. VBA novice needing help!! (2 replies)
  11. VBA scripting for PDF (1 replies)
  12. Range in macro (3 replies)
  13. [SOLVED:] Data Validation formula issues (1 replies)
  14. VBA to autofilter with Array (2 replies)
  15. Data Validations and Indirect (1 replies)
  16. Need to compare two string columns based on similarities and return a value (1 replies)
  17. "Compile error: Method or data member not found" assistance (1 replies)
  18. Find Text and Extract (3 replies)
  19. [SOLVED:] Looping through all possible combinations of two ranges (7 replies)
  20. 2010 macro runs slow in 2016 and display result is different (9 replies)
  21. Subtract values in column VBA (19 replies)
  22. Send an email from excel (0 replies)
  23. Pivot table with 2 sheets (3 replies)
  24. Filter excel data without hiding a Graph (1 replies)
  25. [SOLVED:] Search & Index (2 replies)
  26. [SOLVED:] Advice re class modules (7 replies)
  27. Copy Rows - If it Contains a Word Listed in Column A Data Table (1 replies)
  28. Open closed protected excel workbook from other workbook with SQL statement (0 replies)
  29. Filter and delete rows based on value from a cell (1 replies)
  30. Sleeper: Extraction of key entities using VBA (13 replies)
  31. Extract product-price from URL in Excel VB (0 replies)
  32. Excel/VBA app hangs up temporarily when tabbing past last unlocked cell (2 replies)
  33. [SOLVED:] Issue with References (1 replies)
  34. Wrong number of arguments or invalid property assignments in Excel ->word (0 replies)
  35. [SOLVED:] How to Get Array Length... (11 replies)
  36. [SOLVED:] Struggling with Countifs formula (3 replies)
  37. [SOLVED:] VBA to check and delete the entire row (2 replies)
  38. How to return data from a complex nested populated VBA Array (7 replies)
  39. Cash flow analysis: Help selecting a cell based on a certain $ threshold (1 replies)
  40. How to use image recognition for finding buttons on an internet explorer page? (0 replies)
  41. Userform Read only to Read/Write (4 replies)
  42. How to show the last row in this code (0 replies)
  43. Best way for deploy excel with .net dll reference (0 replies)
  44. [SOLVED:] Cut and past a selected row to another worksheet (2 replies)
  45. [SOLVED:] VBA to create a folder and move (8 replies)
  46. [SOLVED:] Dynamically adding check boxes based on worksheet name, updating error (1 replies)
  47. Get row of Checkboxes (7 replies)
  48. Intermittent issue with a UDF, Google address extractor. (0 replies)
  49. Formula on MS Exel sheet Vlookup ,H_lookup , For Entropy and enthalphy (0 replies)
  50. Array Problem (Swapping array value based on determined row) (1 replies)
  51. [SOLVED:] Find ALL cells containing multiple words then display a corresponding cell (6 replies)
  52. Issues with using autofill in vb macro (1 replies)
  53. excel vba (0 replies)
  54. [SOLVED:] When Ranks change in a Range (5 replies)
  55. innerHTML not returned? (2 replies)
  56. [SOLVED:] Loop to find cell, then using that cell reference to clear a range (12 replies)
  57. Accessing File Properties in an audio file (2 replies)
  58. How to unhide a sheet - xlveryhidden (1 replies)
  59. Sub or Function not defined compile error help (11 replies)
  60. [SOLVED:] copy data between worksheets based on list selection (4 replies)
  61. Userform | write new row for ComboBox and TextBox entries ONLY when user adds content (2 replies)
  62. [SOLVED:] Using form control checkboxes to clear ranges on other pages- VBA Excel (3 replies)
  63. Open several files from list of paths (2 replies)
  64. Combine multiple pdf files into one file using Excel (1 replies)
  65. VBA Code - Referencing to a Different Sheet (9 replies)
  66. Add a cell reference in newly created worksheets created by VBA indexed by row (2 replies)
  67. [SOLVED:] If Column A ıs Empty and if Column I has a data copy them to Column A .. (3 replies)
  68. VBA help - not sure which getelement to use for scraping website (0 replies)
  69. [SOLVED:] Delete a filtered auxiliary column while maintaining the filtered range. (6 replies)
  70. [SOLVED:] Export Sheets as CSV and Keep Workbook Open (2 replies)
  71. [SOLVED:] Insert Values into - Offset Cells Array (4 replies)
  72. Search multiple values in column A and create sheets based on value name (8 replies)
  73. Macro For Printing Labels (1 replies)
  74. Quick Question About XlDown (3 replies)
  75. Copy/Paste/Rename values between two workbooks if certain conditions are met (2 replies)
  76. [SOLVED:] Counting The item that separate by | character (2 replies)
  77. Track Changes not working properly (3 replies)
  78. Generating a checkbox corresponding to the each worksheet on click (3 replies)
  79. Adding or deleting rows from Table depending of data (1 replies)
  80. Add a cell reference in newly created worksheets created by VBA indexed by row (0 replies)
  81. Lookup or match (1 replies)
  82. Runtime 1004 Error SaveAs Workbook Failed (3 replies)
  83. Copying data from one worksheet to another base on the header name. (1 replies)
  84. Sending emails with data from cells (including bcc) (2 replies)
  85. Simple Copy and Update Cell Value Every Minute (23 replies)
  86. [SOLVED:] Userform for Project closing (4 replies)
  87. [SOLVED:] Count Rows From Specific Column - Row Number (2 replies)
  88. Auto-Size Pasted Picture/Snippet to Fit Cell Height and Width (2 replies)
  89. Excel VBA Seek Error Solution (4 replies)
  90. Excel VBA: Format and change cell value based on specific values in cell (0 replies)
  91. Formula Evaluation In Excel (3 replies)
  92. Excel file only to open on designated computers (1 replies)
  93. Copying Rows based on two columns having matching data (0 replies)
  94. how to further divide out how this is saved? (0 replies)
  95. Help with filling out webform from excel sheet (0 replies)
  96. How to increment a column with a selected range (8 replies)
  97. VBA Code that deletes entire row if "Received" is selected from Drop-Down List (1 replies)
  98. [SOLVED:] Save to Network drive using UNC format (2 replies)
  99. How can I get my second range to transfer as an offset? (5 replies)
  100. [SOLVED:] Transpose Data In Columns (3 replies)
  101. [SOLVED:] Matching 2 columns (2 replies)
  102. [SOLVED:] Issuing retrieving an "hour value" from worksheet using VBA (2 replies)
  103. Range setting for sort (2 replies)
  104. Deleting cell contents based on a partial formula. (2 replies)
  105. [SOLVED:] Match Overlap Date Range and multiple criteria - Need to match extra criteria (4 replies)
  106. Copy several cells into one cell (0 replies)
  107. Find and format only specific text/numbers (0 replies)
  108. VBA Convert textnumber to number format (1 replies)
  109. Converting columns to rows (6 replies)
  110. [SOLVED:] Conditional Formatting range selection (2 replies)
  111. [SOLVED:] Copying data with changing rows. (5 replies)
  112. Named Range Help - Excel 2013 (1 replies)
  113. Vba data for chart (4 replies)
  114. Select Multiple entry and remove in dropodown in excel vba (1 replies)
  115. [SOLVED:] intersect range and table.listcolumn - need to find if cell is in table column (1 replies)
  116. Copy Columns in Selected Sheets to a New Table with the data (1 replies)
  117. Can't get my code to offset (1 replies)
  118. Excel Formula/Macro: Fetch data from multiple rows and columns with a single key (1 replies)
  119. Google Maps Static API in Excel (0 replies)
  120. Duplicate entire workbook into 3 copies and leave only specific sheets in the copies (1 replies)
  121. VBA code. Copy certain cells with a number of conditions (1 replies)
  122. [SOLVED:] VBA Code needed to insert rows based on pricepoints (5 replies)
  123. 1 Email, Multiple Recipients, No Duplicates (0 replies)
  124. Importing data from multiple files by VBA (8 replies)
  125. VBA is it possible to use a integer like function with cells (1 replies)
  126. Grade calculator this should be easy fix (4 replies)
  127. VBA IE automation: error on getting iframe (0 replies)
  128. [SOLVED:] Loop to match headers on separate sheets, copy and paste revisited (3 replies)
  129. Form Controls Reset to Default on Worksheet (0 replies)
  130. Extracting data from .txt file to excel using vba (0 replies)
  131. Shorten (0 replies)
  132. Insert the different picture into all worksheets (1 replies)
  133. Formula with named ranges not working (8 replies)
  134. Divide number under certain conditions (11 replies)
  135. Splitting Uneven Text Strings (2 replies)
  136. Lookup and return Names for Duplicate Orders (3 replies)
  137. Help with VBA Code (2 replies)
  138. [SOLVED:] Delete row if cell entries in 4 columns match (12 replies)
  139. help with select case (3 replies)
  140. Delete duplicates based on partial match (4 replies)
  141. VBA Assistance Needed (1 replies)
  142. create and print files automatically (1 replies)
  143. [SOLVED:] VBA changes "Rows" to "rows" (3 replies)
  144. VBA Print area problem (1 replies)
  145. VBA Set File path to a cell reference in the workbook (6 replies)
  146. VBA to Auto-populate the Sheet "Protect" password field(s) (0 replies)
  147. [SOLVED:] Radar Scoring (4 replies)
  148. Help with VBA code to copy formatting into clipboard (7 replies)
  149. VBA Error handling (7 replies)
  150. search for a string in a column on a different worksheet (1 replies)
  151. Excel VBA Don't show Sampling - Output range will overwrite existing data (2 replies)
  152. VBA - copy specific cells with criteria to multiple workbooks (get filename from cell (3 replies)
  153. [SOLVED:] VBA copy from a variable sheet (8 replies)
  154. Excel 2010 / VBA/ problem with code to create listbox in userform (2 replies)
  155. VBA to extract & combine data from multiple excel file from a specific folder (0 replies)
  156. VBA Macro To Scan Headers and Paste Them Into Specific Column On Master Template (4 replies)
  157. opening 2010 file in VBA (2 replies)
  158. EDITTING THE LIST FROM COMBOX AND CHANGE TO NEW VALUE (0 replies)
  159. VBA Help to Reverse a String without StrReverse function (6 replies)
  160. Repeat VBA code for each cell (5 replies)
  161. VBA program to find the number 15 (5 replies)
  162. Split Data in Column A into Separate Workbooks (1 replies)
  163. Message in cell when criteria is met (2 replies)
  164. CONDITIONAL FORMATING IF CELL HAS ROUND FORMULA (5 replies)
  165. [SOLVED:] Delete after coma when spicify workd does not exists (5 replies)
  166. forgot the password of Excel (1 replies)
  167. Adding to a Cell Which Time Decays (30 replies)
  168. Loop through folder to fill a table (2 replies)
  169. Excel VBA attaching print area as PDF (1 replies)
  170. Protect & Unprotect Sheet in AutoCall Macro (3 replies)
  171. [SOLVED:] How to Reference a String in a Cell (2 replies)
  172. Develop VBA program to find and divide numbers (0 replies)
  173. [SOLVED:] Replacing a Date Extracted From a String (1 replies)
  174. Excel file open by specific ID number (4 replies)
  175. [SOLVED:] Next without For error (2 replies)
  176. Excel VBA macro to paste values (1 replies)
  177. Bring picture to front (1 replies)
  178. Sports scheduling helper (1 replies)
  179. Jumping to intermittent last cells in a column (6 replies)
  180. [SOLVED:] Export data to workbook with criteria with few selected columns(not all rows) (1 replies)
  181. Converting a logic in R to Excel VBA (0 replies)
  182. Only FOR JULY (07-01-18 to 07-31-18 ) as per formula available in cell (1 replies)
  183. Copy rows to new tab based on column value (0 replies)
  184. [SOLVED:] Macro not finding next available blank line (5 replies)
  185. Time delay Stock Data (0 replies)
  186. [SOLVED:] VBA Makro Load Data from Website with Java Script (0 replies)
  187. [SOLVED:] Updating PT Slicers is Causing Macro to Fail (1 replies)
  188. Checking format of a selected Range (0 replies)
  189. Angle of a trend line (2 replies)
  190. If statement to copy data to correct row (5 replies)
  191. Need Help VBA Find Certain Value (0 replies)
  192. [SOLVED:] requesting help on restructuring code to work on extracting data w. int color red (4 replies)
  193. Need to build a macro with the following logic. Don't know how to start! (1 replies)
  194. Preventing closing a workbook (8 replies)
  195. complex slicer (8 replies)
  196. Macro does not copy to the next row on the destination sheet (1 replies)
  197. Counting Consecutive numbers > 100 in a column by multiple criteria (0 replies)
  198. [SOLVED:] Getting last modified date shown in footer and cell (0 replies)
  199. need help leaning or restructuring macro for highlighighting duplicates on large data (5 replies)
  200. Creating automatic chart using other sheet's data? (1 replies)
  201. Adding Slide in Powerpoint via Excel VBA (0 replies)
  202. How to store an embedded wave file into a variable (1 replies)
  203. Overview values pivot table (8 replies)
  204. Change code to include range of cells (0 replies)
  205. Creating CAD files using Excel. (2 replies)
  206. [SOLVED:] Create x,y points from mouse clicks (6 replies)
  207. Automatically save on insert/modify cell data. (5 replies)
  208. Macros not enabled etc. Runtime Error 1004 (2 replies)
  209. [SOLVED:] Need help with highlighting duplicates of data in 3 columns, Please (2 replies)
  210. Copy Sheet From file to workbook, and save it as origin name in different file (1 replies)
  211. Option Enabled Search (4 replies)
  212. [SOLVED:] I Need help to reconstruct code to add to existing code, please (4 replies)
  213. Highlighting cells that contain specific characters with VBA (3 replies)
  214. [SOLVED:] Conditional Data Validation issue (1 replies)
  215. Insert and Delete rows based on value (1 replies)
  216. [SOLVED:] vba conditional formatting - compare range of adjacent cells (2 replies)
  217. [SOLVED:] expand and complete series excel (2 replies)
  218. Inserting Multiple Rows in Excel based on cell selection (1 replies)
  219. vba help to shorten the my code... (7 replies)
  220. Need to Match two or more rows values based on their ID in another cell (0 replies)
  221. Cancel querytable.refresh (2 replies)
  222. Floating point question, exactness of integers (0 replies)
  223. [SOLVED:] Trying to Make Macros Run More Efficiently (11 replies)
  224. [SOLVED:] Excel Calculation issues with UDF (3 replies)
  225. Combine 2 sheets into 1 PDF file (3 replies)
  226. [SOLVED:] inputbox coding for invalid selection(s) - column (2 replies)
  227. [SOLVED:] Automatically enter the value of a formula in adjacent cell (5 replies)
  228. Not able to use the find command in vba ,Please help (6 replies)
  229. Download and extract zip file, and open file in it (15 replies)
  230. Dependent Combo Box in userform (1 replies)
  231. Help with production counter in VBA (1 replies)
  232. problem with api call (0 replies)
  233. Format Object (2 replies)
  234. VBA with a lot of condition statement (3 replies)
  235. Renaming a closed excel file by info in it, Excel VBA (0 replies)
  236. Expanding between two dates (start and end) along with other information (1 replies)
  237. Creating comma separated list from multiple columns (3 replies)
  238. VBA: Workbook won't open until the macro is completely finished (1 replies)
  239. VBA reset all pages in multipage (4 replies)
  240. Auto filling data w/ VBA (0 replies)
  241. Modify Macro to have sheets added in particular order (15 replies)
  242. modify vba code (1 replies)
  243. Search for number in another Excel file and get adjacent cell (0 replies)
  244. search for words or symbols in files (2 replies)
  245. Facing Run-time error-13 "Type Mismatch" while edit and update user (3 replies)
  246. Urgent help needed - "Runtime error 9: subscript out of range" (6 replies)
  247. Compare and replace- English and French Translation- Optimization. (4 replies)
  248. [SOLVED:] Conditional Formating Issue (3 replies)
  249. Copy data from Pivot table(except headings) to a new tab using VBA (1 replies)
  250. Clearing a Shape from a Chart (0 replies)