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. Macro to copy row, base in condition, into the botton of the table (0 replies)
  2. For...Each + Merging Cells Leading to Error 2042 (Type Mismatch)? (1 replies)
  3. Help subtracting sales from order (5 replies)
  4. [SOLVED:] Type Mismatch Error (2 replies)
  5. [SOLVED:] Can someone tell me why this doesn't work. (3 replies)
  6. How to amend this code in order to copy the inserted comment also? (5 replies)
  7. Excel Error when arguments with multiple parameters are passed (1 replies)
  8. How to extract specified data to the other worksheet? (2 replies)
  9. Copy Data without Activating a Tab (3 replies)
  10. [SOLVED:] Dynamically call function in sheet's VBA module (4 replies)
  11. VBA - Consolidating information from one sheet from multiple workbooks in the same ma (2 replies)
  12. [SOLVED:] Error 1004 (11 replies)
  13. [SOLVED:] VBA question on counters (3 replies)
  14. [SOLVED:] Reposition cursor in cell that contains the error (7 replies)
  15. [SOLVED:] Default to current date in textbox (3 replies)
  16. [SOLVED:] Copying entire row from Sheet1 to Sheet2 if values in multiple cells matches (2 replies)
  17. [SOLVED:] Last User Save (2 replies)
  18. Limiting User Entry on A Userform Combobox NOT working (6 replies)
  19. Not enough memory + Excel 2016 (11 replies)
  20. Pasting the contents from one sheet to a row after the last active row on another (3 replies)
  21. [SOLVED:] Replace certain cells in rows with values from same rows but in different column (2 replies)
  22. [SOLVED:] Setting a found item to a Variable (7 replies)
  23. [SOLVED:] "Run-time error '1004' on code to remove the ellipsis (...) character from a column (10 replies)
  24. [SOLVED:] How to find which columns are being used in active chart (3 replies)
  25. [SOLVED:] Need Some Help with SumProduct (7 replies)
  26. disable cells DataValidation (3 replies)
  27. Two Workbooks - Search for Values in Workbook 2, Copy and Paste in Workbook 1 (0 replies)
  28. [SOLVED:] Create a new sheet / workbook for all Unique values (Including Pictures / Images) (4 replies)
  29. Making a leave tracker with VBA (5 replies)
  30. AverageIfs Dynamic Formula -Criteria Not Working? (3 replies)
  31. Everytime I open my excel file open this file as new excel instance (3 replies)
  32. Select added value from dropdown menu, program output (1 replies)
  33. [SOLVED:] Got Excel< 2007? Test if "Action Will Reset Project" (5 replies)
  34. Index / Match / and search for result between two dates and a little bit more complex (2 replies)
  35. Excel custom data validation with drop down list (7 replies)
  36. VBA Loop help (Error Loop without Do) (5 replies)
  37. [SOLVED:] Grab data between two dates using arrays (7 replies)
  38. VBA (3 replies)
  39. VBA (1 replies)
  40. paste special values for multiple pivots (1 replies)
  41. Compare if any changes then highlight (12 replies)
  42. [SOLVED:] Average values within time range for matching header (8 replies)
  43. [SOLVED:] Formula to calculate AVERAGE but only to last used row in a grid. (3 replies)
  44. VBA auto outlook 2016 to send e-mail based off criteria (0 replies)
  45. ComboBox change for multiple comboboxes (4 replies)
  46. [SOLVED:] duplicating range (4 replies)
  47. Modify VBA code for Advanced Filtering (10 replies)
  48. Simplifying and looping VBA (2 replies)
  49. VBA to search in sheet1, match data in sheet2, return search results in sheet1 (14 replies)
  50. [SOLVED:] Copy values only not the formats. (4 replies)
  51. Object required (Error 424) (5 replies)
  52. Concatenate Multiple Cells (19 replies)
  53. [SOLVED:] Copy sheet and paste values - VBA (1 replies)
  54. [SOLVED:] Combine two arguments into one. (6 replies)
  55. [SOLVED:] Fill Series of Sequential Numbers in Column A Based on Last Value in Column B - VBA (1 replies)
  56. Code error 9. Create a workbook and worksheets in relation with variables (2 replies)
  57. Using different Range in the body of email based on row criteria - Appointments (11 replies)
  58. disable close "X" button (4 replies)
  59. ThisWorkbook.SaveAs fails at second attempt (20 replies)
  60. [SOLVED:] How to reuse variable value across Private modules (7 replies)
  61. userform menu problem (3 replies)
  62. [SOLVED:] Linking Label Caption To Textbox (11 replies)
  63. path string in cell (5 replies)
  64. [SOLVED:] A text box in excel that contains a Picture taken from a file (3 replies)
  65. Convert table of contents to another format (5 replies)
  66. run msgox at certain times of the day only if a specific workbook is still open (1 replies)
  67. VBA select/send email based off criteria (2 replies)
  68. How to check for conflicts in a schedule? (0 replies)
  69. Can't get code to loop through worksheets (4 replies)
  70. VBA code to lock the active sheet (2 replies)
  71. Time of creation of shape (4 replies)
  72. Active X component cant create object (2 replies)
  73. [SOLVED:] Find unique records between 2 sheets and delete (3 replies)
  74. WORKDAY #VALUE ERROR (2 replies)
  75. Range not selecting correctly? (2 replies)
  76. Read outlook emails copy to excel. (9 replies)
  77. Run "x" number of random draws and calculate totals against a pre-defined set. (1 replies)
  78. Delete duplicate rows if they do not contain a specific word (5 replies)
  79. Compare 2 different excel sheets (3 replies)
  80. [SOLVED:] VBA Celloffset function in For Each Cell function not work (4 replies)
  81. For loop delete entire row if cell is blank (1 replies)
  82. Looping to find difference in time within string (5 replies)
  83. Copy Worksheet to another Workbook - VBA (2 replies)
  84. [SOLVED:] Help Loop and Count if more than one unique (2 replies)
  85. [SOLVED:] Combine worksheets and move row and columns (0 replies)
  86. [SOLVED:] Left & Copy (3 replies)
  87. small logic is missing (auto mail) (1 replies)
  88. Cumulative sum based on a condition (2 replies)
  89. [SOLVED:] If Cell is Highlighted -> Copy Row and Paste in Sheet2 (9 replies)
  90. Extracting the URLs from a tweet (18 replies)
  91. [SOLVED:] Delete row if it contains a certain word or phrase - and use array (2 replies)
  92. [SOLVED:] Compare two lists of numbers (3 replies)
  93. Get multiple values from sheet and assign to textboxes (1 replies)
  94. [SOLVED:] VBA Code to Match US Region to the State that is entered (61 replies)
  95. Problem with Folder Picker (4 replies)
  96. Data Merge - Identify Rows Not Pulled Over from Sheet2 into Sheet1 - VBA (1 replies)
  97. VBA code to subtract the time diferences in the userform. (5 replies)
  98. Path/File Access Error - Replacing text in xml with text from excel (0 replies)
  99. Corrupt data in workbook? (2 replies)
  100. [SOLVED:] Template SaveAs on First Open (1 replies)
  101. How to check if a cell contains something or not (4 replies)
  102. [SOLVED:] Filtering unique data & Remove duplicate rows & save unique record range in new book (14 replies)
  103. Pls correct my code (sending mails) (5 replies)
  104. Nested Loop to create multiple series in a single chart. Where did I go wrong?? (4 replies)
  105. [SOLVED:] Time Rounding VBA (Custom Function?) (10 replies)
  106. Some last problems with barcode prog. ' SetFocus, Barcode Length ,Autosave' (6 replies)
  107. Macro to create new sheets when master is updated (4 replies)
  108. Copy Used Row (1 replies)
  109. Help Needed: Picking Shortage Corresponding Date (0 replies)
  110. [SLEEPER:] VBA Books/Courses For A Novice (4 replies)
  111. [SOLVED:] Code To Save Worksheets As Individual .txt But Only The First 9 Columns Of Each sheet (6 replies)
  112. new logic need to add to the code (1 replies)
  113. Filtering out a specific range and pasting it a row below (3 replies)
  114. ListBox on Userform doesn't refresh (3 replies)
  115. VBA help (1 replies)
  116. [SOLVED:] Filling in blank cells with data from another workbook - VBA (7 replies)
  117. Matching multiple values from different column (1 replies)
  118. Toggle to Hide Rows (2 replies)
  119. [SOLVED:] VBA Paste As Values (3 replies)
  120. Moved: VBA: Picture in Word-Header? Position? (2 replies)
  121. Merging columns (2 replies)
  122. Select Case Function on a CommandButton/ToggleButton (4 replies)
  123. Retrieve value based on selection (1 replies)
  124. Data validation (1 replies)
  125. [SOLVED:] Combining two sets of data into one - vlookup, comparing part numbers - advanced VBA (3 replies)
  126. Multiple column select in VBA (6 replies)
  127. [SOLVED:] QR-reader to Excel (with time stamp) (6 replies)
  128. Vba help for a lookup table (1 replies)
  129. Help VBA using excel function help (2 replies)
  130. Removing duplicates from multiple columns (23 replies)
  131. [SOLVED:] VBA - Extracting 3 Text Lines From Text files (26 replies)
  132. hide and protected sheet macro not working (2 replies)
  133. [SLEEPER:] Vba one to one and many highlighted (0 replies)
  134. [SOLVED:] Start Loop Rows From - Row 10 on wards - Listing Files (8 replies)
  135. obtain distinct rows based on three columns (2 replies)
  136. [SOLVED:] Delete any row which does not have any cells which are conditionally formatted (11 replies)
  137. VBA code to sort, compare, and line up two lists of data. (1 replies)
  138. Need help reconstructing macros on this file in my description please!!! (5 replies)
  139. [SOLVED:] Declared Variable not selecting the correct range (8 replies)
  140. Copy down text in columns until next part number - VBA Code (5 replies)
  141. Sum if Index Match with multiple criteria (6 replies)
  142. Help with duplicate matches when using Index(Match( (0 replies)
  143. avoid iterations (0 replies)
  144. Loop for certain text in cell - delete cells and shift up (3 replies)
  145. [SOLVED:] SPLIT STRING issue with array if element not found (10 replies)
  146. how do I save as .xlsx using xcell compiler (5 replies)
  147. create workbooks based on a given template using data in a table (2 replies)
  148. [SOLVED:] Need Help constructing a vba counts rows between data and. Please (3 replies)
  149. [SOLVED:] Why is "1D050" numeric? (6 replies)
  150. [SOLVED:] Returning Description Based on Field Value (2 replies)
  151. [SOLVED:] Looping For Duplicates In 2 Dynamic Columns (Odd Issue) (4 replies)
  152. [SOLVED:] Exporting Worksheet Code Modules - Export Code As Worksheet Name (8 replies)
  153. Data Validation (4 replies)
  154. VBA help to convert unstructure data to structured data (0 replies)
  155. [SOLVED:] Add 1 row below a selected cell using a user input box (3 replies)
  156. i want to validate users entered value with existing range in another sheet (1 replies)
  157. [SOLVED:] Search with Criteria on Userform (1 replies)
  158. Rename Current PDF file name using Excel Sheet List (2 replies)
  159. Random Sequencing (8 replies)
  160. Learning VBA Variables (2 replies)
  161. Email alert not firing with VBA even though the condition is satisfied. (3 replies)
  162. Copy and pasting time calculations (1 replies)
  163. Formula working wrong, I can't identify why. (0 replies)
  164. VBA: Help me write a code in vba (5 replies)
  165. Make userform stay on top of all windows when macro is fired (22 replies)
  166. [SOLVED:] trying to pull dynamic webquery data (1 replies)
  167. Syntax for Evaluate SumProduct in VBA (6 replies)
  168. trying to finish my vbaproject barcodescanner (25 replies)
  169. Help me to correct the vba (2 replies)
  170. Drag Drop Reorder part of Row .. Excel (1 replies)
  171. Logging other PC programs via VBA excel (1 replies)
  172. Update data entry for all future months (not a single month) (0 replies)
  173. Copy Leading Numeric Values, then Remove (7 replies)
  174. The BIG DATA Challenge - Match cells on BIG DATA Sheet (LOOP take 4 Hrs !) (27 replies)
  175. Problem in Executing the Code (4 replies)
  176. [SOLVED:] Create multidimensional array from several non adjacent table columns (3 replies)
  177. [SOLVED:] Split files and attach them to an email (0 replies)
  178. Open multiple password protected workbooks in a folder (4 replies)
  179. Adding Code to Workbook_BeforeOpen (7 replies)
  180. [SOLVED:] Find a Value in a Cell and Delete some of the text (2 replies)
  181. Concat date and time in one cell (1 replies)
  182. Open workbook with dynamic filename (8 replies)
  183. [SOLVED:] Conditional Compile Question (11 replies)
  184. [SOLVED:] Forms 2.0 library (9 replies)
  185. VBA code disaappeared. (4 replies)
  186. "MSACCESS.EXE" process issue - How to terminate this process correctly (2 replies)
  187. [SOLVED:] Find Text Within A String (4 replies)
  188. [SOLVED:] Find and replace (9 replies)
  189. [SOLVED:] Group Shapes Rename Them - Loop Through Worksheets (1 replies)
  190. [SOLVED:] VBA to create a mapping (0 replies)
  191. Need help with this macro to have it work with Alpha Numeric data (2 replies)
  192. [SOLVED:] Assign Shape Macros - From List (2 replies)
  193. Data Formating - Macro to copy header row and paste to multiple columns. (1 replies)
  194. Help me insert subtotals on I:L my vba code below. It sorts and insets a blank row (0 replies)
  195. Run-time error '462': The remote server machine does not exist or is unavailable (0 replies)
  196. Ping tester in Excal (2 replies)
  197. SUMPRODUCT in VBA (7 replies)
  198. [SOLVED:] Add shape only if shape doesn't already exist (1 replies)
  199. [SOLVED:] Remove Apostrophe from string (4 replies)
  200. [SOLVED:] Macro to create list of hyperlinks to all files in chosen folder including subfolders (8 replies)
  201. [SOLVED:] On Open: "This action will reset your project, proceed anyway?" (26 replies)
  202. [SOLVED:] Trouble using selected range to define a for loop (3 replies)
  203. [SOLVED:] Unhide Worksheet on Selection of Cell (2 replies)
  204. [SOLVED:] Code to match to cells using a mapping (3 replies)
  205. Delete rows except the last one with same numerical value (1 replies)
  206. [SLEEPER:] Codigo VBA para fecha matar o arquivo temporário. (0 replies)
  207. Can VBA be used to search a folder of .docx's for text strings and copypaste to Excel (1 replies)
  208. [SOLVED:] Left Right Function Help (4 replies)
  209. Google map Travel Planner #1 (0 replies)
  210. [SOLVED:] Match and Vlookup method (3 replies)
  211. [SOLVED:] Run-time error 91 (4 replies)
  212. Trying to extract all data from word docs into excel docs (0 replies)
  213. VBA Express Certification? (0 replies)
  214. [SOLVED:] Identify column header name based on a colored cell (6 replies)
  215. Copy data from one sheet to another based on a certain criteria (1 replies)
  216. [SOLVED:] How to get Last Digit from Text (3 replies)
  217. How to conjuct all the excel value into one cell? (1 replies)
  218. [SLEEPER:] Convert Vlookup to VBA (22 replies)
  219. Hyperlink Issue (2 replies)
  220. Resetting Dropdown list in all sheets (Excel Workbook) (0 replies)
  221. [SOLVED:] How to check whether Cells contains specific number? (3 replies)
  222. Stopping or breaking userform or code causes VBA to flip through all userforms (0 replies)
  223. Match two rows across various columns using VBA (2 replies)
  224. Hitro Macors (3 replies)
  225. Generate random values between two number and specific string (1 replies)
  226. VB script to filter and update value in different sheet (2 replies)
  227. [SLEEPER:] Embed an "open file" dialogue box to userform, Excel 64 bit version (5 replies)
  228. Copy line by index number and past in another worksheet (0 replies)
  229. Copy select data to different column (1 replies)
  230. Stock Length Calculator (0 replies)
  231. [SOLVED:] Require VBA Macro logic for Multiple ID and Matching Columns data. (9 replies)
  232. [SOLVED:] Match two rows using VBA (1 replies)
  233. [SOLVED:] UDF to convert column Letter to Number and return the Largest column as Number (4 replies)
  234. Macro to conditionally insert rows not functioning as intended (1 replies)
  235. [SOLVED:] Send attachment via outlook (2 replies)
  236. [SOLVED:] Combo box filtering? (3 replies)
  237. Copy select data on USERFORM (1 replies)
  238. Why data labels gone when i paste the chart to other workbook and change the range? (0 replies)
  239. Validation Tool- Lookup for Mis-Match and send email out (0 replies)
  240. Need help with a VBA code for distributing data (3 replies)
  241. Workbook Password Protect (10 replies)
  242. Open Images Folder Mac OSX (0 replies)
  243. [SOLVED:] Hide rows between 2 strings (3 replies)
  244. [SOLVED:] Fix calculation of minimum date (1 replies)
  245. Pivot > Showall data in rows field (1 replies)
  246. Excel File-1 copy the value & compare with Excel File-2 and Save it in Excel File-1 ? (0 replies)
  247. VBA Command button (20 replies)
  248. Need VBA Code to close userform (6 replies)
  249. Sleeper: Help with combining these macro snippets? (3 replies)
  250. [SOLVED:] Using Workbook from FilePicker (4 replies)