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. relative range / Offset within a sum - how to change the range summed (2 replies)
  2. Help on Excel Project (1 replies)
  3. VBA error on copying workbooks from file location (3 replies)
  4. [SOLVED:] Delete Sheet Macro Crashes Excel (3 replies)
  5. Help with code (4 replies)
  6. Edit rows with userform textboxes and coboboxes (2 replies)
  7. Track changes to a column, not when rows are inserted and deleted (4 replies)
  8. VBA for highlighting needs revising (20 replies)
  9. [SOLVED:] VBA appears to be missing something please help!! (8 replies)
  10. Loop Through SubFolders Task - Merge Files as Folder Name (0 replies)
  11. [SOLVED:] Copy and Paste Data from One Tab to Another (2 replies)
  12. [SOLVED:] VBA Calculate Event (5 replies)
  13. [SOLVED:] Need vba macro to highlight duplicates in a column (19 replies)
  14. Different charts in one diagram: chart modification problem (1 replies)
  15. Loop data is not recognized (11 replies)
  16. [SOLVED:] Looping formula (0 replies)
  17. Runtime Error 1004 (0 replies)
  18. Deleting worksheets with specific name ?? (2 replies)
  19. [SOLVED:] Filter question (4 replies)
  20. [SOLVED:] How to populate data from one sheet to another? (5 replies)
  21. Solver VBA code for different objective function cells (2 replies)
  22. [SOLVED:] Conditional Formatting Formula (6 replies)
  23. Solver VBA code for multiple sheets (2 replies)
  24. Advice required to run code faster (3 replies)
  25. [SOLVED:] How to avoid to continue searching (on the same sheet) if specific word is found (4 replies)
  26. [VBA] How to trigger a macro with a letter key without "Ctrl" (1 replies)
  27. Vba İnformation About The Array() Cells() Property (6 replies)
  28. Choose Invoice Number from a userform combobox and copy data to invoice output (1 replies)
  29. Sleeper: Best way to add a column to a range with offset of n (1 replies)
  30. Need Help: Check Sheet Name Exists Before Creating New W/ Same Name (3 replies)
  31. Excel to PPT --- can't detect error in loop (4 replies)
  32. Daily Data for Entire Year - vba userform (5 replies)
  33. Need help creating a formula for multiple sheets of data that will tie into a chart (0 replies)
  34. [SOLVED:] Clear Contents VBA (2 replies)
  35. Copy-paste extracted data in values to reference sheet (VBA) (1 replies)
  36. [SOLVED:] Copy Values from an array into sheet tab names (4 replies)
  37. VBA Coding needs advice - To Simplify (2 replies)
  38. Restrict Duplicate Values in a Row using excel VBA (1 replies)
  39. Change Excel sheet Tab colour when date entered in a cell (4 replies)
  40. How i can exit from compo box after select ? (1 replies)
  41. [SOLVED:] Match Funtion VBA (11 replies)
  42. Checking if other sheets in the workbook contain the same content as a defined cell (0 replies)
  43. [SOLVED:] Workbook closes "by itself" when some macros run or other workbooks opened. (12 replies)
  44. HTTP Response cookies not retrieved in results for XMLHTTP request in EXCEL Macro (0 replies)
  45. [SLEEPER:] Error with Protect and Unprotect through VBA (4 replies)
  46. run time error '1004' Help!!!! (1 replies)
  47. Vlookup with multiple results (5 replies)
  48. [SOLVED:] Run Same VBA Macro Code On Multiple Sheets (9 replies)
  49. Sort files by date in a folder and then use this ordered list to open the files (2 replies)
  50. Finding blank cells in named range and input 0 (4 replies)
  51. Help for VBA Code as too much time while processing (3 replies)
  52. Converting LEFT and RIGHT with FIND formulas to VBA macros including IFERROR (5 replies)
  53. Using Excel VBA i want to protect a range of cells but other cells should be editable (1 replies)
  54. VBA to download images in web (0 replies)
  55. [SOLVED:] Captilize Select Characters Within A Cell (17 replies)
  56. Get the first instance of a value from a range (9 replies)
  57. Passing one function to another (3 replies)
  58. [SOLVED:] Help with Pasting Values (5 replies)
  59. Listing text files based on search value - returns multiple instances of same record (3 replies)
  60. copy data from a range in sheet into rows in another sheet (12 replies)
  61. Creating workbooks/sheets based on a tables in a master workbook (0 replies)
  62. Date picker (2 replies)
  63. Extract data with one criteria and no duplicate (1 replies)
  64. Run-Time Error '1004' Delete method of Range class failed (4 replies)
  65. Paste Special: PasteSpecial method of Range class failed (0 replies)
  66. [SOLVED:] Loop through folder only opens one file (2 replies)
  67. Choosing/listing from existing database (0 replies)
  68. END IF WITHOUT BLOCK IF (6 replies)
  69. Need explanation to save file as (2 replies)
  70. Errors dumping an Array to a range in a table (5 replies)
  71. Frustrated need help with Email code Excel, Lotus, Attachements (1 replies)
  72. excel vba error 91 object variable or with block variable not set (3 replies)
  73. [SOLVED:] testing for correlation matrix (2 replies)
  74. [SOLVED:] Help to convert COUNTIFS to VBA (7 replies)
  75. [SOLVED:] Sum values between two specified dates (2 replies)
  76. [SOLVED:] Filter columns from negative values for Histogram Chart (4 replies)
  77. [SOLVED:] Checkbox populated by worksheet cells via userform (0 replies)
  78. VBA date (22 replies)
  79. [SOLVED:] VBA to replace numerical data with Alphnumerical data. (13 replies)
  80. [SOLVED:] macro stops if no data in filterd criteria (2 replies)
  81. Passing Excel macro variable to access macro (1 replies)
  82. [SOLVED:] VBA Help - Code to create a copy of a macro enabled workbook (5 replies)
  83. Identifying Duplicate E-mail Addresses with Different First and Last Names (0 replies)
  84. Move rows that meet criteria of sheet from multiple workbooks to other workbook (VBA) (0 replies)
  85. Speed run time of code (3 replies)
  86. [SOLVED:] Add certain amount of rows to last rows per chapter (1 replies)
  87. Want to search for value in column across multiple sheets and copy rows with value. (2 replies)
  88. Table of Contents: Hyperlinking to Folders Using a Combination of Cells (1 replies)
  89. VBA code for re-organizing address lines (3 replies)
  90. [SOLVED:] In need of help with a code (4 replies)
  91. Sleeper: Sum and Export to PDF (0 replies)
  92. Formatting with hidden columns (2 replies)
  93. Webservice into Excel (2 replies)
  94. [SOLVED:] Dynamic Column In Code (2 replies)
  95. VBA Code Not Working In China? (22 replies)
  96. VBA Importing text files from user specified folder (2 replies)
  97. Search by Multiple Criteria and Two Listboxes (0 replies)
  98. [SOLVED:] VLOOKUP TO GET RESULT AS FORMULA (5 replies)
  99. Change font on a sheet based on a value in a different sheet. (0 replies)
  100. Date selection help please (0 replies)
  101. [SOLVED:] Hide Unnecessary Decimal Markers (5 replies)
  102. Dynamic arrays And Financial Functions (2 replies)
  103. VBA - Finding and copy row with first value >&< certain threshold (1 replies)
  104. Write Data to Embedded Excel Worksheet in Word (5 replies)
  105. [SOLVED:] Re-lock a Column after its been unlocked upon cell exit (3 replies)
  106. [SOLVED:] VBA to delete rows where first 4 words of text in column A are duplicated (2 replies)
  107. How to STOP Excels spell checker from checking text boxes (2 replies)
  108. Combine excel workbooks from multiple folder into one workbook (1 replies)
  109. [SOLVED:] Inserting Files From Multiple Columns - Concatentate Result File (2 replies)
  110. Simulating returns (1 replies)
  111. List text files in folder based on partial file name - repeats first file found (5 replies)
  112. Copy data from userform to sheet using option button (1 replies)
  113. Search for Excel workbook and open (0 replies)
  114. If XLSM in XLSTART, Then Excel doesn't open with blank WB (6 replies)
  115. Prompt message box for importing access table data (6 replies)
  116. download via Microsoft.XMLHTTP fails (7 replies)
  117. VBA Code to control Data Connectin from CSV File (1 replies)
  118. VBA - conditional error with code involving LBound(SheetNameArray) To UBound(SheetNam (8 replies)
  119. [SOLVED:] Conditional formatting without using A1-notation in the rule (3 replies)
  120. HTML scraping/parsing (0 replies)
  121. A Simple Pyramid Totals (6 replies)
  122. Object as Picture and Data Rearrange (4 replies)
  123. [SOLVED:] Toggle Shape Fill & Text Colors (3 replies)
  124. Subscript out of range: Do While Cells(s2, 2) And Cells(s2 + 1, 2) <> "end" (1 replies)
  125. 90 days past due chart (0 replies)
  126. 2 Macros Please Help getting so lost... to delete columns and email files (1 replies)
  127. [SLEEPER:] Cut away days to have only hours : 45841.12 -> 0.12 (1 replies)
  128. One Cell with different Time and Strings (4 replies)
  129. [SOLVED:] Pivot Table Data (7 replies)
  130. VBA using INDEX MATCH (8 replies)
  131. [SOLVED:] Problem with chart (3 replies)
  132. worksheet Names 255 or less byte truncation - bug? (11 replies)
  133. [SOLVED:] Conditional Formatting Help (14 replies)
  134. Book2 Macros interfere with Book1 Copy Book2 Sheet (3 replies)
  135. VBA, where ever the data is found in column BCDEF, macro can still accomplish results (5 replies)
  136. [SOLVED:] How to use VBA Slicer to connect two PivotTable (28 replies)
  137. [SOLVED:] VBA Code Range Issue (3 replies)
  138. [SOLVED:] creating label (0 replies)
  139. newbie needing VBA help (0 replies)
  140. Remove pictures/shapes of PowerPoint with VBA (3 replies)
  141. [SOLVED:] Range Copy/Paste Loop for Multiple Sheets to Multiple Sheets (6 replies)
  142. [SOLVED:] ELSE without IF Error - multiple line breaks including AND and THEN (3 replies)
  143. Print/pdf excel sheet and include a specific word document vba (0 replies)
  144. [SOLVED:] Reference formula help (2 replies)
  145. Excel VBA ~ Google drive doc (3 replies)
  146. How to hide cells based on values (3 replies)
  147. Change the major units in X axes in chart(vba) (1 replies)
  148. VBA - finding date in another worksheet (1 replies)
  149. [SOLVED:] Find first row with two commas and delete (15 replies)
  150. [SOLVED:] Input 2 files and create 3rd file (4 replies)
  151. [SOLVED:] Multiply two columns and sum a column in Listview (4 replies)
  152. Need VBA code revised to ignore the Column A data, please! (3 replies)
  153. Compress Mutilple Files (0 replies)
  154. Need Help with Excel Project (0 replies)
  155. [SOLVED:] Show UserForm ONLY once workbook is fully open & displayed (15 replies)
  156. [SOLVED:] Adding to Collections (2 replies)
  157. [SOLVED:] How to ignore hidden columns (3 replies)
  158. Highlight 2 Cells Based on a text value(false) (0 replies)
  159. Dialog box, select rows>5, delete in multiple worksheets (17 replies)
  160. Hyperlink Error handling challenges. (7 replies)
  161. [SOLVED:] How DO I remove the FALSE return from this formula to leave an empty cell. (3 replies)
  162. I have a formula that needs to be turned into a VBA, please! (7 replies)
  163. VBA - Connecting to Database using System DSN (0 replies)
  164. CommandButton - Save in multiple locations (1 replies)
  165. [SOLVED:] Need VBA out- put to different location on worksheet. (10 replies)
  166. Moving data labels to variable location on bar chart (2 replies)
  167. Linking equation with a code. (19 replies)
  168. Trouble executing VBA on remote connection (1 replies)
  169. Loop through Pivot Table Filter field from a List and create pdf (7 replies)
  170. [SOLVED:] Remove extra commas from end of content (4 replies)
  171. [SLEEPER:] Update a list rather than just add to (0 replies)
  172. [SOLVED:] Anyone fluent with .Names.Add using values rather than addresses? (advanced) (19 replies)
  173. aggregate Data and create new dashboard (4 replies)
  174. [SOLVED:] ADO - Issue in Excel (2 replies)
  175. [SOLVED:] Data sort a dynamic range? (2 replies)
  176. Sleeper: How to divide time series in to shorter time series in vba (1 replies)
  177. Alternating MsgBox (8 replies)
  178. [SOLVED:] Data sort a dynamic range of conditionally formatted cells? (3 replies)
  179. Specified table rows copy from Sheet to another sheet (0 replies)
  180. Search for Job ID and update fields in row below (0 replies)
  181. Elseif with values of formulas (4 replies)
  182. Autohighlight (0 replies)
  183. Need this to in VBA please the formula used is limited. Thank you (4 replies)
  184. Calendar by BlueCactus not works (22 replies)
  185. [SOLVED:] Select and sort rows based on multiple criteria (1 replies)
  186. [SOLVED:] Renaming a sheet after a cell value that's too long (4 replies)
  187. synthax of Cells.offset.value (2 replies)
  188. Calculate the percentage of those who answered YES (2 replies)
  189. Excel VBA to compare two lists (0 replies)
  190. Expand the Range For Each Cell in Range (3 replies)
  191. Help in VBA problems with Macro (2 replies)
  192. Ribbon Interface Menu builder (5 replies)
  193. Exporting worksheet from a closed workbook in a shared drive to another workbook (1 replies)
  194. [SOLVED:] Help edit data in listview via two Dtpickers (3 replies)
  195. [SOLVED:] Need VBA TO LIST VALUES THAT CORRESPOND VALUES IN GHIJK (14 replies)
  196. [SOLVED:] need VBA to arrange the data from left to right smallest to largest, please! (3 replies)
  197. [SOLVED:] VBA to place combinations from cell to muliple cells essentially un merge them please (4 replies)
  198. Saving & closing (2 replies)
  199. Form 2.0 Frame (1 replies)
  200. A way to filter based on strikethrough formatting? (1 replies)
  201. [SOLVED:] Row Compare - Data not cell (5 replies)
  202. [SOLVED:] "For each ... next" loop not working (2 replies)
  203. Slow dynamic shart update xl2016 (0 replies)
  204. Change list values using VBA (3 replies)
  205. [SOLVED:] Merge Excel files with different yet similar data headers (10 replies)
  206. VBA Assistance - Highlighting and Deleting based on another cell value. (1 replies)
  207. Using And / Or with Conditional Formatting (5 replies)
  208. VBA to login and post in FACEBOOK (11 replies)
  209. VBA assistance (4 replies)
  210. Auto-populate a master list from info in other sheets without adding spaces (1 replies)
  211. [SOLVED:] Take values from different area of a column with a variable range lenght (5 replies)
  212. Loking for a macr to delete first six lines of txt documents (1 replies)
  213. Split Excel sheets to multiple Workbooks based on Criteria in Cell A1 (0 replies)
  214. Interest claculator that allows payments and advances (4 replies)
  215. Define cells and cut them (1 replies)
  216. Save specific Outlook attachment to folder (0 replies)
  217. [SOLVED:] Make formula equal to cell contents of last cell in a column (2 replies)
  218. Email Attachment via Outlook (1 replies)
  219. If a cell is filled up, copy data to the right of cell instead (7 replies)
  220. If cell in column B(tab1), copy tab2 and paste value from column B(tab1) into new tab (1 replies)
  221. Using ADO with Excel (44 replies)
  222. Can't get right code to amend records in listview (3 replies)
  223. [SOLVED:] Need Help with revision of current VBA macro! please! (3 replies)
  224. [SOLVED:] Select Case (0 replies)
  225. [SOLVED:] adding comments to ListColumn tables in Excel with Access VBA (13 replies)
  226. Optomize Code for a Sort and Remove Duplicates Macro (1 replies)
  227. VBA Excel Google Search Scraper/Extract (0 replies)
  228. [SOLVED:] VBA to Paste top rows to bottom 4 rows as values (8 replies)
  229. Check for empty cell in a range of #N/A cells (14 replies)
  230. [SOLVED:] Increase cell value by 1 when workbook opens (3 replies)
  231. [SOLVED:] Sumif using offset in vba (6 replies)
  232. vlookup on temp file (3 replies)
  233. HELP!!! Importing CSV file into excel based on cell value (1 replies)
  234. [SOLVED:] Need help with fixing code - Match FName + LName and highlightcells (9 replies)
  235. cannot add date (1 replies)
  236. Find last column , enter formula to last column skip 3 lines and repeat (4 replies)
  237. "object expected" suddenly popping up (3 replies)
  238. [SOLVED:] VBA to populate row of cells with userform listbox data (code runs by column only) (3 replies)
  239. VBA Interacting With A Child Window (0 replies)
  240. VBA Code: excel is hanging at some point (0 replies)
  241. [SOLVED:] Import Excel Named Ranges into Word with VBA (3 replies)
  242. copy paste macro needs sum function (1 replies)
  243. Compare the value with different name. (4 replies)
  244. Excel Vba Code To Create New Worksheets When Range Is Updated (13 replies)
  245. Excel VBA code to get data from a cell. (1 replies)
  246. Links and Macros Automatically Enabled (1 replies)
  247. [SOLVED:] VBA to transpose rows to column based on values in col A (2 replies)
  248. [SOLVED:] Change listview items font color based on criteria (7 replies)
  249. [SOLVED:] Naming a column B range based on Col A value (3 replies)
  250. Extracting minimum and maximum points above and below moving average (9 replies)