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. [SOLVED:] Creating Sheets from Cell Value IF Only! (2 replies)
  2. VBA Current region minus header and last column (3 replies)
  3. [SOLVED:] Pivot Table Grand Total (2 replies)
  4. Percentage covered by values using VBA (7 replies)
  5. Last entry in a Column (2 replies)
  6. Auto updating of worksheets in an Excel Workbook (8 replies)
  7. Populate vlookup formula 1Million item (1 replies)
  8. [SOLVED:] Problem using keyPress command (10 replies)
  9. [SOLVED:] Applying a multiplication by macro on a column (18 replies)
  10. New VBA Code (1 replies)
  11. [SOLVED:] Filter and copy to WorkSheet help (2 replies)
  12. VBA matching, data manipulation across different worksheets (20 replies)
  13. [SOLVED:] Help Needed! Macro to pull if cell does not equal criteria (6 replies)
  14. Why is the sub or Function not defined for the following code (6 replies)
  15. [SOLVED:] vba or formula to find number of duplicates in a range (5 replies)
  16. Procedure Too Large (15 replies)
  17. Macro To Add DSN (2 replies)
  18. Why is the default value of UserInterfaceOnly False? (4 replies)
  19. [SOLVED:] How to extract date range into multiple rows? (4 replies)
  20. Save As Help (10 replies)
  21. Runtime 1004 error (5 replies)
  22. VBA code to copy / paste values only + auto change cell value (5 replies)
  23. Need to copy from all sheets from all workbooks (4 replies)
  24. How can I refresh a webpage in VBA before downloading it? (0 replies)
  25. Sleeper: Merge worksheets (2 replies)
  26. VBA excel help (22 replies)
  27. [SOLVED:] How to export variable from textbox into a cell after clicking on a button? (2 replies)
  28. Join Error (1 replies)
  29. Macro to pull outlook info based on excel values (0 replies)
  30. Hyperlink to specific sheets in workbook based on drop down selection (6 replies)
  31. I need to count the amount of weeks a piece of text has appeared since last change (6 replies)
  32. Advice needed to speed this code. (67 replies)
  33. course analysis from bitcoins with VBA (38 replies)
  34. Excel formula help (3 replies)
  35. NEW TO VBA...Need Help..driving me nuts (7 replies)
  36. Checking Excel background image with VBA (20 replies)
  37. [SOLVED:] HELP ON FIND/REPLACE (11 replies)
  38. Creating a form to filter data? (13 replies)
  39. Convert Table to Calendar (Wincalendar functionality) (0 replies)
  40. [SOLVED:] Can I use an excel sheet to calculate in a vba program? (2 replies)
  41. How to find and use the maximum value in VBA code (4 replies)
  42. Macro to remove marker line and border (7 replies)
  43. Help with the meaning of this code (13 replies)
  44. Writing to a cell in a loop (10 replies)
  45. Excel 2013 Macros Click-Activated Shapes (1 replies)
  46. [SLEEPER:] A variable SUM formula in excel (3 replies)
  47. [SOLVED:] Accessing Excel Tab data from Button (6 replies)
  48. filter multiple columns simultaneously using Vbscript (1 replies)
  49. Using a barcode scanner with Excel (1 replies)
  50. Color Code Data According by Categories (7 replies)
  51. invalid or unqualified reference (6 replies)
  52. Combobox from external database, not working (3 replies)
  53. Avoid duplication in copying (1 replies)
  54. Sleeper: Need help with my code as it doesnt seem to be appearing (2 replies)
  55. [SOLVED:] Find average of all values between two index match values in table (2 replies)
  56. vba code To Save Copy As Cell.Value (2 replies)
  57. Macro Help - Pasting (4 replies)
  58. [SOLVED:] Load data from TXT to Excel sheet (numbers with decimal get like text) (11 replies)
  59. copy filtered data into different worksheet (0 replies)
  60. Selective listing of files in a folder (32 replies)
  61. Userform with changeable headers/ listboxes to opt for creating reports from Excel DB (0 replies)
  62. [SOLVED:] Sum Up Cells Value When Specific Value Match (3 replies)
  63. Help with text file row count - only want the last 13 rows (10 replies)
  64. Import particular data from book1 to book2 (0 replies)
  65. VBA Macro Help - Extract from Multiple Closed Workbooks (0 replies)
  66. [SOLVED:] Run-time error '445' - Object doesn't support this activity (18 replies)
  67. macro prompt? (3 replies)
  68. VBA VLOOKUP (0 replies)
  69. Select number of rows based cell value (5 replies)
  70. Saving Screenshots in excel (1 replies)
  71. Unable to get pivottable property of class (1 replies)
  72. Problem between macro event and SpinButton (3 replies)
  73. save and close an excel sheet when I press the Windows + L buttons (16 replies)
  74. Checkbox make values to textbox (2 replies)
  75. [SOLVED:] Type Mismatch Error Confusion (14 replies)
  76. Populating a Cell with a Table (5 replies)
  77. How to generate Sum formula in excel (3 replies)
  78. need a vba code HELLLLLPPPPPP (7 replies)
  79. [SOLVED:] Difficulty using KeyPress Command (2 replies)
  80. [SOLVED:] VBA - Change code to work on whole workbook (2 replies)
  81. How to insert a formula in a dynamic range using VBA (6 replies)
  82. Redim Preserve Change LBOUND (16 replies)
  83. [SOLVED:] Very omplicated calculation of hours worked (PLEASE HELP) (8 replies)
  84. How to execute a VBA program and halting another VBA code till the old program ends (6 replies)
  85. Problem with copying the text format. (2 replies)
  86. [SOLVED:] Macro to delete all rows between two different text stings in column A (8 replies)
  87. Reference specific text strings despite being repeated elsewhere? (18 replies)
  88. Macro to copy values from one sheet to another based on specific conditions (1 replies)
  89. excel help (0 replies)
  90. [SOLVED:] ListBox_Click event fires without clicking (9 replies)
  91. [SOLVED:] How to check if value starts with text (2 replies)
  92. Compare data from two workbooks (0 replies)
  93. [SOLVED:] UserForm that Stays Visible on Screen When Scrolling (7 replies)
  94. [SLEEPER:] Web query Looping from table selection (6 replies)
  95. Macro to find and replace based on different text within one cell (4 replies)
  96. Generate Shapes, Align, Group, Cut and Paste (14 replies)
  97. [SOLVED:] List box looses Blue 'highlight' when changing forecolor (10 replies)
  98. [SOLVED:] Function working within Sub but not in spreadsheet (3 replies)
  99. VBA Pivot Table creation looks different than manual creation (2 replies)
  100. [SOLVED:] Test Pivot Table (4 replies)
  101. Strings and Variables (5 replies)
  102. [SLEEPER:] Read Tag property without opening file (7 replies)
  103. How to find and use the maximum value in VBA (7 replies)
  104. Macro to loop through Web Queries and enact a second macro once each page loads (1 replies)
  105. Match 1st ?? in column vertically, if Yes, then see if 2nd ?? matches horizontally? (4 replies)
  106. vba code for getting the filename for another worksheet on a newfile worksheet (1 replies)
  107. VBA code to remove text from a column (6 replies)
  108. [SOLVED:] Compiling a List to a Seperate Sheet (2 replies)
  109. How to make a solver VBA code in a dynamic range (1 replies)
  110. [SOLVED:] Excel 2013 ActiveX Combo Boxes Macro Glitch (3 replies)
  111. Trendline for y-values (1 replies)
  112. Match index with closest previous date (3 replies)
  113. [SOLVED:] Run-Time Error "1004" LOOPS! (5 replies)
  114. [SOLVED:] VBA find the FIRST real row (5 replies)
  115. Custom Menu/Macro Library (1 replies)
  116. [SOLVED:] How to get the absolute column number of given cell value from the range C2:K2 (3 replies)
  117. [SLEEPER:] VBA CODE HELP ...if you have time!!! (10 replies)
  118. [SLEEPER:] Consolidating Order Sheet (3 replies)
  119. How to leave just the text I want in a cell. (2 replies)
  120. VBA export filename and path (9 replies)
  121. Help with code to export excel to text file with number format (2 replies)
  122. Populate (string) array from sheet (1 replies)
  123. How to increment Alpha numeric Value (6 replies)
  124. VBA Fill arrays from sheet | SUMIFS | create & fill table based on multiple criteria (0 replies)
  125. Non Looping For Next Loop (3 replies)
  126. ActiveCell.Value=replace........not putting range in new column. (2 replies)
  127. Copy to multiple sheet based on cell value criteria (0 replies)
  128. [SOLVED:] Issue with Mass-Email Excel macro (2 replies)
  129. 1004 Error Copying and Pasting Range (2 replies)
  130. [SOLVED:] Group shapes in a single cell without select (1 replies)
  131. Copy Data From One Sheet to Another with Input Box (1 replies)
  132. Extract specific columns from DBF to Excel (0 replies)
  133. Macro to enter filepath on click browse button (4 replies)
  134. Listing values assosciated with headings on a worksheet (15 replies)
  135. [SOLVED:] Listing unique vales in a range with blank cells (8 replies)
  136. Copy Pivot Table From One Workbook To Another (0 replies)
  137. Copy data in disperce cells from multiple excel workbooks..? (5 replies)
  138. [SOLVED:] VBA Syntax to run sql statement with where and order by (1 replies)
  139. Download images from the excel and save to a Folder (4 replies)
  140. Flip an image in a userform? (1 replies)
  141. [SOLVED:] Something missing from code (2 replies)
  142. Help with Sub (3 replies)
  143. Add Active X Command Button to sheet and keep Userform Open (9 replies)
  144. Matching data from two different sheets (3 replies)
  145. Error Handling for data scraping (1 replies)
  146. lookup problem (1 replies)
  147. [SOLVED:] Align all shapes to the center of their cell (1 replies)
  148. Update data from mapping table to another worksheet (3 replies)
  149. Hide Excel Tabs-Heading-Formula Bar on Opening (3 replies)
  150. Play embedded wav file when workbook opens (12 replies)
  151. [SOLVED:] Confused between Date and Today (2 replies)
  152. Open workbook with one password close with another from a list?? (0 replies)
  153. formula to check different between 2 dates within same month in range (4 replies)
  154. Applying Border to symbols in Excel VBA (0 replies)
  155. power function in VBA (6 replies)
  156. [SOLVED:] error in VBA lookup code (1 replies)
  157. Get TIME format to match? (5 replies)
  158. Macro Automatically SUM upper data when entering new data (1 replies)
  159. Copy range into a image in Outlook (1 replies)
  160. Excel File Recovery (0 replies)
  161. Simple VBA query (6 replies)
  162. Overflow error on VBA Module (20 replies)
  163. Macro to find numbers in a single column (6 replies)
  164. Macro to find numbers in a single column (0 replies)
  165. [SOLVED:] Help with authoirisation list please (4 replies)
  166. Msgbox when textbox not filled but on choice (yes/no) (3 replies)
  167. Calculating differences in exchange rates - FIFO method VBA (3 replies)
  168. Repeating a string using VBA button (3 replies)
  169. [SOLVED:] Label in Frame, catch caption with click error! (5 replies)
  170. Find and add missing value (0 replies)
  171. Logging into a website (0 replies)
  172. Update cell on sheet change - w/correct file (4 replies)
  173. Geometric Brownian Motion simulation? (10 replies)
  174. Update cell value on sheet change (3 replies)
  175. [SOLVED:] Sheet Buttons Flashing When Mouse Over Userform (4 replies)
  176. [SOLVED:] vlookup array values (2 replies)
  177. [SOLVED:] Excel to Word Macro Merge File Select Help (0 replies)
  178. Using a userform with a for loop (2 replies)
  179. [SLEEPER:] How to set focus back into the textbox after an error message? (6 replies)
  180. Query Access database with parameters on Excel sheet. (1 replies)
  181. Help with inputting the value in the back sheet using VBA code (2 replies)
  182. Sleeper: Comparing pivot table and adding value to cell (1 replies)
  183. Date Calculation Inside TextBox Vba (3 replies)
  184. [SOLVED:] Removing middle initials with space in last name (8 replies)
  185. if iserror match not functioning (2 replies)
  186. [SOLVED:] Search string and return file name and Path (35 replies)
  187. [SOLVED:] search excel cells for value and input corresponding value in adjecent cell (6 replies)
  188. iserror and lookup not working combined (1 replies)
  189. Running macro on another workbook (3 replies)
  190. [SOLVED:] combining several VBA subs (4 replies)
  191. Several VBA questions / index match (1 replies)
  192. Help on macro to fetch data from one sheet and post on the other (3 replies)
  193. Split the Workbook into different files based on SPECIFIC DATA VALUES (0 replies)
  194. Numbers format preventing calculation to be implemented (0 replies)
  195. Need help to convert formula to VBA code (4 replies)
  196. Assigning variable to table or table name (2 replies)
  197. Reading data from Word document; selecting line after table (0 replies)
  198. How to recover A corrupted Excel 2003 file (14 replies)
  199. Populate form ListBox from range (0 replies)
  200. [SLEEPER:] How to generate a dynamic range using VBA code (2 replies)
  201. Macro copy worksheet to workbook and row offsets (2 replies)
  202. Extracting data from different worksheets in desired format-Part 2 (Editing formula) (4 replies)
  203. ActiveDocument.Close error (1 replies)
  204. Using Index Match in VBA Project (1 replies)
  205. Help Needed (0 replies)
  206. Sleeper: Copy filtered table (4 replies)
  207. Clear Slicers Using VBA (4 replies)
  208. [SOLVED:] Need Help with Userform Progress Bar (8 replies)
  209. Pivot Table from dynamic range (0 replies)
  210. Data Distribution (1 replies)
  211. [SOLVED:] Save a certain sheet as PDF and name it from a range within the sheet (1 replies)
  212. How to skip an empty cell in a column ? (11 replies)
  213. Convert a value to suit an Excel Speedo's segmented variable scale (3 replies)
  214. [SOLVED:] Select Case Conditional Formatting VBA (8 replies)
  215. Conditional Formatting from one row to another (5 replies)
  216. Need to copy specific text from open word doc, to excel in a row (2 replies)
  217. Simple excel macro if then condition to manipulate column values (2 replies)
  218. [SLEEPER:] Macro to savecopyAs multiply based on filter (3 replies)
  219. Timesheet Help (0 replies)
  220. [SOLVED:] Sum of cells in a row on other sheet, column reference based on selected number range (2 replies)
  221. [SOLVED:] DateDiff in listview excel (6 replies)
  222. [SOLVED:] Trouble Grouping Label and Shape (1 replies)
  223. How to Parse Based on Varying SubStrings (4 replies)
  224. Stephen Bullen's Resize (Userform) (21 replies)
  225. Macro take multiple screenshots and save in excel (3 replies)
  226. Please Help with VBA code (4 replies)
  227. If statement checking last digit and modifying time (1 replies)
  228. Arrays (9 replies)
  229. [SOLVED:] Worksheet_SelectionChange(ByVal Target As Range) (4 replies)
  230. Excel VBA add new list item in SharePoint List (1 replies)
  231. [SOLVED:] Searching selected range (offset) for values in external workbook range (3 replies)
  232. VBA to jump to range in contained in a SUMIFS formula (2 replies)
  233. Hello masters of VBA... here I am a newie for VBA with a question - please help (3 replies)
  234. Find yyyymm in date column (2 replies)
  235. Need Help With Excel Formula (3 replies)
  236. How to make a dynamic table(dynamic rows and columns) using VBA code (22 replies)
  237. VBA macro for highlighting datain range based on selecting data in another (1 replies)
  238. Stock Historic prices on button click (0 replies)
  239. Match a string with a string that includes a wildcard (*) excel? (0 replies)
  240. Copy-paste data from source file to master workbook (0 replies)
  241. Help - Selective look up needed (0 replies)
  242. help, a system to check inventories (2 replies)
  243. Lay Dutch Test of dynamic subsets (10 replies)
  244. [SOLVED:] Help inserting a variable in to a formula (6 replies)
  245. [SOLVED:] Remove Array Elements (3 replies)
  246. [SOLVED:] Select Active cell to top cell (2 replies)
  247. [SOLVED:] Change event problem (4 replies)
  248. [SOLVED:] VBA to merge data and place - between each data from five columns (5 replies)
  249. [SOLVED:] Mailbatch with 2 different bodies based on cell (3 replies)
  250. Macro to copy specific data from sheet A to sheet B (0 replies)