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. Import Multiple txt files (0 replies)
  2. [SOLVED:] ForEach Loop Trouble (7 replies)
  3. VBA for Setting Min and Max Axis for Scatter Plot Graph (0 replies)
  4. Vba view active ie window and mouse over text and pull to text box (0 replies)
  5. [SOLVED:] Arrays using MMULT Function (3 replies)
  6. Upon exit excel woorkbook save charts as picture (4 replies)
  7. Split to Files - adjustment (2 replies)
  8. Compare cells (4 replies)
  9. [SLEEPER:] VBA help solving assignment (2 replies)
  10. [SOLVED:] VBA- how can i have a userform behaviours just like controltiptext? (17 replies)
  11. Copy from RDP (remote desktop) to local desktop (2 replies)
  12. [SOLVED:] Need help w/formula to show just some amounts (3 replies)
  13. [SOLVED:] Select data down to next empty cell in column (4 replies)
  14. VBA Table of Contents (0 replies)
  15. Add double quotes to cells that contain spaces (8 replies)
  16. [SOLVED:] Select range till last empty row (2 replies)
  17. [SOLVED:] Value & Formula - Export Sheet from xlsx to CSV (2 replies)
  18. [SOLVED:] VBA Coding Help (3 replies)
  19. Message when you try to open the file (1 replies)
  20. [SOLVED:] Can you Format as fraction in VBA -- Format(123.456, "# ??/16") (1 replies)
  21. [SOLVED:] Changing Multiple ranges to Dynamic ones (5 replies)
  22. VBA: website scraping in general and specific problem (0 replies)
  23. Download and open Excel file (3 replies)
  24. Senders Email Address: Outlook 2013 to Excel 2013 Not Working (0 replies)
  25. urldownloadtofile-is-downloading-files-to-inetcache (1 replies)
  26. Select data through 2 slider bars (0 replies)
  27. [SOLVED:] How to keep Inserting Rows Command from moving other cells in a sheet (29 replies)
  28. 2 selection critria in a WorkSheet form (1 replies)
  29. Mirroring of sheets to a single summary sheet (0 replies)
  30. [SOLVED:] Microsoft Object Library Reference Missing - Outlook to Excel (3 replies)
  31. VBA format Word (0 replies)
  32. Excel VBA: resizing a pasted image in word using excel VBA (0 replies)
  33. Yes/No Optionbuttons (0 replies)
  34. X-Y Scatter plot using VBA (3 replies)
  35. VBA to read text file and import specific data from it to excel columns (6 replies)
  36. How to run macro only selected rows (4 replies)
  37. Salary Structure Calculations (3 replies)
  38. Sum adjacent columns based on criteria (3 replies)
  39. Copy Paste VBA code Required with some additional requirements Button (2 replies)
  40. Compare list of values to rows in another sheet, copy row on first match (1 replies)
  41. [SOLVED:] Hide and Unhide Columns based on Cell Value (10 replies)
  42. Extract value from HTM file (1 replies)
  43. [SOLVED:] Deciphering VBA Code (4 replies)
  44. [SLEEPER:] Help removing encryption from an excel template using VBA (4 replies)
  45. Function to list file names in a folder (0 replies)
  46. Two dropdown lists (0 replies)
  47. VBA Newbie question (0 replies)
  48. Help Looping through array (22 replies)
  49. Run-time error; Invalid procedure or arguement (2 replies)
  50. Macro listing files in folder, used to list all now only first (3 replies)
  51. Compile error argument not optional (7 replies)
  52. [SOLVED:] Help with renaming files (Name "xxxxxxx" As "yyyyyyyy" wont work) (2 replies)
  53. [SOLVED:] How to fix Compile error: Else without if (5 replies)
  54. Distance between 2 locations 2D array (3 replies)
  55. [SOLVED:] Find specific words in a worksheet and change the font color of those words (5 replies)
  56. [SOLVED:] Find zero (3 replies)
  57. [SOLVED:] Need help parsing subtext in cell (5 replies)
  58. [SOLVED:] Extracting intersecting values from two or more ranges (2 replies)
  59. Make Cell Blink 3 times (1 replies)
  60. [SOLVED:] Switching worksheets unexpectedly after exiting UserForm (6 replies)
  61. Run-time error "438" (11 replies)
  62. Checking for MULTIPLE duplicates on save_click (2 replies)
  63. [SOLVED:] Changing code from copy entire row to copy specific cells (2 replies)
  64. Auto update Form Text box with form editor name (0 replies)
  65. [SOLVED:] Filter between two dates on multiple ranges (2 replies)
  66. [SOLVED:] VBA to Copy / Paste into New Workbook With Different Layout by Column & Row Headings (9 replies)
  67. [SOLVED:] YTD SUM (4 replies)
  68. Search for Specific Text within a Cell (1 replies)
  69. Help with time diffrences (3 replies)
  70. [SOLVED:] Search using two ranges (4 replies)
  71. Change Check Box character to text (3 replies)
  72. Different Phone Number Formats from list of numbers (2 replies)
  73. Copying charts from all Excel worksheets onto Powerpoint slides (2 replies)
  74. data transfer through loop (3 replies)
  75. Aligning Columns and rows (3 replies)
  76. Turning Multiple Optionbuttons subs into one sub (2 replies)
  77. Eliminating Pop-up when using RemoveDuplicates (3 replies)
  78. VBA msgbox help (2 replies)
  79. Copy Data from one sheet to another IF cells are specific text colour (0 replies)
  80. excel help (3 replies)
  81. Excel VBA game help (0 replies)
  82. Force User to Enter Date but in UK format (10 replies)
  83. VBA variable url webquery (0 replies)
  84. Need help : fill listbox with search result (2 replies)
  85. VBA - Outlook to Excel (1 replies)
  86. How to change code for sheet to work whole book (2 replies)
  87. Code for Slicer (5 replies)
  88. Export specific sheet from a file to a specific sheet in many closed files (5 replies)
  89. [SOLVED:] Run time error -2147417848 (80010108) Method "_range" of object "_worksheet" failed. (6 replies)
  90. vba - vlookup on data stored in array (3 replies)
  91. Barcode Asterisks Around Date Formula (1 replies)
  92. Show column headings and corresponding values/text based on dropdown selection (39 replies)
  93. Numbers update as per Pivot table (2 replies)
  94. Moving data between sheets based on headers (2 replies)
  95. Data lookup formulas (4 replies)
  96. Else without IF error !!! (2 replies)
  97. Test to determine workload (3 replies)
  98. golf 4somes (22 replies)
  99. [Help] VBA for scheduling (1 replies)
  100. In work materials vs delivery date (2 replies)
  101. [SLEEPER:] Time formula (2 replies)
  102. [SLEEPER:] Reading value from another application (1 replies)
  103. Hiding ribbon commands (3 replies)
  104. Extracting data from a variable length string (4 replies)
  105. Customized Footers with VBA (0 replies)
  106. [SOLVED:] Concatenate Transpose - Multiple with Multiple (2 replies)
  107. [SOLVED:] Hide/Unhide Rows Based on Cell Value (2 replies)
  108. automatically hide/unhide the row based another sheet cell value. (4 replies)
  109. [SOLVED:] Average and addtional conditions (4 replies)
  110. [SOLVED:] Import most recent xml file (3 replies)
  111. VBA breaks when it comes to deleting command button and selecting A1 cell (1 replies)
  112. [SOLVED:] Textjoin help needed (5 replies)
  113. [SLEEPER:] Help with Merge in Excel (2 replies)
  114. [SOLVED:] For Loop for 2 Range (3 replies)
  115. VBA: Internet Explorer zoom level (0 replies)
  116. Filtering data on multiple creterias (8 replies)
  117. [SOLVED:] Multiple Frames on A Excel UserForm and switch the visibility (6 replies)
  118. [SOLVED:] could not set the list property. Invalid property value error (8 replies)
  119. [SOLVED:] Saving worksheet range without formula to array (2 replies)
  120. [SOLVED:] Dynamic vlookup refering different workbooks through VBA (3 replies)
  121. Macro to recover an excel encrypted workbook (4 replies)
  122. [SOLVED:] Trim and LCase values in an array (3 replies)
  123. VBA Userform (Excel 2016) - Textbox date calculations: Date + No. of days=Expiry Date (2 replies)
  124. Is there a cleaner way to write this formula? (3 replies)
  125. Spell check stopped working (2 replies)
  126. How can you use a variable to reference a worksheet object? (8 replies)
  127. Assign exact dates of material availability to each production order (0 replies)
  128. [SLEEPER:] VBA Script locks the excel sheet (2 replies)
  129. Looping through combo box (1 replies)
  130. Copy Cell Values Using If Statements through VBA Code (8 replies)
  131. [SOLVED:] How Do I Change The Date Format in VBA Code (11 replies)
  132. Copy rows with specific values and paste within the same worksheet (1 replies)
  133. Code for selecting data and paste in another tab (7 replies)
  134. Auto Updating Row for Sum Grand Total (1 replies)
  135. [SOLVED:] syntax problem with a While nested into a Loop (for an Array) (17 replies)
  136. Call data from another sheet based on multi critiria (7 replies)
  137. [SOLVED:] Copy Values if name of sheets in two different workbooks are equal (1 replies)
  138. Find Copy and Paste (2 replies)
  139. [SOLVED:] Code for Pivot (1 replies)
  140. Filtered data in Listbox based on Option buttons EXCEL VBA (0 replies)
  141. problem getting internet values (0 replies)
  142. [SOLVED:] Excel Optionbutton Calculations (4 replies)
  143. [SOLVED:] Wrong customer apprearing (2 replies)
  144. Automation of Drop Down list (1 replies)
  145. [SOLVED:] I need to create a macro, but unsure of what formulas to put into it (5 replies)
  146. How to disable the sheets protection (2 replies)
  147. Excel VBA (1 replies)
  148. Can VBA record multiple iteration wb results with for next loop from a range of data? (5 replies)
  149. MAcro Creation Date (1 replies)
  150. If and Index and Match against a couple of different conditions (2 replies)
  151. Change the list contents in a cell, when changing the contents in another cell. (17 replies)
  152. Out of places to turn for Time and date stamp help (2 replies)
  153. Copying specific fields of multiple txt files into one master excel (1 replies)
  154. Most efficient way of finding the last row. (4 replies)
  155. INDEX/MATCH formula with INDEX return being in row higher than MATCH value (xlUP) (1 replies)
  156. Code to copy row if two criteria match (1 replies)
  157. VBA code for plotting ternary in excel (0 replies)
  158. Draw line around page margins (6 replies)
  159. Copy data from excel which receive in outlook mail (0 replies)
  160. Transfer Data from one sheet to another sheet to create invoices (3 replies)
  161. Userform Listbox Search Function (9 replies)
  162. HTML Scraping (1 replies)
  163. How to insert a specific row from my sheet, into the email-body using VBA-Excel (1 replies)
  164. Update the Master Workbook from the Copy. (2 replies)
  165. Runtime error 438 (6 replies)
  166. [SOLVED:] Problem with Range().EntireRow.Insert when creating insertRow sub (4 replies)
  167. Date calculation and formula (2 replies)
  168. VBA - change color with double click and count cells based on color (0 replies)
  169. [SOLVED:] Placing comma separated values into the corresponding cell (2 replies)
  170. [SLEEPER:] Can you query a RECORDSET using SQL (4 replies)
  171. [SOLVED:] How To Load Macro onto Exported Excel Sheet (6 replies)
  172. [SOLVED:] PDF from a macro in excel (3 replies)
  173. [SOLVED:] VBA: Detect if the webpage on Internet Explorer is loaded (4 replies)
  174. [SOLVED:] inputbox vba problem (1 replies)
  175. VBA to replace text in a single column (1 replies)
  176. Impossible to trigger a value input in a menu with VBA (javascript) (0 replies)
  177. How Many Coctail With Fruit From İnventory(most effective ways) (0 replies)
  178. [SOLVED:] Excel VB to hide an entire row based on sheet name match and cell dynamically. (4 replies)
  179. Getting “Type Mismatch” with VBA PivotTables and Filter Dates (0 replies)
  180. [SLEEPER:] VBA code errors for exporting sheets as individual PDFs (3 replies)
  181. [SOLVED:] Increment number sequence by two conditions (4 replies)
  182. Dlookup only works when Access is open (0 replies)
  183. Cntl+. macro ? (1 replies)
  184. Send Notes Mail out of Excel with monospaced body (0 replies)
  185. [SOLVED:] How to copy and paste only bold parts of string and not unbold parts of string? (2 replies)
  186. Code to hide row if no value (9 replies)
  187. problem getting internet values (0 replies)
  188. VBA Textbox get last entry from time stamp (1 replies)
  189. Complex VBA - Trying to use specific online calculator and download data to excel (0 replies)
  190. [SOLVED:] Error - Duplicate record after filtering n the Header can't be copied to new workbook (2 replies)
  191. Extract data from the outlook mail which has attached excel file (2 replies)
  192. [SOLVED:] Import .csv file (7 replies)
  193. [SOLVED:] Compare 2 Sheet and by 2 column and compare date get the value on sheet 1 (2 replies)
  194. [SOLVED:] Auto Fill Next Blank Cell in a Row with Value from the Row Above (3 replies)
  195. VBA not to show excel file, excel logo, excel ico but only show a User form (3 replies)
  196. VBA code to print unique values and corresponding values from the other coloumn (1 replies)
  197. Multipage: When I change the page the date changes. (1 replies)
  198. VBA code help 2016 (3 replies)
  199. After uppdating cell excel jumps to other sheet (1 replies)
  200. [SOLVED:] Find all cells with certain value and delete the whole row (8 replies)
  201. [SOLVED:] change from vba code (const as date) to (cell.value in worksheet) (0 replies)
  202. Counting Number of Colors in a sheet (not Number of Colored cells) (3 replies)
  203. [SOLVED:] If E and F is empy paste to column (2 replies)
  204. [SOLVED:] Merge specific worksheet from multiple workbooks into a single worksheet (8 replies)
  205. [SOLVED:] Send e-mail with multiple range in body of e-mail (4 replies)
  206. VBA code to delete contents of one cell based on change in another (1 replies)
  207. VBA Code help - Search files within folders and return file name and path (1 replies)
  208. VBA code to seend seperate sheets as PDF to seperate emails (8 replies)
  209. [SLEEPER:] Logic to pull directory, two tabs and transpose data (1 replies)
  210. How to create a dynamic range for vlookup based on active cell (1 replies)
  211. SUM IFS CONDITION COMPLEX SCENARIO (7 replies)
  212. Amalgamating and texting (1 replies)
  213. VBA FOR TWO INTERACTING DATA VLAIDATION DROPDOWNS (1 replies)
  214. [SOLVED:] Underline specific text in shape caption. (Excel 2013) (2 replies)
  215. Convert Row Range formula result to Value (1 replies)
  216. Excel VBA Highlighting dates in a range which match a date from an inputbox (1 replies)
  217. sending email with multiple attachments (4 replies)
  218. Pass Chart Data Point number to variable (1 replies)
  219. Run-Time Error 53 File not found (2 replies)
  220. [SOLVED:] VBA to send 1 email containing all attachments (2 replies)
  221. Problem in automating form filling web page. (0 replies)
  222. #1 VBA to sort data from multiple worksheets into a worksheet (same workbook) (4 replies)
  223. [SOLVED:] Conditional Formatting Help (6 replies)
  224. excel - search for document and open (2 replies)
  225. Userform too much loaded (7 replies)
  226. [SOLVED:] Class Event for ComboBox Enter (Excel 2013) (3 replies)
  227. [SOLVED:] Quick VBA find question (2 replies)
  228. [SOLVED:] ListBox - PreSelect Values (3 replies)
  229. Help with VBA to send email to several recipients listed in different columsn (4 replies)
  230. [SLEEPER:] Copy particular columns from one file to master file with condition (5 replies)
  231. Extract URL with the hashtag # (2 replies)
  232. Sheets change every few seconds in a loop (19 replies)
  233. [SOLVED:] Run Macro only if selected by left click (4 replies)
  234. Count Highlighted Cells In Each Column (3 replies)
  235. Autofilter, copy, paste to new file (11 replies)
  236. [SOLVED:] Find values in a range then copy and paste data to different column (2 replies)
  237. [SOLVED:] Sum on the basis of mutiple criteria (7 replies)
  238. Moving Files & Folders by Last Modified Date (14 replies)
  239. Copy text to cell from another sheet (5 replies)
  240. [SOLVED:] Start From Last Column - Sequential Number (2 replies)
  241. VLOOKUP VBA FORMULA (2 replies)
  242. Creating shapes and position them (3 replies)
  243. getting #N/D on function.transpose (8 replies)
  244. VBA - Removing a Sheet based on a condition (else a message box) (5 replies)
  245. [SOLVED:] Setfocus in Access form FROM within Excel ? (8 replies)
  246. [SLEEPER:] Excel VB "Unprotect" workbook statement (4 replies)
  247. Rename Files (4 replies)
  248. Add string of text to a specific point in every cells (2 replies)
  249. Highlight Duplicates based on Different year in each row. (1 replies)
  250. Run-time eerror 424 (5 replies)