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. Sleeper: Copying a Value to an Addess Reference which is Nested in Another Cell (8 replies)
  2. [SOLVED:] Calculating between 2 worksheets (7 replies)
  3. [SOLVED:] How to remove rows based on filters? (5 replies)
  4. Excel VBA problem on application.inputbox that returns range (4 replies)
  5. [SOLVED:] VBA - hiding column based on value of cell (2 replies)
  6. [SOLVED:] adjusting code search files into folder and sub folder (22 replies)
  7. Filter based on two columns (2 replies)
  8. Total dummy when it comes to VBA, so hoping someone can help! (15 replies)
  9. Calendar to bring the Leave Type from Leave Data to Calendar (3 replies)
  10. [SLEEPER:] Last update field formula on Google sheet (1 replies)
  11. VBA - Count # of cells in Column B that are greater in value than in Column A (2 replies)
  12. [SOLVED:] Value from UserForm to Worksheet - Accounting format - (How to?) (8 replies)
  13. find replace (5 replies)
  14. Hundreds of sheets, trying to loop through and extract specific columns (12 replies)
  15. Need help to Code VBA using the combination of text and date format (2 replies)
  16. [SOLVED:] How to copy the most current file from one folder to another (5 replies)
  17. text in cell in condition (1 replies)
  18. Put NA on cells with dates before indicated start week (5 replies)
  19. Insert new row for breakdown detail data (1 replies)
  20. CommandButton1_automatically update the date in ("A") column (3 replies)
  21. Finding Keywords from Text String - Formula (3 replies)
  22. [SOLVED:] if cell value in range = "code" then copy paste value to last used row another sheet (17 replies)
  23. fixing show message when open workbook from dialog to copy data (6 replies)
  24. [SOLVED:] VBA error: Run time error "424":Object require(pull data from HTML Element) (2 replies)
  25. Hilbert Curve VBA (1 replies)
  26. [SOLVED:] RE: VBA auto filter Iterate through each criteria (1 replies)
  27. [SOLVED:] Sorting one Column in a Table (9 replies)
  28. Maximum Limit for MMULT() (4 replies)
  29. Sum function in other sheet (3 replies)
  30. How to a reference to a new sheet in same workbook (4 replies)
  31. Listbox and name manager comparison (2 replies)
  32. Arrays in VBA errors (2 replies)
  33. Searching for Macro (5 replies)
  34. Userform problem : makes excel crash (2 replies)
  35. [SOLVED:] Userform textbox skipped in tab order after re-enabling - unwanted behaviour (8 replies)
  36. [SOLVED:] ComboBox Function Lost (6 replies)
  37. Target cell vs specific cell (1 replies)
  38. Link organs in an array to shapes as they are created (0 replies)
  39. [SOLVED:] Loop through UserForm Controls and perform Different actions depending on ... (9 replies)
  40. vba help - to make sumifs formula dynamic (0 replies)
  41. Move files from different folders to single folder and delete the original files (5 replies)
  42. [SOLVED:] Display count of months in year which has 31 days in Message Box (3 replies)
  43. Excel 2007 VBA: Having trouble ungrouping a newly loaded object (9 replies)
  44. VBA Code will not update as target cell is updated using a formula (3 replies)
  45. [SOLVED:] VBA progress bar help (5 replies)
  46. Set statement (4 replies)
  47. copy paste the data if condition matches (0 replies)
  48. Cant get VBA Code to work. Would appreciate help. (7 replies)
  49. Need help with Objective Type questions (Quiz) (3 replies)
  50. AutoFill Only Specific Cells (0 replies)
  51. Select last empty row with header (3 replies)
  52. split counting (4 replies)
  53. Using Find function in VBA (7 replies)
  54. Getting Key value from last occurrence of another table (5 replies)
  55. Deleting Duplicates based on Active condition (1 replies)
  56. Copy specific data from a row based on value in column A (6 replies)
  57. Use VBA code in a locked worksheet (3 replies)
  58. refreshing sheet "under" modally shown useform (3 replies)
  59. [SOLVED:] Check if Value Exists in Another Sheet (6 replies)
  60. [SOLVED:] Formulas: If(AND( , OR(NOT(COUNTIF now working correctly (6 replies)
  61. inputbox vs excel shift + space shortcut (2 replies)
  62. [SOLVED:] Clear all items in listbox column (2 replies)
  63. [SOLVED:] Excel 2007: Trying to change images' rotation after loading without selecting first (4 replies)
  64. copy and paste value with condition (7 replies)
  65. Help with vba chart (0 replies)
  66. [SOLVED:] VBA 2007: How to get object name when inserted in order to delete later (14 replies)
  67. copy and rename a folder and its contents based on a cell value. (2 replies)
  68. VBA multiple SQL queries (2 replies)
  69. Data separation (9 replies)
  70. [SOLVED:] Excel filter not working due to blank values in the column (3 replies)
  71. [SOLVED:] COPY/PASTE SPECIFIC DATA INTO GROUPS ON NEW SHEET (4 replies)
  72. Macro Undo Command (9 replies)
  73. Chart legend entries delete reappear (0 replies)
  74. Click Login button using VBA (0 replies)
  75. Replace kill command with save command and be able to format date (0 replies)
  76. Import .txt File with normal Space Delimiters (9 replies)
  77. Filter Specific data (0 replies)
  78. [SOLVED:] Master file detail list (5 replies)
  79. Revising A VBA Code (1 replies)
  80. Generate Condition CSV File (2 replies)
  81. [SOLVED:] Invalid picture (0 replies)
  82. Reading text files and assigning values (2 replies)
  83. [SLEEPER:] VBA Macro to add values by date (2 replies)
  84. Improve Efficiency of VBA Code (21 replies)
  85. [SOLVED:] Change Excel's own user forms, is it possible? (2 replies)
  86. Save multiple ListBoxes to PDF (3 replies)
  87. [SOLVED:] Automatic Timestamp Insertion Application.Undo (3 replies)
  88. RC FORMULA HELP (2 replies)
  89. HELP with Conditional VLOOKUP (1 replies)
  90. Excel chart links in office 2007 (0 replies)
  91. Decipher Macro (1 replies)
  92. Sleeper: Gantt...mouse over (0 replies)
  93. How to Copy-Paste from a dynamic range to fixed one based on cell value using VBA? (3 replies)
  94. Making new EXCEL file with value only by copy from other excel (3 replies)
  95. export and print multipe specific sheets as pdf (15 replies)
  96. get Sunday's date between 2 dates (2 replies)
  97. Command button to go to another sheet with drop button click (1 replies)
  98. [SOLVED:] vba code for an interface (4 replies)
  99. Applying VBA code written in module to all sheets in workbook (3 replies)
  100. Computing Monthly Weighted Average (10 replies)
  101. Header/Footer sticking to other ranges (1 replies)
  102. Save As function randomly replaces my file path, Error 1004 (4 replies)
  103. Worksheet Change event not working unless cell is manually changed (1 replies)
  104. Simple If Statement: Comparing function argument (1 replies)
  105. Workbook.SaveAs function, appends number to similar named files (1 replies)
  106. [SOLVED:] error on Password User form by workbook Entry (9 replies)
  107. Creating a Pivot Table Based on Two Tables (2 replies)
  108. Return specific cell in that row using row number (3 replies)
  109. [SOLVED:] loop and sum (8 replies)
  110. [SOLVED:] Changing Data Layout Excel VBA (2 replies)
  111. [SOLVED:] Searchable listbox - Multi column - additem to second column only works first time (5 replies)
  112. PDF Merger Sequence (0 replies)
  113. Vba, How can code the excel file to save as only and disable to save directly file (2 replies)
  114. Macro works via step through but does not on button click (2 replies)
  115. Getting selected items in embedded listbox (3 replies)
  116. [SOLVED:] Progress Bar VBA (24 replies)
  117. [SOLVED:] simple password protection with User Form, with possibility user can change Passwort. (0 replies)
  118. Importing files will format data (5 replies)
  119. VBA - Search For Value Across Multiple Worksheets (83 replies)
  120. Using userforms (14 replies)
  121. [SOLVED:] Delete worksheet activex listbox (12 replies)
  122. Problem comparing dates in VBA (1 replies)
  123. Graphical hiearchy (7 replies)
  124. Calendar with userform input stores irrelevant data to its table (5 replies)
  125. Sorting Help (2 replies)
  126. [SOLVED:] Conditional Formatting on a table based on a different table VBA (16 replies)
  127. [SOLVED:] VBA - Disable/ activate command button depending on Text box value (3 replies)
  128. [SOLVED:] Delete rows when copying table (7 replies)
  129. [SOLVED:] Ordering worksheet tabs in a specific order (6 replies)
  130. VBA to make formula for parent child (7 replies)
  131. User Form (2 replies)
  132. Rename the add-in caption on menu bar (0 replies)
  133. [SOLVED:] Get All Most Recent Dates per Month in a Single Column VBA (16 replies)
  134. [SOLVED:] Loop through listbox to insert to sheet (6 replies)
  135. I need help on scrolling down web pages through vba query tables (0 replies)
  136. [SOLVED:] PIVOT TABLE TROUBLES - Code runs on one workbook but not the other (2 replies)
  137. Sleeper: Importing multiple files to excel (0 replies)
  138. VBA Newbie looking for linear or polynomial fit to missing dats (19 replies)
  139. [SOLVED:] find listbox column Average (2 replies)
  140. [SOLVED:] sum digits (9 replies)
  141. [SOLVED:] update listbox (4 replies)
  142. PDF to excel (1 replies)
  143. [SOLVED:] Issue creating pivot table from table data (2 replies)
  144. [SOLVED:] Autofit last column in a table (6 replies)
  145. VBA Help using value in sheet 1 to hide unhide row in sheet 2 (9 replies)
  146. [SOLVED:] Excel - Edit contents of a string (7 replies)
  147. [SOLVED:] Excel - Make user opened file the active workbook (13 replies)
  148. [SOLVED:] select next emtpy column (10 replies)
  149. [SOLVED:] Find Last Value (not first) (9 replies)
  150. [SOLVED:] Hide specific rows in various worksheets depending on Summary worksheet cell value (3 replies)
  151. Duplicate Values in Data Validation (7 replies)
  152. VBA Pasting from table to different sheets without using sheets("x").Select HELP!!! (3 replies)
  153. Building up sentence variable within cells (4 replies)
  154. [SOLVED:] concatenate variable values (1 replies)
  155. [SOLVED:] Hide textbox with selected item in combobox (5 replies)
  156. 3 Reference Formulas Not Returning a Result (14 replies)
  157. Hyperlink warning message (9 replies)
  158. [SOLVED:] Complete data of a master table without overwriting given data (12 replies)
  159. Text in textbox only updates once (1 replies)
  160. [SOLVED:] How to set currency with different starting values (68 replies)
  161. Writing array to sheet (10 replies)
  162. After clicking the linked cell to move back linked cell without using F5+Enter (2 replies)
  163. Split comma to rows (15 replies)
  164. [SOLVED:] Insert Picture from Directory on Cell Value Changed by Formula (20 replies)
  165. VBA script to search a text in google maps (0 replies)
  166. Add Table to Data Model (Pivot Table) (0 replies)
  167. Trim rows in multiple sheets (2 replies)
  168. Conditional Formatting using formula as condition (4 replies)
  169. [SOLVED:] How to pull XML data into another excel sheet using VBA? (54 replies)
  170. Cut Data Once It Has Been Selected (3 replies)
  171. [SOLVED:] index/match based on variable range (2 replies)
  172. [SOLVED:] Change font size of rows in a range with bold letters (20 replies)
  173. [SOLVED:] Data Validation based on Condition(s) in Excel VBA (15 replies)
  174. [SOLVED:] Write part of 2D Array to Sheet (3 replies)
  175. [SOLVED:] Putting a time limit on QueryTable.Refresh (1 replies)
  176. [SOLVED:] Part of a string (7 replies)
  177. [SOLVED:] Formula to fill down used range (5 replies)
  178. Only the string (3 replies)
  179. [SOLVED:] Excel Formula to compare between actual values and target values (3 replies)
  180. sumifs filtered data (4 replies)
  181. Basic VBA Function to calculate the volume of a cone (5 replies)
  182. [SOLVED:] Split Cell into multiple column via VBA (8 replies)
  183. [SOLVED:] Excel keeps calculating (3 replies)
  184. [SOLVED:] Creating a single Table with different formulas Excel VBA (78 replies)
  185. [SOLVED:] Copy files by name from a folder to another (5 replies)
  186. code running on more than 1 sheet (2 replies)
  187. Copy to new workbook and remove blank rows (1 replies)
  188. VBA to add numbers in columns from various workbooks (11 replies)
  189. Macro to autofilter data from several sheets in workbook and copy to new worksheet (1 replies)
  190. Set Last Modified date & time to preset value on Save or Save As (9 replies)
  191. VBA MACRO Button click using a class instead of ID (4 replies)
  192. Creating dynamic List on Workbook Startup (13 replies)
  193. Run time error '1004' Cannot access 'Macroed-Upload_Temp.xlsx' (0 replies)
  194. For Each Then Next (5 replies)
  195. Coming to the dark Side (25 replies)
  196. [SOLVED:] First Login Last Logout - Formula (2 replies)
  197. Looping Through Two Columns (9 replies)
  198. vba find the latest date and a corresponding value (7 replies)
  199. [SOLVED:] VBA to select cell in active row (14 replies)
  200. Vba code on looping (0 replies)
  201. [SOLVED:] Macro Copy & Paste: Numeric to Alphanumeric (3 replies)
  202. [Beginner] Select and Cut with conditions (1 replies)
  203. Copy & Paste to the next empy cell. (Vba Code not Working) (1 replies)
  204. How to get dates of all mondays between 2 dates? (5 replies)
  205. copy and paste question (46 replies)
  206. How to copy and insert shapes with increase in series of text inside of shape ie 1,2, (2 replies)
  207. [SOLVED:] Moving data between two sheets VBA (26 replies)
  208. When changing the active worksheet - need VBA that will make it's chart display? (5 replies)
  209. [SOLVED:] Combine countifs & Subtotal (5 replies)
  210. [SOLVED:] Need help copying cells from one sheet to another.. (41 replies)
  211. [SOLVED:] notification by vba (4 replies)
  212. Customer Statement of Account (3 replies)
  213. VBA for New Format (0 replies)
  214. [SOLVED:] insert data for open positions (4 replies)
  215. [SOLVED:] Advance filtering unique records (5 replies)
  216. VBA for inserting Rows with conditions (4 replies)
  217. Early vs. Late Binding (4 replies)
  218. from mastersheet to other sheets (find the last blank raw) (3 replies)
  219. [SOLVED:] Conditional expression (3 replies)
  220. Having troubles with XlFillDefault (4 replies)
  221. [SOLVED:] Create new column (4 replies)
  222. Help automatically refreshing a year using VBA (7 replies)
  223. [SOLVED:] Formatting issues (29 replies)
  224. Consolidate Pivot Table Cache - VBA (1 replies)
  225. VBA to move JPGs from sub-folders to destination folder using a list (0 replies)
  226. Copy files from one Location to another (0 replies)
  227. Creating a Search Concat for Sharepoint files (0 replies)
  228. populate combo box with conditions (5 replies)
  229. VBA Code to highlight Odd and Even numbers (18 replies)
  230. Run macros on whole workbook (2 replies)
  231. Query (0 replies)
  232. Cell equal value new value of active cell which is a drop down (2 replies)
  233. [SOLVED:] Use the same Variable in the module (2 replies)
  234. On time assistance required (2 replies)
  235. Stop save if table has empty cells (3 replies)
  236. Parse text to array (7 replies)
  237. Sleeper: Keep a timestamped log when any worksheet is unprotected? (1 replies)
  238. [SOLVED:] Error 13 - Mismatch in UserForm update Application.Match with mixed Data (2 replies)
  239. [SOLVED:] Copy Workbook Name (7 replies)
  240. Cell back color (3 replies)
  241. [SOLVED:] Update Schedule Sheet with Jobs (1 replies)
  242. [SOLVED:] Named Ranges Error - Please help! (1 replies)
  243. VBA - Macro to open a file based on part of text in cell (15 replies)
  244. [SOLVED:] Conditional Format Calendar Events (1 replies)
  245. Advice on 'OnTime' (4 replies)
  246. Replace non-contiguous column range with Offset column range in Chart SeriesCollectio (0 replies)
  247. [SOLVED:] VBA entering a nested formula with text (4 replies)
  248. [SOLVED:] Calendar Times Not in Order (3 replies)
  249. Create an array removing duplicates from list but keeping last occurence (10 replies)
  250. HELP! Cant figure out how to modify code based on new requirement (3 replies)