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. Simple VBA query (6 replies)
  2. Overflow error on VBA Module (20 replies)
  3. Macro to find numbers in a single column (6 replies)
  4. Macro to find numbers in a single column (0 replies)
  5. [SOLVED:] Help with authoirisation list please (4 replies)
  6. Msgbox when textbox not filled but on choice (yes/no) (3 replies)
  7. Calculating differences in exchange rates - FIFO method VBA (3 replies)
  8. Repeating a string using VBA button (3 replies)
  9. [SOLVED:] Label in Frame, catch caption with click error! (5 replies)
  10. Find and add missing value (0 replies)
  11. Logging into a website (0 replies)
  12. Update cell on sheet change - w/correct file (4 replies)
  13. Geometric Brownian Motion simulation? (10 replies)
  14. Update cell value on sheet change (3 replies)
  15. [SOLVED:] Sheet Buttons Flashing When Mouse Over Userform (4 replies)
  16. [SOLVED:] vlookup array values (2 replies)
  17. [SOLVED:] Excel to Word Macro Merge File Select Help (0 replies)
  18. Using a userform with a for loop (2 replies)
  19. How to set focus back into the textbox after an error message? (6 replies)
  20. Query Access database with parameters on Excel sheet. (1 replies)
  21. Help with inputting the value in the back sheet using VBA code (2 replies)
  22. Sleeper: Comparing pivot table and adding value to cell (1 replies)
  23. Date Calculation Inside TextBox Vba (3 replies)
  24. [SOLVED:] Removing middle initials with space in last name (8 replies)
  25. if iserror match not functioning (2 replies)
  26. [SOLVED:] Search string and return file name and Path (35 replies)
  27. [SOLVED:] search excel cells for value and input corresponding value in adjecent cell (6 replies)
  28. iserror and lookup not working combined (1 replies)
  29. Running macro on another workbook (3 replies)
  30. [SOLVED:] combining several VBA subs (4 replies)
  31. Several VBA questions / index match (1 replies)
  32. Help on macro to fetch data from one sheet and post on the other (3 replies)
  33. Split the Workbook into different files based on SPECIFIC DATA VALUES (0 replies)
  34. Numbers format preventing calculation to be implemented (0 replies)
  35. Need help to convert formula to VBA code (4 replies)
  36. Assigning variable to table or table name (2 replies)
  37. Reading data from Word document; selecting line after table (0 replies)
  38. How to recover A corrupted Excel 2003 file (14 replies)
  39. Populate form ListBox from range (0 replies)
  40. [SLEEPER:] How to generate a dynamic range using VBA code (2 replies)
  41. Macro copy worksheet to workbook and row offsets (2 replies)
  42. Extracting data from different worksheets in desired format-Part 2 (Editing formula) (4 replies)
  43. ActiveDocument.Close error (1 replies)
  44. Using Index Match in VBA Project (1 replies)
  45. Help Needed (0 replies)
  46. Sleeper: Copy filtered table (4 replies)
  47. Clear Slicers Using VBA (4 replies)
  48. [SOLVED:] Need Help with Userform Progress Bar (8 replies)
  49. Pivot Table from dynamic range (0 replies)
  50. Data Distribution (1 replies)
  51. [SOLVED:] Save a certain sheet as PDF and name it from a range within the sheet (1 replies)
  52. How to skip an empty cell in a column ? (11 replies)
  53. Convert a value to suit an Excel Speedo's segmented variable scale (3 replies)
  54. [SOLVED:] Select Case Conditional Formatting VBA (8 replies)
  55. Conditional Formatting from one row to another (5 replies)
  56. Need to copy specific text from open word doc, to excel in a row (2 replies)
  57. Simple excel macro if then condition to manipulate column values (2 replies)
  58. [SLEEPER:] Macro to savecopyAs multiply based on filter (3 replies)
  59. Timesheet Help (0 replies)
  60. [SOLVED:] Sum of cells in a row on other sheet, column reference based on selected number range (2 replies)
  61. [SOLVED:] DateDiff in listview excel (6 replies)
  62. [SOLVED:] Trouble Grouping Label and Shape (1 replies)
  63. How to Parse Based on Varying SubStrings (4 replies)
  64. Stephen Bullen's Resize (Userform) (21 replies)
  65. Macro take multiple screenshots and save in excel (3 replies)
  66. Please Help with VBA code (4 replies)
  67. If statement checking last digit and modifying time (1 replies)
  68. Arrays (9 replies)
  69. [SOLVED:] Worksheet_SelectionChange(ByVal Target As Range) (4 replies)
  70. Excel VBA add new list item in SharePoint List (1 replies)
  71. [SOLVED:] Searching selected range (offset) for values in external workbook range (3 replies)
  72. VBA to jump to range in contained in a SUMIFS formula (2 replies)
  73. Hello masters of VBA... here I am a newie for VBA with a question - please help (3 replies)
  74. Find yyyymm in date column (2 replies)
  75. Need Help With Excel Formula (3 replies)
  76. How to make a dynamic table(dynamic rows and columns) using VBA code (22 replies)
  77. VBA macro for highlighting datain range based on selecting data in another (1 replies)
  78. Stock Historic prices on button click (0 replies)
  79. Match a string with a string that includes a wildcard (*) excel? (0 replies)
  80. Copy-paste data from source file to master workbook (0 replies)
  81. Help - Selective look up needed (0 replies)
  82. help, a system to check inventories (2 replies)
  83. Lay Dutch Test of dynamic subsets (10 replies)
  84. [SOLVED:] Help inserting a variable in to a formula (6 replies)
  85. [SOLVED:] Remove Array Elements (3 replies)
  86. [SOLVED:] Select Active cell to top cell (2 replies)
  87. [SOLVED:] Change event problem (4 replies)
  88. [SOLVED:] VBA to merge data and place - between each data from five columns (5 replies)
  89. [SOLVED:] Mailbatch with 2 different bodies based on cell (3 replies)
  90. Macro to copy specific data from sheet A to sheet B (0 replies)
  91. [SOLVED:] How to Compare a textbox entry to a column and find duplicates? (11 replies)
  92. Extracting Left function -String into Columns (0 replies)
  93. [SOLVED:] Excel VBA Date Issue Transfer from one worksheet to another (3 replies)
  94. [SOLVED:] Copy + Find + Past (2 Files) (6 replies)
  95. Store image in VBA? (9 replies)
  96. Macro that will consolidate multiple worksheets regardless of worksheet name (0 replies)
  97. Windows 10 MISSING: Microsoft Windows Common Controls 6.0 (SP6) (2 replies)
  98. Analog clock with Chart (7 replies)
  99. Creating Chart Via VBA (0 replies)
  100. [SOLVED:] VBA codes clashing (6 replies)
  101. auto scale every chart in a worksheet based on each charts x and y axis min and max v (0 replies)
  102. relative range / Offset within a sum - how to change the range summed (2 replies)
  103. Help on Excel Project (1 replies)
  104. VBA error on copying workbooks from file location (3 replies)
  105. [SOLVED:] Delete Sheet Macro Crashes Excel (3 replies)
  106. Help with code (4 replies)
  107. Edit rows with userform textboxes and coboboxes (2 replies)
  108. Track changes to a column, not when rows are inserted and deleted (4 replies)
  109. VBA for highlighting needs revising (20 replies)
  110. [SOLVED:] VBA appears to be missing something please help!! (8 replies)
  111. Loop Through SubFolders Task - Merge Files as Folder Name (0 replies)
  112. [SOLVED:] Copy and Paste Data from One Tab to Another (2 replies)
  113. [SOLVED:] VBA Calculate Event (5 replies)
  114. [SOLVED:] Need vba macro to highlight duplicates in a column (19 replies)
  115. Different charts in one diagram: chart modification problem (1 replies)
  116. Loop data is not recognized (11 replies)
  117. [SOLVED:] Looping formula (0 replies)
  118. Runtime Error 1004 (0 replies)
  119. Deleting worksheets with specific name ?? (2 replies)
  120. [SOLVED:] Filter question (4 replies)
  121. [SOLVED:] How to populate data from one sheet to another? (5 replies)
  122. Solver VBA code for different objective function cells (2 replies)
  123. [SOLVED:] Conditional Formatting Formula (6 replies)
  124. Solver VBA code for multiple sheets (2 replies)
  125. Advice required to run code faster (3 replies)
  126. [SOLVED:] How to avoid to continue searching (on the same sheet) if specific word is found (4 replies)
  127. [VBA] How to trigger a macro with a letter key without "Ctrl" (1 replies)
  128. Vba İnformation About The Array() Cells() Property (6 replies)
  129. Choose Invoice Number from a userform combobox and copy data to invoice output (1 replies)
  130. Sleeper: Best way to add a column to a range with offset of n (1 replies)
  131. Need Help: Check Sheet Name Exists Before Creating New W/ Same Name (3 replies)
  132. Excel to PPT --- can't detect error in loop (4 replies)
  133. Daily Data for Entire Year - vba userform (5 replies)
  134. Need help creating a formula for multiple sheets of data that will tie into a chart (0 replies)
  135. [SOLVED:] Clear Contents VBA (2 replies)
  136. Copy-paste extracted data in values to reference sheet (VBA) (1 replies)
  137. [SOLVED:] Copy Values from an array into sheet tab names (4 replies)
  138. VBA Coding needs advice - To Simplify (2 replies)
  139. Restrict Duplicate Values in a Row using excel VBA (1 replies)
  140. Change Excel sheet Tab colour when date entered in a cell (4 replies)
  141. How i can exit from compo box after select ? (1 replies)
  142. [SOLVED:] Match Funtion VBA (11 replies)
  143. Checking if other sheets in the workbook contain the same content as a defined cell (0 replies)
  144. [SOLVED:] Workbook closes "by itself" when some macros run or other workbooks opened. (12 replies)
  145. HTTP Response cookies not retrieved in results for XMLHTTP request in EXCEL Macro (0 replies)
  146. Error with Protect and Unprotect through VBA (4 replies)
  147. run time error '1004' Help!!!! (1 replies)
  148. Vlookup with multiple results (5 replies)
  149. [SOLVED:] Run Same VBA Macro Code On Multiple Sheets (9 replies)
  150. Sort files by date in a folder and then use this ordered list to open the files (2 replies)
  151. Finding blank cells in named range and input 0 (4 replies)
  152. Help for VBA Code as too much time while processing (3 replies)
  153. Converting LEFT and RIGHT with FIND formulas to VBA macros including IFERROR (5 replies)
  154. Using Excel VBA i want to protect a range of cells but other cells should be editable (1 replies)
  155. VBA to download images in web (0 replies)
  156. [SOLVED:] Captilize Select Characters Within A Cell (17 replies)
  157. Get the first instance of a value from a range (9 replies)
  158. Passing one function to another (3 replies)
  159. [SOLVED:] Help with Pasting Values (5 replies)
  160. Listing text files based on search value - returns multiple instances of same record (3 replies)
  161. copy data from a range in sheet into rows in another sheet (12 replies)
  162. Creating workbooks/sheets based on a tables in a master workbook (0 replies)
  163. Date picker (2 replies)
  164. Extract data with one criteria and no duplicate (1 replies)
  165. Run-Time Error '1004' Delete method of Range class failed (4 replies)
  166. Paste Special: PasteSpecial method of Range class failed (0 replies)
  167. [SOLVED:] Loop through folder only opens one file (2 replies)
  168. Choosing/listing from existing database (0 replies)
  169. END IF WITHOUT BLOCK IF (6 replies)
  170. Need explanation to save file as (2 replies)
  171. Errors dumping an Array to a range in a table (5 replies)
  172. Frustrated need help with Email code Excel, Lotus, Attachements (1 replies)
  173. excel vba error 91 object variable or with block variable not set (3 replies)
  174. [SOLVED:] testing for correlation matrix (2 replies)
  175. [SOLVED:] Help to convert COUNTIFS to VBA (7 replies)
  176. [SOLVED:] Sum values between two specified dates (2 replies)
  177. [SOLVED:] Filter columns from negative values for Histogram Chart (4 replies)
  178. [SOLVED:] Checkbox populated by worksheet cells via userform (0 replies)
  179. VBA date (22 replies)
  180. [SOLVED:] VBA to replace numerical data with Alphnumerical data. (13 replies)
  181. [SOLVED:] macro stops if no data in filterd criteria (2 replies)
  182. Passing Excel macro variable to access macro (1 replies)
  183. [SOLVED:] VBA Help - Code to create a copy of a macro enabled workbook (5 replies)
  184. Identifying Duplicate E-mail Addresses with Different First and Last Names (0 replies)
  185. Move rows that meet criteria of sheet from multiple workbooks to other workbook (VBA) (0 replies)
  186. Speed run time of code (3 replies)
  187. [SOLVED:] Add certain amount of rows to last rows per chapter (1 replies)
  188. Want to search for value in column across multiple sheets and copy rows with value. (2 replies)
  189. Table of Contents: Hyperlinking to Folders Using a Combination of Cells (1 replies)
  190. VBA code for re-organizing address lines (3 replies)
  191. [SOLVED:] In need of help with a code (4 replies)
  192. Sleeper: Sum and Export to PDF (0 replies)
  193. Formatting with hidden columns (2 replies)
  194. Webservice into Excel (2 replies)
  195. [SOLVED:] Dynamic Column In Code (2 replies)
  196. VBA Code Not Working In China? (22 replies)
  197. VBA Importing text files from user specified folder (2 replies)
  198. Search by Multiple Criteria and Two Listboxes (0 replies)
  199. [SOLVED:] VLOOKUP TO GET RESULT AS FORMULA (5 replies)
  200. Change font on a sheet based on a value in a different sheet. (0 replies)
  201. Date selection help please (0 replies)
  202. [SOLVED:] Hide Unnecessary Decimal Markers (5 replies)
  203. Dynamic arrays And Financial Functions (2 replies)
  204. VBA - Finding and copy row with first value >&< certain threshold (1 replies)
  205. Write Data to Embedded Excel Worksheet in Word (5 replies)
  206. [SOLVED:] Re-lock a Column after its been unlocked upon cell exit (3 replies)
  207. [SOLVED:] VBA to delete rows where first 4 words of text in column A are duplicated (2 replies)
  208. How to STOP Excels spell checker from checking text boxes (2 replies)
  209. Combine excel workbooks from multiple folder into one workbook (1 replies)
  210. [SOLVED:] Inserting Files From Multiple Columns - Concatentate Result File (2 replies)
  211. Simulating returns (1 replies)
  212. List text files in folder based on partial file name - repeats first file found (5 replies)
  213. Copy data from userform to sheet using option button (1 replies)
  214. Search for Excel workbook and open (0 replies)
  215. If XLSM in XLSTART, Then Excel doesn't open with blank WB (6 replies)
  216. Prompt message box for importing access table data (6 replies)
  217. download via Microsoft.XMLHTTP fails (7 replies)
  218. VBA Code to control Data Connectin from CSV File (1 replies)
  219. VBA - conditional error with code involving LBound(SheetNameArray) To UBound(SheetNam (8 replies)
  220. [SOLVED:] Conditional formatting without using A1-notation in the rule (3 replies)
  221. HTML scraping/parsing (0 replies)
  222. A Simple Pyramid Totals (6 replies)
  223. Object as Picture and Data Rearrange (4 replies)
  224. [SOLVED:] Toggle Shape Fill & Text Colors (3 replies)
  225. Subscript out of range: Do While Cells(s2, 2) And Cells(s2 + 1, 2) <> "end" (1 replies)
  226. 90 days past due chart (0 replies)
  227. 2 Macros Please Help getting so lost... to delete columns and email files (1 replies)
  228. Cut away days to have only hours : 45841.12 -> 0.12 (1 replies)
  229. One Cell with different Time and Strings (4 replies)
  230. [SOLVED:] Pivot Table Data (7 replies)
  231. VBA using INDEX MATCH (8 replies)
  232. [SOLVED:] Problem with chart (3 replies)
  233. worksheet Names 255 or less byte truncation - bug? (11 replies)
  234. [SOLVED:] Conditional Formatting Help (14 replies)
  235. Book2 Macros interfere with Book1 Copy Book2 Sheet (3 replies)
  236. VBA, where ever the data is found in column BCDEF, macro can still accomplish results (5 replies)
  237. [SOLVED:] How to use VBA Slicer to connect two PivotTable (28 replies)
  238. [SOLVED:] VBA Code Range Issue (3 replies)
  239. [SOLVED:] creating label (0 replies)
  240. newbie needing VBA help (0 replies)
  241. Remove pictures/shapes of PowerPoint with VBA (3 replies)
  242. [SOLVED:] Range Copy/Paste Loop for Multiple Sheets to Multiple Sheets (6 replies)
  243. [SOLVED:] ELSE without IF Error - multiple line breaks including AND and THEN (3 replies)
  244. Print/pdf excel sheet and include a specific word document vba (0 replies)
  245. [SOLVED:] Reference formula help (2 replies)
  246. Excel VBA ~ Google drive doc (3 replies)
  247. How to hide cells based on values (3 replies)
  248. Change the major units in X axes in chart(vba) (1 replies)
  249. VBA - finding date in another worksheet (1 replies)
  250. [SOLVED:] Find first row with two commas and delete (15 replies)