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. Pivot > show all data (1 replies)
  2. Moving Folder to another Folder if name of folder and cell match (8 replies)
  3. VBA to email each sheet in a workbook (2 replies)
  4. [SOLVED:] Sort and spilit into column from one cell (5 replies)
  5. [SOLVED:] Ensure Selected Item in Listbox does not exist in Range (2 replies)
  6. Macros to copy from desirable worksheets to the same worksheets in another workbook (0 replies)
  7. pls help conditinal formating or vba (16 replies)
  8. [SOLVED:] Display Cell Contents - in ListBox (8 replies)
  9. [SOLVED:] Shape Fill Color Does Not Change (Excel 2013) (1 replies)
  10. Copy and past whole rows to a different tab based on two criteria (1 replies)
  11. [SOLVED:] color uppercase words (1 replies)
  12. [SOLVED:] Find and color text with Text List (1 replies)
  13. Array add dropdown Combobox for UserForm (3 replies)
  14. [SOLVED:] SIMPLE vertical timeline ... (16 replies)
  15. [SOLVED:] VBA help to compare 2 sheets and pick out duplicates (3 replies)
  16. VBA - Recursive Function modify Code - Output ERROR (10 replies)
  17. [SOLVED:] Sum on the basis of multiple creterias (4 replies)
  18. Can't get a loop to spit out individual files... (1 replies)
  19. my code is working.... almost (1 replies)
  20. [SOLVED:] Checkbox Loop (8 replies)
  21. Transpose Tables arranged horizontally to vertically (3 replies)
  22. [SOLVED:] VBA Code to copy data from one sheet to another based on date (3 replies)
  23. vlookup range in another sheet (9 replies)
  24. Export Multiple Sheets and Save As a new file (2 replies)
  25. Looking to Highlight Certain Phrases (4 replies)
  26. Transferring Data (1 replies)
  27. Checkbox to write values to multiple cells (6 replies)
  28. Data Retrieval (3 replies)
  29. VBA API Parsing and pasting json string to excel spreadsheet. run time 13 error (1 replies)
  30. [SOLVED:] Setting 1 range in 1 Workbook equal to another range in another workbook (3 replies)
  31. [SOLVED:] Sum of all months (3 replies)
  32. VBA Conditional Formatting Help (4 replies)
  33. ROW DUPLICATION WITH MULTIPLE VLOOKUP VALUES (1 replies)
  34. excel vba replace (7 replies)
  35. [SLEEPER:] Loop based on count of serial number and fill formula (0 replies)
  36. VBA capturing screenshot (2 replies)
  37. vba algorithm (1 replies)
  38. to many line continuations during parsing (9 replies)
  39. compare 3 arrays. If uniqe in dimmesion (2,3,4) then check and copy to Tab1 or Tab3 (1 replies)
  40. Removing uncommon entries between two lists of names+data (3 replies)
  41. How to read values in custom tab of file properties dialog box in windows. (9 replies)
  42. [SLEEPER:] VBA wait on VBScript to finish? (4 replies)
  43. VBA excel looping to subfolders outlook (1 replies)
  44. [SOLVED:] Change Mulitple Userform Label Backcolors (Excel 2013) (7 replies)
  45. [SOLVED:] Excel 2013 - How to check whether a chart series is selected (5 replies)
  46. [SOLVED:] help with understanding loops and multiplying integers (5 replies)
  47. I don't know what to do with message in Excel (4 replies)
  48. Test if active cell is within 2 separate unrelated ranges (2 replies)
  49. Copy specific data from a worksheet containing searchable comboboxes to another sheet (1 replies)
  50. Help Combining Two Private Sub's Into One (22 replies)
  51. List Box issue (2 replies)
  52. Excel recalculate everytime i write in a cell (1 replies)
  53. Advice for my prank code (6 replies)
  54. [SOLVED:] An Array of Sheet Names (6 replies)
  55. [SOLVED:] Loop and copy paste part numbers based on qty (5 replies)
  56. Shared Workbook Which Has 12 Worksheets (3 replies)
  57. VBA Code Updating Word Doc Bookmarks Data to Push New Data from Excel Cells (2 replies)
  58. VBA code for a routine process (4 replies)
  59. Outlook Calander Appointments With Excel (1 replies)
  60. Formula Help (4 replies)
  61. Filter - Copy - Paste (7 replies)
  62. Close Workbook After Idle (1 replies)
  63. Help with my code (Finding specific max values and applying it for other column) (0 replies)
  64. Change color of numeric characters (2 replies)
  65. To copy specific columns from a raw file to another workbook (2 replies)
  66. Help with VBA coding (4 replies)
  67. [SOLVED:] VBA Code to create a list of changes from a workbook. (8 replies)
  68. Send E-Mail via Macro if Workbook was saved and the was name changed aswell (5 replies)
  69. [SOLVED:] How to set loop for selecting columns and converting numbers stored as text (3 replies)
  70. time deduction (3 replies)
  71. Fill Internet Form (1 replies)
  72. static "fake" pivot table (1 replies)
  73. Refresh MS Query - Password Issue (1 replies)
  74. [SOLVED:] Custom sort with placeholders (5 replies)
  75. [SOLVED:] RE-ORDER and Inserting Columns of two Workbooks. (18 replies)
  76. VBA code for adding a new value in data range using user form (1 replies)
  77. INDEX MATCH with 2 range criteria in the same sheet (1 replies)
  78. Copying data from one sheet to another (6 replies)
  79. vba array /loop help (4 replies)
  80. [SOLVED:] VBA Macro to select and bring back a new campaign code (5 replies)
  81. Macro to Insert Objects from folders and move it to respective Sheets (3 replies)
  82. [SOLVED:] Infinite VBA Loop (16 replies)
  83. [SOLVED:] VBA help please (2 replies)
  84. [SOLVED:] VBA Before Double-Click Event executing when not desirable (5 replies)
  85. Variable x,y axis scales, series names and chart title (1 replies)
  86. Chart with Dynamic Row and Column Count Help needed (3 replies)
  87. Download Csv file from the Website VBA (0 replies)
  88. OptionButton LinkedCell trouble (8 replies)
  89. copy entire row from sheet1 into sheet2 if ID matches and column header should match (7 replies)
  90. [SOLVED:] Delete the value of cell that start by char with exception . (4 replies)
  91. [SOLVED:] Vba how to check workbook name first before opening it (2 replies)
  92. [SOLVED:] Random Numbers Looping Thru and Displaying Values (17 replies)
  93. Form created in worksheet, using macro to submit the info to second sheet (1 replies)
  94. Macro to open workbook copy data from workbook 1 and paste in workbook 2 and repeat. (5 replies)
  95. MultiPage - Run-time error 35788: (3 replies)
  96. Application.Goto not working in immediate window (2 replies)
  97. Split cells data in below rows with other data. (2 replies)
  98. VBA Combining Data from Multiple Workbook into One - Need help ASAP (2 replies)
  99. [SOLVED:] TMP file not found error when creating multiple workbooks in a loop (27 replies)
  100. [SLEEPER:] Makes bold a chosen word in a cell (8 replies)
  101. [SOLVED:] VBA Error run time 1004: Application-defined or object-defined error (6 replies)
  102. excel vba change cell color based on a number value in a range (3 replies)
  103. [SOLVED:] VBA to carry out Simpson's Rule for Tabulated (Equispaced) Data (2 replies)
  104. [SOLVED:] Show Random Numbers Looping on a UserForm (10 replies)
  105. Programming Scroll Button on Mouse (2 replies)
  106. [SOLVED:] TextBox - Named Range Dynamic Search (1 replies)
  107. Else without If Problem (22 replies)
  108. VBA Loop on Overly Coded Macro (14 replies)
  109. [SOLVED:] IF-ElseIF-Else macro seems to be disconnected (2 replies)
  110. File renaming (2 replies)
  111. [SOLVED:] Sorting by custom aplphabet (6 replies)
  112. code for sum function (0 replies)
  113. Data Tabulation (2 replies)
  114. Transferring Data between sheets to main record sheet. (2 replies)
  115. VLookup (0 replies)
  116. Excel Userform - how can I send an HTML email using data from the userform with image (0 replies)
  117. Conditional Formatting with Multiple Criteria (2 replies)
  118. SUMPRODUCT formula does not add up negative numbers. (0 replies)
  119. Market- making algorithm (2 replies)
  120. Excel Clarification (4 replies)
  121. [SLEEPER:] Multiple Linear Progression, logging and VBA (35 replies)
  122. Same Userform, Different Lines (7 replies)
  123. VBA SQL Query from Cell (1 replies)
  124. [SOLVED:] VBA Dir and HTTP Directories Equivalent (10 replies)
  125. [SOLVED:] Consolidating data from multiple workbooks with varying ranges (3 replies)
  126. proper variable type (2 replies)
  127. Quick Question (hopefully) - Possible to create a front sheet for analysing data? (4 replies)
  128. Lock ComboBox/ MsgBox as Error (2 replies)
  129. counts ships between instances of picked number (4 replies)
  130. [SOLVED:] overflow error in range.find (7 replies)
  131. [SOLVED:] Hidden Object Range Failure in Worksheet Calculate (1 replies)
  132. Excel 2016 VBA Error 400 (4 replies)
  133. VBA to copy / autofill data, where am i going wrong? (1 replies)
  134. [SOLVED:] Deleting multiple cells based on value found (2 replies)
  135. [SOLVED:] Copy from Excel to Powerpoint to create a report (17 replies)
  136. VBA to email each sheet in a workbook (0 replies)
  137. [SOLVED:] if not found record after 1st criterial in Advanced Filter - then move to next if (1 replies)
  138. [SOLVED:] Help with solving a maze in VBA Excel (30 replies)
  139. [SOLVED:] How to DIM script itself? (7 replies)
  140. [SLEEPER:] Prevent Blank Rows When applying filters (1 replies)
  141. [SOLVED:] Problem with Userform input to Worksheet (Excel 2013) (3 replies)
  142. VBA for AUDITING (1 replies)
  143. Help with date and time formats (6 replies)
  144. VBA to email each sheet in a workbook (2 replies)
  145. [SOLVED:] Brining in 2 inputs incrementally & 3 others from lists. (18 replies)
  146. [SOLVED:] Timed Message Boxes not handling code in between (5 replies)
  147. formula help (4 replies)
  148. Using the Custom UI to create a custom ribbon Addin for Excel (0 replies)
  149. Spllit the data customer wise and email id should come in A1 Column. (1 replies)
  150. [SOLVED:] Macro to skip rows that have blank cells (2 replies)
  151. How to split categorical data in Excel (1 replies)
  152. Summing up values in label captions (6 replies)
  153. [SOLVED:] VBA code for sum function for filtered columns (7 replies)
  154. [SOLVED:] Please Help. Rank Formula Macro (4 replies)
  155. Auto fill from multiple rows & cells (2 replies)
  156. Add a Calculated filed in pivot table to calculate percentage of adjacent column (1 replies)
  157. Aktivate/ deactivate check box (9 replies)
  158. Sharing Interest Dynamically (5 replies)
  159. VBA - open corrupted file - excel 2010 (1 replies)
  160. Refer to a cell in another worksheet (macro) (2 replies)
  161. [SOLVED:] Copy and paste total row with engineer name and headings to a new worksheet (1 replies)
  162. Prining from VBA not coming out in the correct size, please help me (1 replies)
  163. Perform Sum in vba code (3 replies)
  164. VBA for printing files listed in excel (3 replies)
  165. VBA Coloring Cells Based on Value (3 replies)
  166. Update value in a column from another worksheet depending on the date in a range (3 replies)
  167. How to return entire output from Array to Excel sheet in one go (4 replies)
  168. How to compare different values either by formula or vba (1 replies)
  169. [SOLVED:] Variable Not Defined, Excel 2013 & 2007 (4 replies)
  170. [SOLVED:] Excel VBA help....please :) (4 replies)
  171. [SOLVED:] Create a new function to find a date or next date on a selected range (8 replies)
  172. Excel VBA - Check excel file names and change if necessary (2 replies)
  173. Summary of cash book day wise (2 replies)
  174. [SOLVED:] PRINT EMAILS WHERE SUBJECT MATCHES CELLS IN EXCEL (2 replies)
  175. clearing data using range(cells) (1 replies)
  176. [SOLVED:] VBA Code Modifcation To Insert a New Row and Fill out with Data As Per Existing Code (2 replies)
  177. Need Excel VBA help to loop in folder, execute several tasks and save filesAs (1 replies)
  178. Send Email separating by specific recipient (0 replies)
  179. input box to define formulas contraints (1 replies)
  180. [SOLVED:] VBA Loop (5 replies)
  181. [SOLVED:] VBA Help please - Find First Row of Data? (4 replies)
  182. Check Values in Array for Matches (5 replies)
  183. click button via vba (0 replies)
  184. [SOLVED:] Automatically group the cell based on the words that appear in it (10 replies)
  185. Merge duplicates with cell color (2 replies)
  186. [SOLVED:] Dependencies and Dates (5 replies)
  187. Security (2 replies)
  188. [SOLVED:] Copy data block from one workbook to another .. should be easy (3 replies)
  189. [SOLVED:] Gradual Zoom? (8 replies)
  190. [SOLVED:] VBA - Copy with validatation (7 replies)
  191. [SOLVED:] Adjust/Sync Table columns number Base on a Pivot Table Columns Size (5 replies)
  192. Copy multiple workbooks & multiple sheets into single workbook with multiple sheets (3 replies)
  193. VBA - Export as PDF and overwrite existing PDFs (2 replies)
  194. Distribute Numbers Evenly, With Conditions (3 replies)
  195. Forecasting (7 replies)
  196. Traverse all images in workbook (2 replies)
  197. Excel Userform DatePicker Default Format to be Blank (3 replies)
  198. [SOLVED:] Select row based on multiple textbox values (1 replies)
  199. [SOLVED:] Having trouble with renaming files in subfolders of subfolders (2 replies)
  200. Listbox not showing Data (2 replies)
  201. Stock Locator Inventory System-Issue with locator (1 replies)
  202. Paste from Clipbaord (1 replies)
  203. Dependent between 2 dropdown columns (4 replies)
  204. [SOLVED:] How to do loop in the function? (8 replies)
  205. Save textbox to specific cell based on combobox seletection (2 replies)
  206. Help with IE Button Click - SHDocVw (9 replies)
  207. [SOLVED:] VBA exel programming: how to make a automatically filled up by filling up other cell (6 replies)
  208. [SOLVED:] MoveAfterReturnDirection (7 replies)
  209. Komplex If-Loop (2 replies)
  210. Public Variable won't pass (4 replies)
  211. Excel-How to concatenate data in multiple dynamic number of rows and multiple columns (1 replies)
  212. [SOLVED:] Array Output (3 replies)
  213. How to make multiple, non adjacent cells hidden based on cell value code (7 replies)
  214. VBA help loop until & IF formula (3 replies)
  215. [SOLVED:] Color Coding Stops After I get to # 65,282 (2 replies)
  216. [SOLVED:] VBA Userform using Danish CPR Numbers (3 replies)
  217. SaveAs to SharePoint not working in Excel 2013 (0 replies)
  218. VBA Help needed (10 replies)
  219. [SOLVED:] VBA/Excel change value of a cell in multiple worksheets from a range in another workb (1 replies)
  220. VBA SUM Formula help (2 replies)
  221. Filtering numbers according to certain ratios (2 replies)
  222. [SOLVED:] Send all files in folder vba (2 replies)
  223. Excel 2016 Crashes (2 replies)
  224. [SOLVED:] Help with equation that has several inputs which vary in value. (11 replies)
  225. [SOLVED:] Formula returning false when it shouldn't (32 replies)
  226. Counting Used Rows In Column - Best Method? (2 replies)
  227. Edit to "colour to chart" macro - to cycle through workbook (9 replies)
  228. Allocating buyers based on expertise and performance (2 replies)
  229. Detecting Barcode Scanner input vs input by hand (4 replies)
  230. Array Question - basic (2 replies)
  231. [SLEEPER:] macro to extract specific data from text file to excel sheet (9 replies)
  232. How to run external software run multiple files after each other using VBA (in Excel) (1 replies)
  233. Insert Vba macro to Sheet 3 using another macro. (1 replies)
  234. VBACode to show autofilter criteria just show result as <>, even though filter is set (1 replies)
  235. VBA Code-csv file into excel- from general to text (2 replies)
  236. [SOLVED:] Need help figuring out what went wrong (16 replies)
  237. VBA Question (1 replies)
  238. [SOLVED:] Copy and Paste Problem (12 replies)
  239. [SOLVED:] Conditional Statements & Nested If/Then in VBA (1 replies)
  240. SUMPRODUCT with additional sums/ adds (1 replies)
  241. Run-time error 438: Object doesn't support this property or method (VBA), Office 2010 (5 replies)
  242. VBA code for conditional cell merging (1 replies)
  243. xlsm file opens and immediately closes (7 replies)
  244. VBA for designing your sheet (2 replies)
  245. Replace text in email body from the excel (1 replies)
  246. Array match Only 1 RedimPreserve (7 replies)
  247. Find empty cell in one spreadsheet and then paste information from another (1 replies)
  248. [SOLVED:] Array of Email Addresses (8 replies)
  249. Type missmatch error (5 replies)
  250. [SOLVED:] MS MapPoint and MS Excel, plot latitude and longitude on a map (11 replies)