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. Transfer Data from one sheet to another sheet to create invoices (3 replies)
  2. Userform Listbox Search Function (9 replies)
  3. HTML Scraping (1 replies)
  4. How to insert a specific row from my sheet, into the email-body using VBA-Excel (1 replies)
  5. Update the Master Workbook from the Copy. (2 replies)
  6. Runtime error 438 (6 replies)
  7. [SOLVED:] Problem with Range().EntireRow.Insert when creating insertRow sub (4 replies)
  8. Date calculation and formula (2 replies)
  9. VBA - change color with double click and count cells based on color (0 replies)
  10. [SOLVED:] Placing comma separated values into the corresponding cell (2 replies)
  11. [SLEEPER:] Can you query a RECORDSET using SQL (4 replies)
  12. [SOLVED:] How To Load Macro onto Exported Excel Sheet (6 replies)
  13. [SOLVED:] PDF from a macro in excel (3 replies)
  14. [SOLVED:] VBA: Detect if the webpage on Internet Explorer is loaded (4 replies)
  15. [SOLVED:] inputbox vba problem (1 replies)
  16. VBA to replace text in a single column (1 replies)
  17. Impossible to trigger a value input in a menu with VBA (javascript) (0 replies)
  18. How Many Coctail With Fruit From İnventory(most effective ways) (0 replies)
  19. [SOLVED:] Excel VB to hide an entire row based on sheet name match and cell dynamically. (4 replies)
  20. Getting “Type Mismatch” with VBA PivotTables and Filter Dates (0 replies)
  21. VBA code errors for exporting sheets as individual PDFs (3 replies)
  22. [SOLVED:] Increment number sequence by two conditions (4 replies)
  23. Dlookup only works when Access is open (0 replies)
  24. Cntl+. macro ? (1 replies)
  25. Send Notes Mail out of Excel with monospaced body (0 replies)
  26. [SOLVED:] How to copy and paste only bold parts of string and not unbold parts of string? (2 replies)
  27. Code to hide row if no value (9 replies)
  28. problem getting internet values (0 replies)
  29. VBA Textbox get last entry from time stamp (1 replies)
  30. Complex VBA - Trying to use specific online calculator and download data to excel (0 replies)
  31. [SOLVED:] Error - Duplicate record after filtering n the Header can't be copied to new workbook (2 replies)
  32. Extract data from the outlook mail which has attached excel file (2 replies)
  33. [SOLVED:] Import .csv file (7 replies)
  34. [SOLVED:] Compare 2 Sheet and by 2 column and compare date get the value on sheet 1 (2 replies)
  35. [SOLVED:] Auto Fill Next Blank Cell in a Row with Value from the Row Above (3 replies)
  36. VBA not to show excel file, excel logo, excel ico but only show a User form (3 replies)
  37. VBA code to print unique values and corresponding values from the other coloumn (1 replies)
  38. Multipage: When I change the page the date changes. (1 replies)
  39. VBA code help 2016 (3 replies)
  40. After uppdating cell excel jumps to other sheet (1 replies)
  41. [SOLVED:] Find all cells with certain value and delete the whole row (8 replies)
  42. [SOLVED:] change from vba code (const as date) to (cell.value in worksheet) (0 replies)
  43. Counting Number of Colors in a sheet (not Number of Colored cells) (3 replies)
  44. [SOLVED:] If E and F is empy paste to column (2 replies)
  45. [SOLVED:] Merge specific worksheet from multiple workbooks into a single worksheet (8 replies)
  46. [SOLVED:] Send e-mail with multiple range in body of e-mail (4 replies)
  47. VBA code to delete contents of one cell based on change in another (1 replies)
  48. VBA Code help - Search files within folders and return file name and path (1 replies)
  49. VBA code to seend seperate sheets as PDF to seperate emails (8 replies)
  50. Logic to pull directory, two tabs and transpose data (1 replies)
  51. How to create a dynamic range for vlookup based on active cell (1 replies)
  52. SUM IFS CONDITION COMPLEX SCENARIO (7 replies)
  53. Amalgamating and texting (1 replies)
  54. VBA FOR TWO INTERACTING DATA VLAIDATION DROPDOWNS (1 replies)
  55. [SOLVED:] Underline specific text in shape caption. (Excel 2013) (2 replies)
  56. Convert Row Range formula result to Value (1 replies)
  57. Excel VBA Highlighting dates in a range which match a date from an inputbox (1 replies)
  58. sending email with multiple attachments (4 replies)
  59. Pass Chart Data Point number to variable (1 replies)
  60. Run-Time Error 53 File not found (2 replies)
  61. [SOLVED:] VBA to send 1 email containing all attachments (2 replies)
  62. Problem in automating form filling web page. (0 replies)
  63. #1 VBA to sort data from multiple worksheets into a worksheet (same workbook) (4 replies)
  64. [SOLVED:] Conditional Formatting Help (6 replies)
  65. excel - search for document and open (2 replies)
  66. Userform too much loaded (7 replies)
  67. [SOLVED:] Class Event for ComboBox Enter (Excel 2013) (3 replies)
  68. [SOLVED:] Quick VBA find question (2 replies)
  69. [SOLVED:] ListBox - PreSelect Values (3 replies)
  70. Help with VBA to send email to several recipients listed in different columsn (4 replies)
  71. Please Help !!! Copy particular columns from one file to master file with condition (5 replies)
  72. Extract URL with the hashtag # (2 replies)
  73. Sheets change every few seconds in a loop (19 replies)
  74. [SOLVED:] Run Macro only if selected by left click (4 replies)
  75. Count Highlighted Cells In Each Column (3 replies)
  76. Autofilter, copy, paste to new file (11 replies)
  77. [SOLVED:] Find values in a range then copy and paste data to different column (2 replies)
  78. [SOLVED:] Sum on the basis of mutiple criteria (7 replies)
  79. Moving Files & Folders by Last Modified Date (14 replies)
  80. Copy text to cell from another sheet (5 replies)
  81. [SOLVED:] Start From Last Column - Sequential Number (2 replies)
  82. VLOOKUP VBA FORMULA (2 replies)
  83. Creating shapes and position them (3 replies)
  84. getting #N/D on function.transpose (8 replies)
  85. VBA - Removing a Sheet based on a condition (else a message box) (5 replies)
  86. [SOLVED:] Setfocus in Access form FROM within Excel ? (8 replies)
  87. Excel VB "Unprotect" workbook statement (4 replies)
  88. Rename Files (4 replies)
  89. Add string of text to a specific point in every cells (2 replies)
  90. Highlight Duplicates based on Different year in each row. (1 replies)
  91. Run-time eerror 424 (5 replies)
  92. [SOLVED:] Shapes Array (Excel 2013) (4 replies)
  93. Pivot > show all data (1 replies)
  94. Moving Folder to another Folder if name of folder and cell match (8 replies)
  95. VBA to email each sheet in a workbook (2 replies)
  96. [SOLVED:] Sort and spilit into column from one cell (5 replies)
  97. [SOLVED:] Ensure Selected Item in Listbox does not exist in Range (2 replies)
  98. Macros to copy from desirable worksheets to the same worksheets in another workbook (0 replies)
  99. pls help conditinal formating or vba (16 replies)
  100. [SOLVED:] Display Cell Contents - in ListBox (8 replies)
  101. [SOLVED:] Shape Fill Color Does Not Change (Excel 2013) (1 replies)
  102. Copy and past whole rows to a different tab based on two criteria (1 replies)
  103. [SOLVED:] color uppercase words (1 replies)
  104. [SOLVED:] Find and color text with Text List (1 replies)
  105. Array add dropdown Combobox for UserForm (3 replies)
  106. [SOLVED:] SIMPLE vertical timeline ... (16 replies)
  107. VBA help to compare 2 sheets and pick out duplicates (3 replies)
  108. VBA - Recursive Function modify Code - Output ERROR (10 replies)
  109. [SOLVED:] Sum on the basis of multiple creterias (4 replies)
  110. Can't get a loop to spit out individual files... (1 replies)
  111. my code is working.... almost (1 replies)
  112. [SOLVED:] Checkbox Loop (8 replies)
  113. Transpose Tables arranged horizontally to vertically (3 replies)
  114. [SOLVED:] VBA Code to copy data from one sheet to another based on date (3 replies)
  115. vlookup range in another sheet (9 replies)
  116. Export Multiple Sheets and Save As a new file (2 replies)
  117. Looking to Highlight Certain Phrases (4 replies)
  118. Transferring Data (1 replies)
  119. Checkbox to write values to multiple cells (6 replies)
  120. Data Retrieval (3 replies)
  121. VBA API Parsing and pasting json string to excel spreadsheet. run time 13 error (1 replies)
  122. [SOLVED:] Setting 1 range in 1 Workbook equal to another range in another workbook (3 replies)
  123. [SOLVED:] Sum of all months (3 replies)
  124. VBA Conditional Formatting Help (4 replies)
  125. ROW DUPLICATION WITH MULTIPLE VLOOKUP VALUES (1 replies)
  126. excel vba replace (7 replies)
  127. Loop based on count of serial number and fill formula (0 replies)
  128. VBA capturing screenshot (2 replies)
  129. vba algorithm (1 replies)
  130. to many line continuations during parsing (9 replies)
  131. compare 3 arrays. If uniqe in dimmesion (2,3,4) then check and copy to Tab1 or Tab3 (1 replies)
  132. Removing uncommon entries between two lists of names+data (3 replies)
  133. How to read values in custom tab of file properties dialog box in windows. (9 replies)
  134. VBA wait on VBScript to finish? (4 replies)
  135. VBA excel looping to subfolders outlook (1 replies)
  136. [SOLVED:] Change Mulitple Userform Label Backcolors (Excel 2013) (7 replies)
  137. [SOLVED:] Excel 2013 - How to check whether a chart series is selected (5 replies)
  138. [SOLVED:] help with understanding loops and multiplying integers (5 replies)
  139. I don't know what to do with message in Excel (4 replies)
  140. Test if active cell is within 2 separate unrelated ranges (2 replies)
  141. Copy specific data from a worksheet containing searchable comboboxes to another sheet (1 replies)
  142. Help Combining Two Private Sub's Into One (22 replies)
  143. List Box issue (2 replies)
  144. Excel recalculate everytime i write in a cell (1 replies)
  145. Advice for my prank code (6 replies)
  146. [SOLVED:] An Array of Sheet Names (6 replies)
  147. [SOLVED:] Loop and copy paste part numbers based on qty (5 replies)
  148. Shared Workbook Which Has 12 Worksheets (3 replies)
  149. VBA Code Updating Word Doc Bookmarks Data to Push New Data from Excel Cells (2 replies)
  150. VBA code for a routine process (4 replies)
  151. Outlook Calander Appointments With Excel (1 replies)
  152. Formula Help (4 replies)
  153. Filter - Copy - Paste (7 replies)
  154. Close Workbook After Idle (1 replies)
  155. Help with my code (Finding specific max values and applying it for other column) (0 replies)
  156. Change color of numeric characters (2 replies)
  157. To copy specific columns from a raw file to another workbook (2 replies)
  158. Help with VBA coding (4 replies)
  159. [SOLVED:] VBA Code to create a list of changes from a workbook. (8 replies)
  160. Send E-Mail via Macro if Workbook was saved and the was name changed aswell (5 replies)
  161. [SOLVED:] How to set loop for selecting columns and converting numbers stored as text (3 replies)
  162. time deduction (3 replies)
  163. Fill Internet Form (1 replies)
  164. static "fake" pivot table (1 replies)
  165. Refresh MS Query - Password Issue (1 replies)
  166. [SOLVED:] Custom sort with placeholders (5 replies)
  167. [SOLVED:] RE-ORDER and Inserting Columns of two Workbooks. (18 replies)
  168. VBA code for adding a new value in data range using user form (1 replies)
  169. INDEX MATCH with 2 range criteria in the same sheet (1 replies)
  170. Copying data from one sheet to another (6 replies)
  171. vba array /loop help (4 replies)
  172. [SOLVED:] VBA Macro to select and bring back a new campaign code (5 replies)
  173. Macro to Insert Objects from folders and move it to respective Sheets (3 replies)
  174. Infinite VBA Loop (16 replies)
  175. [SOLVED:] VBA help please (2 replies)
  176. [SOLVED:] VBA Before Double-Click Event executing when not desirable (5 replies)
  177. Variable x,y axis scales, series names and chart title (1 replies)
  178. Chart with Dynamic Row and Column Count Help needed (3 replies)
  179. Download Csv file from the Website VBA (0 replies)
  180. OptionButton LinkedCell trouble (8 replies)
  181. copy entire row from sheet1 into sheet2 if ID matches and column header should match (7 replies)
  182. [SOLVED:] Delete the value of cell that start by char with exception . (4 replies)
  183. [SOLVED:] Vba how to check workbook name first before opening it (2 replies)
  184. [SOLVED:] Random Numbers Looping Thru and Displaying Values (17 replies)
  185. Form created in worksheet, using macro to submit the info to second sheet (1 replies)
  186. Macro to open workbook copy data from workbook 1 and paste in workbook 2 and repeat. (5 replies)
  187. MultiPage - Run-time error 35788: (3 replies)
  188. Application.Goto not working in immediate window (2 replies)
  189. Split cells data in below rows with other data. (2 replies)
  190. VBA Combining Data from Multiple Workbook into One - Need help ASAP (2 replies)
  191. [SOLVED:] TMP file not found error when creating multiple workbooks in a loop (27 replies)
  192. [SLEEPER:] Makes bold a chosen word in a cell (8 replies)
  193. [SOLVED:] VBA Error run time 1004: Application-defined or object-defined error (6 replies)
  194. excel vba change cell color based on a number value in a range (3 replies)
  195. VBA to carry out Simpson's Rule for Tabulated (Equispaced) Data (2 replies)
  196. [SOLVED:] Show Random Numbers Looping on a UserForm (10 replies)
  197. Programming Scroll Button on Mouse (2 replies)
  198. [SOLVED:] TextBox - Named Range Dynamic Search (1 replies)
  199. Else without If Problem (22 replies)
  200. VBA Loop on Overly Coded Macro (14 replies)
  201. [SOLVED:] IF-ElseIF-Else macro seems to be disconnected (2 replies)
  202. File renaming (2 replies)
  203. [SOLVED:] Sorting by custom aplphabet (6 replies)
  204. code for sum function (0 replies)
  205. Data Tabulation (2 replies)
  206. Transferring Data between sheets to main record sheet. (2 replies)
  207. VLookup (0 replies)
  208. Excel Userform - how can I send an HTML email using data from the userform with image (0 replies)
  209. Conditional Formatting with Multiple Criteria (2 replies)
  210. SUMPRODUCT formula does not add up negative numbers. (0 replies)
  211. Market- making algorithm (2 replies)
  212. Excel Clarification (4 replies)
  213. Multiple Linear Progression, logging and VBA (35 replies)
  214. Same Userform, Different Lines (7 replies)
  215. VBA SQL Query from Cell (1 replies)
  216. [SOLVED:] VBA Dir and HTTP Directories Equivalent (10 replies)
  217. [SOLVED:] Consolidating data from multiple workbooks with varying ranges (3 replies)
  218. proper variable type (2 replies)
  219. Quick Question (hopefully) - Possible to create a front sheet for analysing data? (4 replies)
  220. Lock ComboBox/ MsgBox as Error (2 replies)
  221. counts ships between instances of picked number (4 replies)
  222. [SOLVED:] overflow error in range.find (7 replies)
  223. [SOLVED:] Hidden Object Range Failure in Worksheet Calculate (1 replies)
  224. Excel 2016 VBA Error 400 (4 replies)
  225. VBA to copy / autofill data, where am i going wrong? (1 replies)
  226. [SOLVED:] Deleting multiple cells based on value found (2 replies)
  227. [SOLVED:] Copy from Excel to Powerpoint to create a report (17 replies)
  228. VBA to email each sheet in a workbook (0 replies)
  229. [SOLVED:] if not found record after 1st criterial in Advanced Filter - then move to next if (1 replies)
  230. [SOLVED:] Help with solving a maze in VBA Excel (30 replies)
  231. [SOLVED:] How to DIM script itself? (7 replies)
  232. Prevent Blank Rows When applying filters (1 replies)
  233. [SOLVED:] Problem with Userform input to Worksheet (Excel 2013) (3 replies)
  234. VBA for AUDITING (1 replies)
  235. Help with date and time formats (6 replies)
  236. VBA to email each sheet in a workbook (2 replies)
  237. [SOLVED:] Brining in 2 inputs incrementally & 3 others from lists. (18 replies)
  238. [SOLVED:] Timed Message Boxes not handling code in between (5 replies)
  239. formula help (4 replies)
  240. Using the Custom UI to create a custom ribbon Addin for Excel (0 replies)
  241. Spllit the data customer wise and email id should come in A1 Column. (1 replies)
  242. [SOLVED:] Macro to skip rows that have blank cells (2 replies)
  243. How to split categorical data in Excel (1 replies)
  244. Summing up values in label captions (6 replies)
  245. [SOLVED:] VBA code for sum function for filtered columns (7 replies)
  246. [SOLVED:] Please Help. Rank Formula Macro (4 replies)
  247. Auto fill from multiple rows & cells (2 replies)
  248. Add a Calculated filed in pivot table to calculate percentage of adjacent column (1 replies)
  249. Aktivate/ deactivate check box (9 replies)
  250. Sharing Interest Dynamically (5 replies)