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. INDEX MATCH with 2 range criteria in the same sheet (1 replies)
  2. Copying data from one sheet to another (6 replies)
  3. vba array /loop help (4 replies)
  4. [SOLVED:] VBA Macro to select and bring back a new campaign code (5 replies)
  5. Macro to Insert Objects from folders and move it to respective Sheets (3 replies)
  6. Infinite VBA Loop (16 replies)
  7. [SOLVED:] VBA help please (2 replies)
  8. [SOLVED:] VBA Before Double-Click Event executing when not desirable (5 replies)
  9. Variable x,y axis scales, series names and chart title (1 replies)
  10. Chart with Dynamic Row and Column Count Help needed (3 replies)
  11. Download Csv file from the Website VBA (0 replies)
  12. OptionButton LinkedCell trouble (8 replies)
  13. copy entire row from sheet1 into sheet2 if ID matches and column header should match (7 replies)
  14. [SOLVED:] Delete the value of cell that start by char with exception . (4 replies)
  15. [SOLVED:] Vba how to check workbook name first before opening it (2 replies)
  16. [SOLVED:] Random Numbers Looping Thru and Displaying Values (17 replies)
  17. Form created in worksheet, using macro to submit the info to second sheet (1 replies)
  18. Macro to open workbook copy data from workbook 1 and paste in workbook 2 and repeat. (5 replies)
  19. MultiPage - Run-time error 35788: (3 replies)
  20. Application.Goto not working in immediate window (2 replies)
  21. Split cells data in below rows with other data. (2 replies)
  22. VBA Combining Data from Multiple Workbook into One - Need help ASAP (2 replies)
  23. [SOLVED:] TMP file not found error when creating multiple workbooks in a loop (27 replies)
  24. [SLEEPER:] Makes bold a chosen word in a cell (8 replies)
  25. [SOLVED:] VBA Error run time 1004: Application-defined or object-defined error (6 replies)
  26. excel vba change cell color based on a number value in a range (3 replies)
  27. VBA to carry out Simpson's Rule for Tabulated (Equispaced) Data (2 replies)
  28. [SOLVED:] Show Random Numbers Looping on a UserForm (10 replies)
  29. Programming Scroll Button on Mouse (2 replies)
  30. [SOLVED:] TextBox - Named Range Dynamic Search (1 replies)
  31. Else without If Problem (22 replies)
  32. VBA Loop on Overly Coded Macro (14 replies)
  33. [SOLVED:] IF-ElseIF-Else macro seems to be disconnected (2 replies)
  34. File renaming (2 replies)
  35. [SOLVED:] Sorting by custom aplphabet (6 replies)
  36. code for sum function (0 replies)
  37. Data Tabulation (2 replies)
  38. Transferring Data between sheets to main record sheet. (2 replies)
  39. VLookup (0 replies)
  40. Excel Userform - how can I send an HTML email using data from the userform with image (0 replies)
  41. Conditional Formatting with Multiple Criteria (2 replies)
  42. SUMPRODUCT formula does not add up negative numbers. (0 replies)
  43. Market- making algorithm (2 replies)
  44. Excel Clarification (4 replies)
  45. Multiple Linear Progression, logging and VBA (35 replies)
  46. Same Userform, Different Lines (7 replies)
  47. VBA SQL Query from Cell (1 replies)
  48. [SOLVED:] VBA Dir and HTTP Directories Equivalent (10 replies)
  49. [SOLVED:] Consolidating data from multiple workbooks with varying ranges (3 replies)
  50. proper variable type (2 replies)
  51. Quick Question (hopefully) - Possible to create a front sheet for analysing data? (4 replies)
  52. Lock ComboBox/ MsgBox as Error (2 replies)
  53. counts ships between instances of picked number (4 replies)
  54. [SOLVED:] overflow error in range.find (7 replies)
  55. [SOLVED:] Hidden Object Range Failure in Worksheet Calculate (1 replies)
  56. Excel 2016 VBA Error 400 (4 replies)
  57. VBA to copy / autofill data, where am i going wrong? (1 replies)
  58. [SOLVED:] Deleting multiple cells based on value found (2 replies)
  59. [SOLVED:] Copy from Excel to Powerpoint to create a report (17 replies)
  60. VBA to email each sheet in a workbook (0 replies)
  61. [SOLVED:] if not found record after 1st criterial in Advanced Filter - then move to next if (1 replies)
  62. [SOLVED:] Help with solving a maze in VBA Excel (30 replies)
  63. [SOLVED:] How to DIM script itself? (7 replies)
  64. Prevent Blank Rows When applying filters (1 replies)
  65. [SOLVED:] Problem with Userform input to Worksheet (Excel 2013) (3 replies)
  66. VBA for AUDITING (1 replies)
  67. Help with date and time formats (6 replies)
  68. VBA to email each sheet in a workbook (2 replies)
  69. [SOLVED:] Brining in 2 inputs incrementally & 3 others from lists. (18 replies)
  70. [SOLVED:] Timed Message Boxes not handling code in between (5 replies)
  71. formula help (4 replies)
  72. Using the Custom UI to create a custom ribbon Addin for Excel (0 replies)
  73. Spllit the data customer wise and email id should come in A1 Column. (1 replies)
  74. [SOLVED:] Macro to skip rows that have blank cells (2 replies)
  75. How to split categorical data in Excel (1 replies)
  76. Summing up values in label captions (6 replies)
  77. [SOLVED:] VBA code for sum function for filtered columns (7 replies)
  78. [SOLVED:] Please Help. Rank Formula Macro (4 replies)
  79. Auto fill from multiple rows & cells (2 replies)
  80. Add a Calculated filed in pivot table to calculate percentage of adjacent column (1 replies)
  81. Aktivate/ deactivate check box (9 replies)
  82. Sharing Interest Dynamically (5 replies)
  83. VBA - open corrupted file - excel 2010 (1 replies)
  84. Refer to a cell in another worksheet (macro) (2 replies)
  85. [SOLVED:] Copy and paste total row with engineer name and headings to a new worksheet (1 replies)
  86. Prining from VBA not coming out in the correct size, please help me (1 replies)
  87. Perform Sum in vba code (3 replies)
  88. VBA for printing files listed in excel (3 replies)
  89. VBA Coloring Cells Based on Value (3 replies)
  90. Update value in a column from another worksheet depending on the date in a range (3 replies)
  91. How to return entire output from Array to Excel sheet in one go (4 replies)
  92. How to compare different values either by formula or vba (1 replies)
  93. [SOLVED:] Variable Not Defined, Excel 2013 & 2007 (4 replies)
  94. [SOLVED:] Excel VBA help....please :) (4 replies)
  95. [SOLVED:] Create a new function to find a date or next date on a selected range (8 replies)
  96. Excel VBA - Check excel file names and change if necessary (2 replies)
  97. Summary of cash book day wise (2 replies)
  98. [SOLVED:] PRINT EMAILS WHERE SUBJECT MATCHES CELLS IN EXCEL (2 replies)
  99. clearing data using range(cells) (1 replies)
  100. [SOLVED:] VBA Code Modifcation To Insert a New Row and Fill out with Data As Per Existing Code (2 replies)
  101. Need Excel VBA help to loop in folder, execute several tasks and save filesAs (1 replies)
  102. Send Email separating by specific recipient (0 replies)
  103. input box to define formulas contraints (1 replies)
  104. [SOLVED:] VBA Loop (5 replies)
  105. [SOLVED:] VBA Help please - Find First Row of Data? (4 replies)
  106. Check Values in Array for Matches (5 replies)
  107. click button via vba (0 replies)
  108. [SOLVED:] Automatically group the cell based on the words that appear in it (10 replies)
  109. Merge duplicates with cell color (2 replies)
  110. [SOLVED:] Dependencies and Dates (5 replies)
  111. Security (2 replies)
  112. [SOLVED:] Copy data block from one workbook to another .. should be easy (3 replies)
  113. [SOLVED:] Gradual Zoom? (8 replies)
  114. [SOLVED:] VBA - Copy with validatation (7 replies)
  115. [SOLVED:] Adjust/Sync Table columns number Base on a Pivot Table Columns Size (5 replies)
  116. Copy multiple workbooks & multiple sheets into single workbook with multiple sheets (3 replies)
  117. VBA - Export as PDF and overwrite existing PDFs (2 replies)
  118. Distribute Numbers Evenly, With Conditions (3 replies)
  119. Forecasting (7 replies)
  120. Traverse all images in workbook (2 replies)
  121. Excel Userform DatePicker Default Format to be Blank (3 replies)
  122. [SOLVED:] Select row based on multiple textbox values (1 replies)
  123. [SOLVED:] Having trouble with renaming files in subfolders of subfolders (2 replies)
  124. Listbox not showing Data (2 replies)
  125. Stock Locator Inventory System-Issue with locator (1 replies)
  126. Paste from Clipbaord (1 replies)
  127. Dependent between 2 dropdown columns (4 replies)
  128. [SOLVED:] How to do loop in the function? (8 replies)
  129. Save textbox to specific cell based on combobox seletection (2 replies)
  130. Help with IE Button Click - SHDocVw (9 replies)
  131. [SOLVED:] VBA exel programming: how to make a automatically filled up by filling up other cell (6 replies)
  132. [SOLVED:] MoveAfterReturnDirection (7 replies)
  133. Komplex If-Loop (2 replies)
  134. Public Variable won't pass (4 replies)
  135. Excel-How to concatenate data in multiple dynamic number of rows and multiple columns (1 replies)
  136. [SOLVED:] Array Output (3 replies)
  137. How to make multiple, non adjacent cells hidden based on cell value code (7 replies)
  138. VBA help loop until & IF formula (3 replies)
  139. [SOLVED:] Color Coding Stops After I get to # 65,282 (2 replies)
  140. [SOLVED:] VBA Userform using Danish CPR Numbers (3 replies)
  141. SaveAs to SharePoint not working in Excel 2013 (0 replies)
  142. VBA Help needed (10 replies)
  143. [SOLVED:] VBA/Excel change value of a cell in multiple worksheets from a range in another workb (1 replies)
  144. VBA SUM Formula help (2 replies)
  145. Filtering numbers according to certain ratios (2 replies)
  146. [SOLVED:] Send all files in folder vba (2 replies)
  147. Excel 2016 Crashes (2 replies)
  148. [SOLVED:] Help with equation that has several inputs which vary in value. (11 replies)
  149. [SOLVED:] Formula returning false when it shouldn't (32 replies)
  150. Counting Used Rows In Column - Best Method? (2 replies)
  151. Edit to "colour to chart" macro - to cycle through workbook (9 replies)
  152. Allocating buyers based on expertise and performance (2 replies)
  153. Detecting Barcode Scanner input vs input by hand (4 replies)
  154. Array Question - basic (2 replies)
  155. macro to extract specific data from text file to excel sheet (9 replies)
  156. How to run external software run multiple files after each other using VBA (in Excel) (1 replies)
  157. Insert Vba macro to Sheet 3 using another macro. (1 replies)
  158. VBACode to show autofilter criteria just show result as <>, even though filter is set (1 replies)
  159. VBA Code-csv file into excel- from general to text (2 replies)
  160. [SOLVED:] Need help figuring out what went wrong (16 replies)
  161. VBA Question (1 replies)
  162. [SOLVED:] Copy and Paste Problem (12 replies)
  163. [SOLVED:] Conditional Statements & Nested If/Then in VBA (1 replies)
  164. SUMPRODUCT with additional sums/ adds (1 replies)
  165. Run-time error 438: Object doesn't support this property or method (VBA), Office 2010 (5 replies)
  166. VBA code for conditional cell merging (1 replies)
  167. xlsm file opens and immediately closes (7 replies)
  168. VBA for designing your sheet (2 replies)
  169. Replace text in email body from the excel (1 replies)
  170. Array match Only 1 RedimPreserve (7 replies)
  171. Find empty cell in one spreadsheet and then paste information from another (1 replies)
  172. [SOLVED:] Array of Email Addresses (8 replies)
  173. Type missmatch error (5 replies)
  174. [SOLVED:] MS MapPoint and MS Excel, plot latitude and longitude on a map (11 replies)
  175. Restoring default Styles in Excel (4 replies)
  176. [SOLVED:] Showing two expected values together with an IF function (2 replies)
  177. [SOLVED:] Color cells from previous colored cells in different column (0 replies)
  178. VBA to copy a new sheet based on active sheet (11 replies)
  179. INDEX MATCH in VBA over different data files (3 replies)
  180. [SOLVED:] Split Cells into rows but with two columns (10 replies)
  181. VBA - Set data list (8 replies)
  182. How to speed up VBA Code (12 replies)
  183. [SOLVED:] Help to faster this script for moving Duplicates (4 replies)
  184. How to Merge Cells Specially (12 replies)
  185. it is possible to save individual sheets as a separate file? (9 replies)
  186. [SOLVED:] VBA-split data into multiple worksheets based on column (6 replies)
  187. Outlook vba help - Folder Picker (0 replies)
  188. It is possible deleting rows in lisboxt datagrid with active sheets displayed vba exc (13 replies)
  189. [SOLVED:] Validation Code Problem (6 replies)
  190. Performing count and max commands on multiple groups of rows (2 replies)
  191. [SOLVED:] Arrangement of values in groups (3 replies)
  192. [SOLVED:] Excel 2010 run time error 91': Object variable or with block ... (8 replies)
  193. Filter the entries of Combobox (7 replies)
  194. [SOLVED:] Error Handling (runtime error 1004) (13 replies)
  195. Need help moving many fields of data from the master sheet to several other sheets (4 replies)
  196. [SLEEPER:] How to get data from an array table with two different values (0 replies)
  197. [SOLVED:] Concatenation with double quotes and comma for the selected list of values (17 replies)
  198. VBA_Pivot table capture in array and reapply (1 replies)
  199. search for multiple value using FORMS (0 replies)
  200. Returning the Caption Property for active controls in an email body (11 replies)
  201. [SOLVED:] Getting Run Time Error 5 on String? (10 replies)
  202. Improve efficiency of VBA Code (16 replies)
  203. [SOLVED:] Validate cells in column A with info from other columns (12 replies)
  204. what is wrong with my update button code excel vba (6 replies)
  205. Vlook from Closed workbook taking a lot time (4 replies)
  206. copy and paste a certain number of times (2 replies)
  207. [SLEEPER:] Loading a txt file into excel win works fine. Loading txt on a mac doesn't work. (1 replies)
  208. my excel vba stop running when i run the userform and not responding (37 replies)
  209. macro to send multiple emails with all attachements from specific folder (2 replies)
  210. [SOLVED:] Create outlook appointementes only on "check" rows (1 replies)
  211. Need help with Timesheet Workbook I know exactly what I need ! (6 replies)
  212. [SOLVED:] Return Multiple Listbox Selection (12 replies)
  213. Extract single row from multiple workbooks (2 replies)
  214. Sheet_change is not worked (5 replies)
  215. Combine Data in Mutiple Columns into Rows (2 replies)
  216. Loop for substitution (1 replies)
  217. [SOLVED:] Loop to copy and paste first cell of repeated values (14 replies)
  218. Copy data from multiple single-worksheet workbooks into another workbook (1 replies)
  219. [SOLVED:] Sum Values Assigned to a Name (3 replies)
  220. [SOLVED:] automated data query (1 replies)
  221. [SOLVED:] Remove duplicates (runtime error 5) (1 replies)
  222. [SOLVED:] Dim problem (4 replies)
  223. VBA Code running in f8 but not f5 (2 replies)
  224. [SOLVED:] Range of inputs and graphing of result (8 replies)
  225. What am I doing wrong here? (11 replies)
  226. [SOLVED:] how to loop search to show multiple entries in listbox (8 replies)
  227. Minimize-Maximize-Resizing-Scrolling in a Userform (1 replies)
  228. VBA Code to attach (multiple) file(s) (7 replies)
  229. [SOLVED:] lookup formula to sum percent (2 replies)
  230. VBA Code problem for Excel 2016 on a mac (5 replies)
  231. [SOLVED:] Loop through all Pivot tables in a worksheet and filter visability VBA (4 replies)
  232. [SOLVED:] Looping through a Range of Data (3 replies)
  233. Dsum and Data Tables (3 replies)
  234. Avoid code repetition by calling the common code from another sub (6 replies)
  235. Finding the last modified date of an excel sheet (15 replies)
  236. [SOLVED:] Split First, Middle and Last Name (20 replies)
  237. Save Active Word Doc with URL File Path (14 replies)
  238. Iterate 2 dropdown lists and move to all the new tabs to new workbook (0 replies)
  239. [VBA] set range find() -> finds wrong value (4 replies)
  240. [SOLVED:] Using concatenate to reference a named range (3 replies)
  241. VBA event to detect an Autofill Scrolling? (3 replies)
  242. Paste column format only through iteration (4 replies)
  243. Office Automation: Excel executng Word VBA (14 replies)
  244. Pull Date by Criteria for Visible cells only (1 replies)
  245. [SOLVED:] Line Break Validation (6 replies)
  246. vba - copy workbook 300 times once user selects folder (0 replies)
  247. [SOLVED:] Copy row data from one workbook to another based on row header name (10 replies)
  248. ID matching with Name and sub six hours work time calculation (1 replies)
  249. Mail Merge Excel however instead of Print Need save as (8 replies)
  250. email automation (2 replies)