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. If Checkbox is checked, display message... If checkbox is unchecked, do nothing (4 replies)
  2. [SOLVED:] loop through range inserting sum formulas based on start and end indicators (text) (1 replies)
  3. Updating VBA code to Paste Values only (2 replies)
  4. [SOLVED:] Loop Vlookup for each cell in range from another worksheet (2 replies)
  5. [SOLVED:] Highlight minimum value ignoring 0 (7 replies)
  6. Error checking on existing roster (4 replies)
  7. [SLEEPER:] Folder and cell value (0 replies)
  8. XML Map Export and Save (0 replies)
  9. transfer if there are no blank cells (0 replies)
  10. Assistance needed for converting formula in Array VBA. (2 replies)
  11. vlookup from Last Modified File in Folder (0 replies)
  12. Refresh item data in IRibbon combo box (0 replies)
  13. [SLEEPER:] Worksheet object onClickEvent with changing cells issue (1 replies)
  14. [SOLVED:] Help to amend vba to highlight any cells where file paths do not exists (2 replies)
  15. Dynamic dropdownlist from productlist (2 replies)
  16. Insert Multiple Picture into excel thru vba (3 replies)
  17. Copying vales with their number format from Excel into a word table (0 replies)
  18. [SOLVED:] Using Application.Run (4 replies)
  19. [SOLVED:] sum data based on dates from sheet to another (4 replies)
  20. How do I link a cell to 2 non-bold cells and 1 bold cell and keep that formatting? (13 replies)
  21. Excel pivot fields recognition issue (0 replies)
  22. Convert Excel range into HTML table (2 replies)
  23. Automatically Printing Autofilters / loop through all filter values then print vba (1 replies)
  24. Advice needed to speed up Painting code based on defined colors. (12 replies)
  25. Index Match to Determine Paste Location (1 replies)
  26. [SOLVED:] Object Required Error when Selecting Range (1 replies)
  27. [SOLVED:] Anomaly With Formula (1 replies)
  28. User Form error (4 replies)
  29. VBA Help (0 replies)
  30. [SOLVED:] copying images from one folder and pasting in another based on schedule in excel file (4 replies)
  31. Combine specific sheets from multiple workbooks into 1 workbook. (12 replies)
  32. [SOLVED:] 3 columns matched create report (1 replies)
  33. [SOLVED:] Dynamic Array not Resizing (3 replies)
  34. [SOLVED:] VBA to Find Maximum Value in a Range (3 replies)
  35. [SOLVED:] Formula assistance required. (8 replies)
  36. [SLEEPER:] Adding a sum total to a Ron de Bruin VBA to email workbooks (1 replies)
  37. Copy data range to a new workbook (2 replies)
  38. OLAP pivot table vba filtering using VisibleItemsList (1 replies)
  39. [SOLVED:] Changing numbers with scientific notation (E+) in pivot table created by VBA (5 replies)
  40. [SOLVED:] Find column header (1 replies)
  41. VBA Copy paste Images from one cell to another cell on a different sheet (0 replies)
  42. Duplicating Multiple sheets to all workbooks in folder (1 replies)
  43. VB on Time (3 replies)
  44. [SOLVED:] VBA -Identify blank fields for user form before submitting -Force User to add data (7 replies)
  45. Transpose 1 Column to Multiple Rows/Columns (2 replies)
  46. Put NA on week dates IN RANGE (0 replies)
  47. Roster Automation (0 replies)
  48. VBA - Opening File with Yesterday's Date (1 replies)
  49. Count number of users active each mont (0 replies)
  50. Text Wrapping - Stuck for a solution (1 replies)
  51. VBA to arrange response value in large database (4 replies)
  52. [SOLVED:] Return to Cell in Column A after entering value in Column Z (2 replies)
  53. Validata Lists using offset, match and counta formulas - Different Sheets (0 replies)
  54. Does Excel 2007 SP3 work without issue on Windows 10? (2 replies)
  55. create uninterrupted sequences of 2,3,4,5,6,7,8. from 01 to 25 goal. (3 replies)
  56. How to subtract number of hours from 24 hour timezone in alphanumeric format (9 replies)
  57. VBA Code to pull data dynamically from multiple sheet tabs (0 replies)
  58. Looking to condense data with quantity totals (5 replies)
  59. Sleeper: Compare two sets of data with multiple conditions (0 replies)
  60. [SOLVED:] Excel VBA to create a series of new pivot tables (3 replies)
  61. Search in Excel specific word, delete all rows who does not have that word (1 replies)
  62. Transfer the values from one sheet to another by adding them to below of previous row (1 replies)
  63. Single & Double-Click a Shape Object (2 replies)
  64. [SOLVED:] transferring a column from sheet to sheet with the help of button (3 replies)
  65. Perform action with dynamic ActiveX button (0 replies)
  66. Assigning a value to the specified cells? (1 replies)
  67. Change all Workbook Connection Strings (4 replies)
  68. [SOLVED:] Stacked Chart Percentages (1 replies)
  69. Convert a formula to UDF Function (17 replies)
  70. Sleeper: Copying a Value to an Addess Reference which is Nested in Another Cell (8 replies)
  71. [SOLVED:] Calculating between 2 worksheets (7 replies)
  72. [SOLVED:] How to remove rows based on filters? (5 replies)
  73. Excel VBA problem on application.inputbox that returns range (4 replies)
  74. [SOLVED:] VBA - hiding column based on value of cell (2 replies)
  75. [SOLVED:] adjusting code search files into folder and sub folder (22 replies)
  76. Filter based on two columns (2 replies)
  77. Total dummy when it comes to VBA, so hoping someone can help! (15 replies)
  78. Calendar to bring the Leave Type from Leave Data to Calendar (3 replies)
  79. [SLEEPER:] Last update field formula on Google sheet (1 replies)
  80. VBA - Count # of cells in Column B that are greater in value than in Column A (2 replies)
  81. [SOLVED:] Value from UserForm to Worksheet - Accounting format - (How to?) (8 replies)
  82. find replace (5 replies)
  83. Hundreds of sheets, trying to loop through and extract specific columns (12 replies)
  84. Need help to Code VBA using the combination of text and date format (2 replies)
  85. [SOLVED:] How to copy the most current file from one folder to another (5 replies)
  86. text in cell in condition (1 replies)
  87. Put NA on cells with dates before indicated start week (5 replies)
  88. Insert new row for breakdown detail data (1 replies)
  89. CommandButton1_automatically update the date in ("A") column (3 replies)
  90. Finding Keywords from Text String - Formula (3 replies)
  91. [SOLVED:] if cell value in range = "code" then copy paste value to last used row another sheet (17 replies)
  92. fixing show message when open workbook from dialog to copy data (6 replies)
  93. [SOLVED:] VBA error: Run time error "424":Object require(pull data from HTML Element) (2 replies)
  94. [SLEEPER:] Hilbert Curve VBA (1 replies)
  95. [SOLVED:] RE: VBA auto filter Iterate through each criteria (1 replies)
  96. [SOLVED:] Sorting one Column in a Table (9 replies)
  97. Maximum Limit for MMULT() (4 replies)
  98. Sum function in other sheet (3 replies)
  99. How to a reference to a new sheet in same workbook (4 replies)
  100. Listbox and name manager comparison (2 replies)
  101. Arrays in VBA errors (2 replies)
  102. Searching for Macro (5 replies)
  103. Userform problem : makes excel crash (2 replies)
  104. [SOLVED:] Userform textbox skipped in tab order after re-enabling - unwanted behaviour (8 replies)
  105. [SOLVED:] ComboBox Function Lost (6 replies)
  106. Target cell vs specific cell (1 replies)
  107. Link organs in an array to shapes as they are created (0 replies)
  108. [SOLVED:] Loop through UserForm Controls and perform Different actions depending on ... (9 replies)
  109. vba help - to make sumifs formula dynamic (0 replies)
  110. Move files from different folders to single folder and delete the original files (5 replies)
  111. [SOLVED:] Display count of months in year which has 31 days in Message Box (3 replies)
  112. Excel 2007 VBA: Having trouble ungrouping a newly loaded object (9 replies)
  113. VBA Code will not update as target cell is updated using a formula (3 replies)
  114. [SOLVED:] VBA progress bar help (5 replies)
  115. Set statement (4 replies)
  116. copy paste the data if condition matches (0 replies)
  117. Cant get VBA Code to work. Would appreciate help. (7 replies)
  118. Need help with Objective Type questions (Quiz) (3 replies)
  119. AutoFill Only Specific Cells (0 replies)
  120. Select last empty row with header (3 replies)
  121. split counting (4 replies)
  122. Using Find function in VBA (7 replies)
  123. Getting Key value from last occurrence of another table (5 replies)
  124. Deleting Duplicates based on Active condition (1 replies)
  125. Copy specific data from a row based on value in column A (6 replies)
  126. Use VBA code in a locked worksheet (3 replies)
  127. refreshing sheet "under" modally shown useform (3 replies)
  128. [SOLVED:] Check if Value Exists in Another Sheet (6 replies)
  129. [SOLVED:] Formulas: If(AND( , OR(NOT(COUNTIF now working correctly (6 replies)
  130. inputbox vs excel shift + space shortcut (2 replies)
  131. [SOLVED:] Clear all items in listbox column (2 replies)
  132. [SOLVED:] Excel 2007: Trying to change images' rotation after loading without selecting first (4 replies)
  133. copy and paste value with condition (7 replies)
  134. Help with vba chart (0 replies)
  135. [SOLVED:] VBA 2007: How to get object name when inserted in order to delete later (14 replies)
  136. copy and rename a folder and its contents based on a cell value. (2 replies)
  137. [SLEEPER:] VBA multiple SQL queries (2 replies)
  138. Data separation (9 replies)
  139. [SOLVED:] Excel filter not working due to blank values in the column (3 replies)
  140. [SOLVED:] COPY/PASTE SPECIFIC DATA INTO GROUPS ON NEW SHEET (4 replies)
  141. Macro Undo Command (9 replies)
  142. Chart legend entries delete reappear (0 replies)
  143. Click Login button using VBA (0 replies)
  144. Replace kill command with save command and be able to format date (0 replies)
  145. Import .txt File with normal Space Delimiters (9 replies)
  146. Filter Specific data (0 replies)
  147. [SOLVED:] Master file detail list (5 replies)
  148. [SLEEPER:] Revising A VBA Code (1 replies)
  149. Generate Condition CSV File (2 replies)
  150. [SOLVED:] Invalid picture (0 replies)
  151. Reading text files and assigning values (2 replies)
  152. [SLEEPER:] VBA Macro to add values by date (2 replies)
  153. Improve Efficiency of VBA Code (21 replies)
  154. [SOLVED:] Change Excel's own user forms, is it possible? (2 replies)
  155. Save multiple ListBoxes to PDF (3 replies)
  156. [SOLVED:] Automatic Timestamp Insertion Application.Undo (3 replies)
  157. RC FORMULA HELP (2 replies)
  158. HELP with Conditional VLOOKUP (1 replies)
  159. Excel chart links in office 2007 (0 replies)
  160. Decipher Macro (1 replies)
  161. Sleeper: Gantt...mouse over (0 replies)
  162. How to Copy-Paste from a dynamic range to fixed one based on cell value using VBA? (3 replies)
  163. Making new EXCEL file with value only by copy from other excel (3 replies)
  164. export and print multipe specific sheets as pdf (15 replies)
  165. get Sunday's date between 2 dates (2 replies)
  166. Command button to go to another sheet with drop button click (1 replies)
  167. [SOLVED:] vba code for an interface (4 replies)
  168. Applying VBA code written in module to all sheets in workbook (3 replies)
  169. Computing Monthly Weighted Average (10 replies)
  170. Header/Footer sticking to other ranges (1 replies)
  171. Save As function randomly replaces my file path, Error 1004 (4 replies)
  172. Worksheet Change event not working unless cell is manually changed (1 replies)
  173. Simple If Statement: Comparing function argument (1 replies)
  174. Workbook.SaveAs function, appends number to similar named files (1 replies)
  175. [SOLVED:] error on Password User form by workbook Entry (9 replies)
  176. Creating a Pivot Table Based on Two Tables (2 replies)
  177. Return specific cell in that row using row number (3 replies)
  178. [SOLVED:] loop and sum (8 replies)
  179. [SOLVED:] Changing Data Layout Excel VBA (2 replies)
  180. [SOLVED:] Searchable listbox - Multi column - additem to second column only works first time (5 replies)
  181. PDF Merger Sequence (0 replies)
  182. Vba, How can code the excel file to save as only and disable to save directly file (2 replies)
  183. Macro works via step through but does not on button click (2 replies)
  184. Getting selected items in embedded listbox (3 replies)
  185. [SOLVED:] Progress Bar VBA (24 replies)
  186. [SOLVED:] simple password protection with User Form, with possibility user can change Passwort. (0 replies)
  187. Importing files will format data (5 replies)
  188. VBA - Search For Value Across Multiple Worksheets (83 replies)
  189. Using userforms (14 replies)
  190. [SOLVED:] Delete worksheet activex listbox (12 replies)
  191. Problem comparing dates in VBA (1 replies)
  192. Graphical hiearchy (7 replies)
  193. Calendar with userform input stores irrelevant data to its table (5 replies)
  194. Sorting Help (2 replies)
  195. [SOLVED:] Conditional Formatting on a table based on a different table VBA (16 replies)
  196. [SOLVED:] VBA - Disable/ activate command button depending on Text box value (3 replies)
  197. [SOLVED:] Delete rows when copying table (7 replies)
  198. [SOLVED:] Ordering worksheet tabs in a specific order (6 replies)
  199. VBA to make formula for parent child (7 replies)
  200. User Form (2 replies)
  201. Rename the add-in caption on menu bar (0 replies)
  202. [SOLVED:] Get All Most Recent Dates per Month in a Single Column VBA (16 replies)
  203. [SOLVED:] Loop through listbox to insert to sheet (6 replies)
  204. I need help on scrolling down web pages through vba query tables (0 replies)
  205. [SOLVED:] PIVOT TABLE TROUBLES - Code runs on one workbook but not the other (2 replies)
  206. Sleeper: Importing multiple files to excel (0 replies)
  207. VBA Newbie looking for linear or polynomial fit to missing dats (19 replies)
  208. [SOLVED:] find listbox column Average (2 replies)
  209. [SOLVED:] sum digits (9 replies)
  210. [SOLVED:] update listbox (4 replies)
  211. PDF to excel (1 replies)
  212. [SOLVED:] Issue creating pivot table from table data (2 replies)
  213. [SOLVED:] Autofit last column in a table (6 replies)
  214. VBA Help using value in sheet 1 to hide unhide row in sheet 2 (9 replies)
  215. [SOLVED:] Excel - Edit contents of a string (7 replies)
  216. [SOLVED:] Excel - Make user opened file the active workbook (13 replies)
  217. [SOLVED:] select next emtpy column (10 replies)
  218. [SOLVED:] Find Last Value (not first) (9 replies)
  219. [SOLVED:] Hide specific rows in various worksheets depending on Summary worksheet cell value (3 replies)
  220. Duplicate Values in Data Validation (7 replies)
  221. VBA Pasting from table to different sheets without using sheets("x").Select HELP!!! (3 replies)
  222. Building up sentence variable within cells (4 replies)
  223. [SOLVED:] concatenate variable values (1 replies)
  224. [SOLVED:] Hide textbox with selected item in combobox (5 replies)
  225. 3 Reference Formulas Not Returning a Result (14 replies)
  226. Hyperlink warning message (9 replies)
  227. [SOLVED:] Complete data of a master table without overwriting given data (12 replies)
  228. Text in textbox only updates once (1 replies)
  229. [SOLVED:] How to set currency with different starting values (68 replies)
  230. Writing array to sheet (10 replies)
  231. After clicking the linked cell to move back linked cell without using F5+Enter (2 replies)
  232. Split comma to rows (15 replies)
  233. [SOLVED:] Insert Picture from Directory on Cell Value Changed by Formula (20 replies)
  234. VBA script to search a text in google maps (0 replies)
  235. Add Table to Data Model (Pivot Table) (0 replies)
  236. Trim rows in multiple sheets (2 replies)
  237. Conditional Formatting using formula as condition (4 replies)
  238. [SOLVED:] How to pull XML data into another excel sheet using VBA? (54 replies)
  239. Cut Data Once It Has Been Selected (3 replies)
  240. [SOLVED:] index/match based on variable range (2 replies)
  241. [SOLVED:] Change font size of rows in a range with bold letters (20 replies)
  242. [SOLVED:] Data Validation based on Condition(s) in Excel VBA (15 replies)
  243. [SOLVED:] Write part of 2D Array to Sheet (3 replies)
  244. [SOLVED:] Putting a time limit on QueryTable.Refresh (1 replies)
  245. [SOLVED:] Part of a string (7 replies)
  246. [SOLVED:] Formula to fill down used range (5 replies)
  247. Only the string (3 replies)
  248. [SOLVED:] Excel Formula to compare between actual values and target values (3 replies)
  249. sumifs filtered data (4 replies)
  250. Basic VBA Function to calculate the volume of a cone (5 replies)