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. [SOLVED:] User forms - Alternatives to Me.Field = "Value" (15 replies)
  2. Code to loop through ws only works on active sheet (12 replies)
  3. [SOLVED:] Locate a set value and copy the value in the cell that's below it (13 replies)
  4. Run time error 438 (2 replies)
  5. Call shortcut only in specific column (1 replies)
  6. [SOLVED:] Copy, Find Match in another worksheet, and then Paste Range (2 replies)
  7. Excel VBA Multiple loops (2 replies)
  8. [SOLVED:] Need assistance copying Cells that just contain certain data (7 replies)
  9. [SOLVED:] SUMPRODUCT HELP? (3 replies)
  10. Looking to make this macro Faster (1 replies)
  11. Auto-expand text rows in protected worksheet - can I do it? (1 replies)
  12. Filter Listbox value marching with Combobox value (1 replies)
  13. Find & Replace - All worksheets except one and with different Target column (2 replies)
  14. Change String (1 replies)
  15. Easy! Need some help, Delete Line from txt file (2 replies)
  16. (Question) Make Subtotal ignore ="" Cells (1 replies)
  17. [SOLVED:] Excel formula syntax (2 replies)
  18. [SOLVED:] RE: copy paste entire pivot data Using VBA (13 replies)
  19. VBA code to copy data from Excel by rows to multiple text files (0 replies)
  20. Help about sorting rows and assigning a new field automatically? (1 replies)
  21. SaveAs2 fileformat/encoding not working ??? (3 replies)
  22. Add-In Buttons Delete When Excel Closes (0 replies)
  23. Filtering a DefinedName that a ComboBox pulls from within a VBA Form (0 replies)
  24. Extracting data from excel VBA (2 replies)
  25. [Question] Dynamic amount of averages (5 replies)
  26. Open specific worksheet and hide all other worksheet (6 replies)
  27. Run-time error 1004: The extract range has a missing or invalid field name (1 replies)
  28. [SOLVED:] Date Not Filtering Correctly (16 replies)
  29. "Run-time error '1004' with .xlt file (0 replies)
  30. VBS for Check the zide and move files (0 replies)
  31. fixing error code get folder names and files names (2 replies)
  32. [SOLVED:] Create a new folder based on cell and copy list of file into created folder (1 replies)
  33. Exiting Command Prompt window from Excel (0 replies)
  34. [SOLVED:] Make code more efficient (5 replies)
  35. [SOLVED:] IF condition is not working with formula (9 replies)
  36. Importing text file into Excel but worksheet names are too long! (1 replies)
  37. Convert Many Invoice Formats to a Standard Format (116 replies)
  38. Counting the number of times a string appears on a filtered worksheet. (10 replies)
  39. Importing Multiple .Txt Files Into Excel Based on the Date Last Modified in VBA (1 replies)
  40. Excel VBA data transfer between workbooks (11 replies)
  41. Basic question - create and fill X new rows based on instances of character in cell (5 replies)
  42. Run macro run by itself (1 replies)
  43. 2007 VBA: Cannot figure out recursion to show all possible paths in a 4 x 4 grid. (6 replies)
  44. [SOLVED:] Copy, Rename and validate multiple excel files (4 replies)
  45. Syntax To QuickSort A Range Of Numbers In An Array (1 replies)
  46. [SOLVED:] Multiple find and replace in Excell sheets (0 replies)
  47. Auto populate table from another worksheet (10 replies)
  48. Is there any way to create a macro to keep doing nonlinear regressions? (0 replies)
  49. Finding IDs (1 replies)
  50. Search for Strings Listed in Column A and Insert Offset values in B (1 replies)
  51. If statement help (1 replies)
  52. [SOLVED:] Looping through Dates to Determine in Date Falls Between Other Dates (9 replies)
  53. [SOLVED:] Fuzzy Lookup add-in VBA (12 replies)
  54. [SOLVED:] VBA Coding Help for Conditional Formatting (2 replies)
  55. random selection from a growing range (3 replies)
  56. Vlookup to delete entire row on another worksheet (3 replies)
  57. [SOLVED:] Use dropdown to populate other cells (2 replies)
  58. Intellisense working Sporadically (2 replies)
  59. [SOLVED:] Sequentially Number Search Using an Array (4 replies)
  60. [SOLVED:] AutoFilter Percent Values +-5% (38 replies)
  61. Macro wont run on duplicate columns (2 replies)
  62. Workbook open event not working (14 replies)
  63. Help to check string of file name, if meet will copy valu to master workbook (0 replies)
  64. Macro or form based solution for attached excel sheet (2 replies)
  65. Create New Folder Based on Cell Name and Copy Files into it (5 replies)
  66. help needed to calculate dates and time together (7 replies)
  67. Excel VBA with Advanced Filter Error messages (11 replies)
  68. [SOLVED:] Count number of occurrences via combobox in user form (3 replies)
  69. Export to PDF (specific sheets) if cells in Input sheet are >0, if condition is met (2 replies)
  70. [SOLVED:] 2007 Formula: Trying to locate a numeric value in a square named range. (4 replies)
  71. open file with vba (2 replies)
  72. Help with Debugging Code (0 replies)
  73. 2007: Issue with graphics shifting when saving to a PDF. (6 replies)
  74. Trying to rename individual shapes within a duplicated group. (2 replies)
  75. Update image/replace image from excel to PowerPoint (0 replies)
  76. Concatenate Values (0 replies)
  77. packing list serial number generator for boxes (9 replies)
  78. Adding and Activating Reference (3 replies)
  79. Convert Text to cells Sentences by Punctuation Marks (21 replies)
  80. Pivot Table Copy Paste 5 Days in a Row (0 replies)
  81. create a cubic grid shell in VBA (1 replies)
  82. 'Cascading' comboboxes (2 replies)
  83. If Checkbox is checked, display message... If checkbox is unchecked, do nothing (4 replies)
  84. [SOLVED:] loop through range inserting sum formulas based on start and end indicators (text) (1 replies)
  85. Updating VBA code to Paste Values only (2 replies)
  86. [SOLVED:] Loop Vlookup for each cell in range from another worksheet (2 replies)
  87. [SOLVED:] Highlight minimum value ignoring 0 (7 replies)
  88. Error checking on existing roster (4 replies)
  89. Folder and cell value (0 replies)
  90. XML Map Export and Save (0 replies)
  91. transfer if there are no blank cells (0 replies)
  92. Assistance needed for converting formula in Array VBA. (2 replies)
  93. vlookup from Last Modified File in Folder (0 replies)
  94. Refresh item data in IRibbon combo box (0 replies)
  95. Worksheet object onClickEvent with changing cells issue (1 replies)
  96. [SOLVED:] Help to amend vba to highlight any cells where file paths do not exists (2 replies)
  97. Dynamic dropdownlist from productlist (2 replies)
  98. Insert Multiple Picture into excel thru vba (3 replies)
  99. Copying vales with their number format from Excel into a word table (0 replies)
  100. [SOLVED:] Using Application.Run (4 replies)
  101. [SOLVED:] sum data based on dates from sheet to another (4 replies)
  102. How do I link a cell to 2 non-bold cells and 1 bold cell and keep that formatting? (13 replies)
  103. Excel pivot fields recognition issue (0 replies)
  104. Convert Excel range into HTML table (2 replies)
  105. Automatically Printing Autofilters / loop through all filter values then print vba (1 replies)
  106. Advice needed to speed up Painting code based on defined colors. (12 replies)
  107. Index Match to Determine Paste Location (1 replies)
  108. [SOLVED:] Object Required Error when Selecting Range (1 replies)
  109. [SOLVED:] Anomaly With Formula (1 replies)
  110. User Form error (4 replies)
  111. VBA Help (0 replies)
  112. [SOLVED:] copying images from one folder and pasting in another based on schedule in excel file (4 replies)
  113. Combine specific sheets from multiple workbooks into 1 workbook. (12 replies)
  114. [SOLVED:] 3 columns matched create report (1 replies)
  115. [SOLVED:] Dynamic Array not Resizing (3 replies)
  116. [SOLVED:] VBA to Find Maximum Value in a Range (3 replies)
  117. [SOLVED:] Formula assistance required. (8 replies)
  118. Adding a sum total to a Ron de Bruin VBA to email workbooks (1 replies)
  119. Copy data range to a new workbook (2 replies)
  120. OLAP pivot table vba filtering using VisibleItemsList (1 replies)
  121. [SOLVED:] Changing numbers with scientific notation (E+) in pivot table created by VBA (5 replies)
  122. [SOLVED:] Find column header (1 replies)
  123. VBA Copy paste Images from one cell to another cell on a different sheet (0 replies)
  124. Duplicating Multiple sheets to all workbooks in folder (1 replies)
  125. VB on Time (3 replies)
  126. [SOLVED:] VBA -Identify blank fields for user form before submitting -Force User to add data (7 replies)
  127. Transpose 1 Column to Multiple Rows/Columns (2 replies)
  128. Put NA on week dates IN RANGE (0 replies)
  129. Roster Automation (0 replies)
  130. VBA - Opening File with Yesterday's Date (1 replies)
  131. Count number of users active each mont (0 replies)
  132. Text Wrapping - Stuck for a solution (1 replies)
  133. VBA to arrange response value in large database (4 replies)
  134. [SOLVED:] Return to Cell in Column A after entering value in Column Z (2 replies)
  135. Validata Lists using offset, match and counta formulas - Different Sheets (0 replies)
  136. Does Excel 2007 SP3 work without issue on Windows 10? (2 replies)
  137. create uninterrupted sequences of 2,3,4,5,6,7,8. from 01 to 25 goal. (3 replies)
  138. How to subtract number of hours from 24 hour timezone in alphanumeric format (9 replies)
  139. VBA Code to pull data dynamically from multiple sheet tabs (0 replies)
  140. Looking to condense data with quantity totals (5 replies)
  141. Sleeper: Compare two sets of data with multiple conditions (0 replies)
  142. Excel VBA to create a series of new pivot tables (3 replies)
  143. Search in Excel specific word, delete all rows who does not have that word (1 replies)
  144. Transfer the values from one sheet to another by adding them to below of previous row (1 replies)
  145. Single & Double-Click a Shape Object (2 replies)
  146. [SOLVED:] transferring a column from sheet to sheet with the help of button (3 replies)
  147. Perform action with dynamic ActiveX button (0 replies)
  148. Assigning a value to the specified cells? (1 replies)
  149. Change all Workbook Connection Strings (4 replies)
  150. [SOLVED:] Stacked Chart Percentages (1 replies)
  151. Convert a formula to UDF Function (17 replies)
  152. Sleeper: Copying a Value to an Addess Reference which is Nested in Another Cell (8 replies)
  153. [SOLVED:] Calculating between 2 worksheets (7 replies)
  154. [SOLVED:] How to remove rows based on filters? (5 replies)
  155. Excel VBA problem on application.inputbox that returns range (4 replies)
  156. [SOLVED:] VBA - hiding column based on value of cell (2 replies)
  157. [SOLVED:] adjusting code search files into folder and sub folder (22 replies)
  158. Filter based on two columns (2 replies)
  159. Total dummy when it comes to VBA, so hoping someone can help! (15 replies)
  160. Calendar to bring the Leave Type from Leave Data to Calendar (3 replies)
  161. [SLEEPER:] Last update field formula on Google sheet (1 replies)
  162. VBA - Count # of cells in Column B that are greater in value than in Column A (2 replies)
  163. [SOLVED:] Value from UserForm to Worksheet - Accounting format - (How to?) (8 replies)
  164. find replace (5 replies)
  165. Hundreds of sheets, trying to loop through and extract specific columns (12 replies)
  166. Need help to Code VBA using the combination of text and date format (2 replies)
  167. [SOLVED:] How to copy the most current file from one folder to another (5 replies)
  168. text in cell in condition (1 replies)
  169. Put NA on cells with dates before indicated start week (5 replies)
  170. Insert new row for breakdown detail data (1 replies)
  171. CommandButton1_automatically update the date in ("A") column (3 replies)
  172. Finding Keywords from Text String - Formula (3 replies)
  173. [SOLVED:] if cell value in range = "code" then copy paste value to last used row another sheet (17 replies)
  174. fixing show message when open workbook from dialog to copy data (6 replies)
  175. [SOLVED:] VBA error: Run time error "424":Object require(pull data from HTML Element) (2 replies)
  176. Hilbert Curve VBA (1 replies)
  177. [SOLVED:] RE: VBA auto filter Iterate through each criteria (1 replies)
  178. [SOLVED:] Sorting one Column in a Table (9 replies)
  179. Maximum Limit for MMULT() (4 replies)
  180. Sum function in other sheet (3 replies)
  181. How to a reference to a new sheet in same workbook (4 replies)
  182. Listbox and name manager comparison (2 replies)
  183. Arrays in VBA errors (2 replies)
  184. Searching for Macro (5 replies)
  185. Userform problem : makes excel crash (2 replies)
  186. [SOLVED:] Userform textbox skipped in tab order after re-enabling - unwanted behaviour (8 replies)
  187. [SOLVED:] ComboBox Function Lost (6 replies)
  188. Target cell vs specific cell (1 replies)
  189. Link organs in an array to shapes as they are created (0 replies)
  190. [SOLVED:] Loop through UserForm Controls and perform Different actions depending on ... (9 replies)
  191. vba help - to make sumifs formula dynamic (0 replies)
  192. Move files from different folders to single folder and delete the original files (5 replies)
  193. [SOLVED:] Display count of months in year which has 31 days in Message Box (3 replies)
  194. Excel 2007 VBA: Having trouble ungrouping a newly loaded object (9 replies)
  195. VBA Code will not update as target cell is updated using a formula (3 replies)
  196. [SOLVED:] VBA progress bar help (5 replies)
  197. Set statement (4 replies)
  198. copy paste the data if condition matches (0 replies)
  199. Cant get VBA Code to work. Would appreciate help. (7 replies)
  200. Need help with Objective Type questions (Quiz) (3 replies)
  201. AutoFill Only Specific Cells (0 replies)
  202. Select last empty row with header (3 replies)
  203. split counting (4 replies)
  204. Using Find function in VBA (7 replies)
  205. Getting Key value from last occurrence of another table (5 replies)
  206. Deleting Duplicates based on Active condition (1 replies)
  207. Copy specific data from a row based on value in column A (6 replies)
  208. Use VBA code in a locked worksheet (3 replies)
  209. refreshing sheet "under" modally shown useform (3 replies)
  210. [SOLVED:] Check if Value Exists in Another Sheet (6 replies)
  211. [SOLVED:] Formulas: If(AND( , OR(NOT(COUNTIF now working correctly (6 replies)
  212. inputbox vs excel shift + space shortcut (2 replies)
  213. [SOLVED:] Clear all items in listbox column (2 replies)
  214. [SOLVED:] Excel 2007: Trying to change images' rotation after loading without selecting first (4 replies)
  215. copy and paste value with condition (7 replies)
  216. Help with vba chart (0 replies)
  217. [SOLVED:] VBA 2007: How to get object name when inserted in order to delete later (14 replies)
  218. copy and rename a folder and its contents based on a cell value. (2 replies)
  219. VBA multiple SQL queries (2 replies)
  220. Data separation (9 replies)
  221. [SOLVED:] Excel filter not working due to blank values in the column (3 replies)
  222. [SOLVED:] COPY/PASTE SPECIFIC DATA INTO GROUPS ON NEW SHEET (4 replies)
  223. Macro Undo Command (9 replies)
  224. Chart legend entries delete reappear (0 replies)
  225. Click Login button using VBA (0 replies)
  226. Replace kill command with save command and be able to format date (0 replies)
  227. Import .txt File with normal Space Delimiters (9 replies)
  228. Filter Specific data (0 replies)
  229. [SOLVED:] Master file detail list (5 replies)
  230. Revising A VBA Code (1 replies)
  231. Generate Condition CSV File (2 replies)
  232. [SOLVED:] Invalid picture (0 replies)
  233. Reading text files and assigning values (2 replies)
  234. VBA Macro to add values by date (2 replies)
  235. Improve Efficiency of VBA Code (21 replies)
  236. [SOLVED:] Change Excel's own user forms, is it possible? (2 replies)
  237. Save multiple ListBoxes to PDF (3 replies)
  238. [SOLVED:] Automatic Timestamp Insertion Application.Undo (3 replies)
  239. RC FORMULA HELP (2 replies)
  240. HELP with Conditional VLOOKUP (1 replies)
  241. Excel chart links in office 2007 (0 replies)
  242. Decipher Macro (1 replies)
  243. Sleeper: Gantt...mouse over (0 replies)
  244. How to Copy-Paste from a dynamic range to fixed one based on cell value using VBA? (3 replies)
  245. Making new EXCEL file with value only by copy from other excel (3 replies)
  246. export and print multipe specific sheets as pdf (15 replies)
  247. get Sunday's date between 2 dates (2 replies)
  248. Command button to go to another sheet with drop button click (1 replies)
  249. [SOLVED:] vba code for an interface (4 replies)
  250. Applying VBA code written in module to all sheets in workbook (3 replies)