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. Run macro from another workbook (1 replies)
  2. Data Validation for a Range (17 replies)
  3. Keeping modeless userform on top (2 replies)
  4. [SOLVED:] Distribute rows from 1 ws into about 100 different workbooks and copy 2 ws to all. (8 replies)
  5. Excel 2013 is changes all General formatting to Date formatting... (0 replies)
  6. How to Loop thru Column and Modify Values Based on User Input (0 replies)
  7. [SOLVED:] Macro for setting up a printarea of random large quntaties of ranges (2 replies)
  8. Find Last Match, if no match use previous Match (5 replies)
  9. [SOLVED:] Get number of last colored column (10 replies)
  10. [SOLVED:] Try to Increment "To" Variable in "For To" but it's static. (3 replies)
  11. Excel code to close an already openend access database (2 replies)
  12. [SOLVED:] Autofill Form fields from external spreadsheet - Help please! (3 replies)
  13. [SOLVED:] Insert N cells for M new rows? (4 replies)
  14. Totally new with VBA help please (11 replies)
  15. VBA match 4 conditional values at once with Select Case. (6 replies)
  16. Worksheet_Change to trigger a graph scale change (7 replies)
  17. OnTime expertise needed (7 replies)
  18. [SOLVED:] VBA Sum a range of variable rows with a value below a set amount and loop (2 replies)
  19. Select a couple of cells per row (4 replies)
  20. VBA in oil and gas prodaction (4 replies)
  21. Combine several sheets - Union, ADO, SQL, Consolidate, Formula? (2 replies)
  22. [SOLVED:] Need help with ForEach-If-ElseIf situation (12 replies)
  23. [SOLVED:] Can't refer to graph when using if statements? (9 replies)
  24. [SOLVED:] How to integrate a Loop (6 replies)
  25. [SOLVED:] Stop Read only (3 replies)
  26. [SOLVED:] Open Powerpoint file from Excel (3 replies)
  27. Why the Excel is not opening as page in IIS? (0 replies)
  28. [SOLVED:] Text Import Wizard Help (2 replies)
  29. [SLEEPER:] RDP via VBA Macro (3 replies)
  30. [SOLVED:] Application.OnTime at Workbook_Open (10 replies)
  31. Sleeper: Can someone help me narrow down a list of combinations. (2 replies)
  32. Unicode in Excel-Cells (3 replies)
  33. [SOLVED:] Excel Add In runtime error 4198 (4 replies)
  34. Macro to compare date in cell to current date. (5 replies)
  35. Workbook with a series of errors (16 replies)
  36. [SOLVED:] Moving entire row of data based on two cell values (25 replies)
  37. Compressing long IF OR AND functions (12 replies)
  38. Send Excel data to Word (2 replies)
  39. VBA Select Dynamic Data for Pivot Chart Monthly (1 replies)
  40. Run Dos Comand and store result in Excel. (12 replies)
  41. [SOLVED:] Auto shape color change (14 replies)
  42. [SLEEPER:] Copy the data from pdf to Excel VBA (0 replies)
  43. Syntax for sending email (1 replies)
  44. Generate a list without duplicated data and fill Start/End Date (9 replies)
  45. Delete File if the specific cell is empty (0 replies)
  46. Sleeper: Count weeks with broken/unbroken date ranges with vba (5 replies)
  47. Macro to create an outlook appointment using specific cells in my spreadsheet & email (0 replies)
  48. Mix Constants and Enumerators (15 replies)
  49. problem with VBA code( Ambiguous name detected) (2 replies)
  50. Macro to Copy Paste Data from Source WB to Master WB in different folder sheet wise (1 replies)
  51. [SOLVED:] Help with an If and OR Statement (2 replies)
  52. VBA Code to Compare a number of different worksheets and change/highlight differences (6 replies)
  53. [SOLVED:] Compare two columns in different workbooks (5 replies)
  54. [SOLVED:] chart with dynamic axis help (2 replies)
  55. Slider effect (9 replies)
  56. [SLEEPER:] How do i get the cell value from formula results (variable) in excel 2013 ? (0 replies)
  57. [SOLVED:] Separate content of a cell (merged or not) in columns (9 replies)
  58. [SOLVED:] Excel won't load using 3rd party software (13 replies)
  59. Run-time Error 1004 (4 replies)
  60. [SOLVED:] Change Data from String to Date: Runtime Error '1004' (9 replies)
  61. [SOLVED:] Autofilter: Filter between to dates (7 replies)
  62. Need VBA help to create copies of template and populate sheets with data from Master (24 replies)
  63. [SOLVED:] Make the ENTER key act like the TAB key. (5 replies)
  64. Time Calculation Dilemna (2 replies)
  65. With keyword triggers Class_Terminate (11 replies)
  66. A project assigned to me (1 replies)
  67. Cant refer to graph from other sheet? (15 replies)
  68. VBA error (1 replies)
  69. Make seperate columns range formula refer to cell in vba? (3 replies)
  70. [SOLVED:] Is there a VBA that will search all formulas in a sheet or book (43 replies)
  71. [SOLVED:] Help with Workbook_BeforeSave (4 replies)
  72. Calculate % trend reversal from last bank high (8 replies)
  73. Need Help Sorting a List (3 replies)
  74. Error 424 - Copy and paste b/w worksheets (17 replies)
  75. Copy a colum where add data in every year to another column (1 replies)
  76. [SOLVED:] "A" shift vs "B" shift work days into calendar (6 replies)
  77. Excel sheet to textfile (6 replies)
  78. Excel 2003 - Broken ActiveX (10 replies)
  79. UDF result wrong when cell with UDF copied to range (1 replies)
  80. Radio Button Not Working (4 replies)
  81. [SOLVED:] VBA code to fill missing data (6 replies)
  82. Appending multiple text files to each other by name. (12 replies)
  83. Match formula too slow (3 replies)
  84. vba userforms - transparency png premultiplied alpha channel (0 replies)
  85. [SOLVED:] Check Name and Save Workbook (4 replies)
  86. Sum two column criteria (1 replies)
  87. Large Spreadsheet Calculations (41 replies)
  88. Copying data from one cell when other cell is between a time range (9 replies)
  89. Refresh connection then close (1 replies)
  90. [SOLVED:] Efficent arithmetic loop (4 replies)
  91. Code Help Request (12 replies)
  92. VBA to Insert Blank Row Based on Two Variables (8 replies)
  93. delete characters from string (4 replies)
  94. Need Help Deleting Rows Based on Column Values (2 replies)
  95. Specify Columns to Write File to CSV (7 replies)
  96. Excel VBA insert Formulas below a table (4 replies)
  97. Help with Function (22 replies)
  98. [SOLVED:] SaveAs Error (3 replies)
  99. max items in Array (5 replies)
  100. Formatting Font Style and Size on Excel Chart with Marco (5 replies)
  101. [SOLVED:] userform text box formatting and exporting to word template (2 replies)
  102. [SOLVED:] Select range of visible cells (6 replies)
  103. Listbox Not Populating - Source is dynamic named range (4 replies)
  104. Adding and Deleting a Sheet Dependent on Cell Content (0 replies)
  105. [SOLVED:] Deleting rows older than 3 months (5 replies)
  106. Help in Userform and data (0 replies)
  107. [SOLVED:] Pivot in single sheet one below the other (0 replies)
  108. [SOLVED:] Long length value convert to determine set length (2 replies)
  109. Spreading numbers problems in VBA code (1 replies)
  110. [SOLVED:] Delete row with condition (8 replies)
  111. Wildcard issues (1 replies)
  112. [SOLVED:] Formula/Macro to only display figures in a cell if a certain condition is met. (2 replies)
  113. [SOLVED:] Loop down vba Help (3 replies)
  114. lock workbook (1 replies)
  115. create path to .pdf and extract sheet size (0 replies)
  116. Calculate the product of two matrices (2 replies)
  117. Create a Code to update Date (2 replies)
  118. Plot area resize to fit the entire chart area (0 replies)
  119. [SOLVED:] Loop through Columns - Copy & Paste (2 replies)
  120. [SOLVED:] VBA to keep format when concatenating (61 replies)
  121. Need to copy address to next sheet in a database manner (2 replies)
  122. Using a variable value to select a range when creating a chart (9 replies)
  123. VBA: Macro for multiple charts creation with predefined settings (3 replies)
  124. Copy data from a range of cells and sheets in a closed workbook (20 replies)
  125. [SOLVED:] Importing data from one Workbook to another (2 replies)
  126. [SOLVED:] Sorting all worksheets but exclude 3 worksheets (16 replies)
  127. Macro to insert row and text above cell (1 replies)
  128. VBA Table (1 replies)
  129. [SOLVED:] Make my Code work faster (12 replies)
  130. [SOLVED:] Populating ActiveX Drop List from Cell Values (2 replies)
  131. Q: Create Macro to Archive and then Clear Specific cell. Clearing Issue. (2 replies)
  132. [SOLVED:] Looping Through Checkboxes? (11 replies)
  133. Excel Export Cells to PDF Forms (fillable) (34 replies)
  134. Looping thru rows and copy cell values from "Inputs" sheet to "Output" sheet (0 replies)
  135. [SLEEPER:] Column to be cut and pasted with values in different column (1 replies)
  136. copy Formulas instead of Text values (1 replies)
  137. Items frequently bought together (3 replies)
  138. [SOLVED:] amend excel VBA for powerpoint (2 replies)
  139. [SOLVED:] Match NOW() with cell formatted as date (18 replies)
  140. sendkeys works once only despite time frame (2 replies)
  141. Add a worksheet based on cell content (0 replies)
  142. [SOLVED:] change function add and remove rows (4 replies)
  143. Can I keep an API from updating? (0 replies)
  144. Print title + Dynamic range until empty row (2 replies)
  145. Problem with Printout Code (0 replies)
  146. [SOLVED:] Trying to drag cells down and $ keeps reapplying even after deleted (2 replies)
  147. Copy data to cells not working (0 replies)
  148. Problem with code (2 replies)
  149. Rearranging data based on counter using VBA code (5 replies)
  150. Looping through rows and copy cell values to another worksheet (3 replies)
  151. Find/Replace in Specific Workcheet (3 replies)
  152. Sleeper: Extract cell info from specific column selected out of Named Range (1 replies)
  153. [SOLVED:] VBA- Inex Matchdex Match? (6 replies)
  154. Excel not responding while running VBA (1 replies)
  155. Modify macro so it searches files in subfolders (1 replies)
  156. Put extracted news into a scrolling box in Excel Sheet. (0 replies)
  157. [SOLVED:] HOW TO STRIP OUT ONLY RELEVANT DATA FROM A STRING BY USING FORMULA OR VBA (5 replies)
  158. No of records for each person 90 days old (16 replies)
  159. Problem with VLookup code - Need assistance Please!! (6 replies)
  160. Inser a row based on the cell value in a column (3 replies)
  161. Looping through rows and copy cell values to another worksheet (9 replies)
  162. Create Sub Sheets From Master (8 replies)
  163. Copy specific values (3 replies)
  164. [SOLVED:] Can someone explain these CF formulas to me (16 replies)
  165. Email VBA code that CC's sender? (1 replies)
  166. Delete Columns Based On Text (1 replies)
  167. Delete Rows And Rename Headers (9 replies)
  168. Someone help me for this encode or decode in excel (5 replies)
  169. [SOLVED:] Nested Statement Help for Time Calculation. (2 replies)
  170. Removing duplicates if certain conditions match (0 replies)
  171. [SOLVED:] From Excel create a footer in Word (5 replies)
  172. Can I use VBA with this problem? (1 replies)
  173. Counting Unique Value Pairs in 2 Columns (2 replies)
  174. Macro code for copying Data to next row after a certain period (7 replies)
  175. copy column to row on new worksheet based on cell values in column A (8 replies)
  176. [SOLVED:] 2 D array assignment (11 replies)
  177. [SOLVED:] Run-time error '13': Type Mismatch -- HELP (3 replies)
  178. Add an appointment to a collegues calender (1 replies)
  179. Copy Excel Tables To Word (10 replies)
  180. run time error 1004 in pivot table wizard (1 replies)
  181. Match/Index VBA for UserForm with multiple criteria (1 replies)
  182. MACRO modification (0 replies)
  183. Am I duplicating my rules (6 replies)
  184. Couple of Simple VBA Questions (0 replies)
  185. vbYesNoCancel (3 replies)
  186. [SOLVED:] Create multiple workbooks from a filtered list (2 replies)
  187. Sleeper: Help with VBA Excel tool to create MS Project Plan (3 replies)
  188. [SOLVED:] simple MATCH function - need help (2 replies)
  189. Need to specify columns to be copied in this VBA code (1 replies)
  190. vba code to calculate time difference (1 replies)
  191. Cut copy and Paste permanently disabled in all workbooks help (1 replies)
  192. [SLEEPER:] Excel Vba textbox userform Vlookup give missmatch error (2 replies)
  193. [SOLVED:] How do I get the total from all array elements (27 replies)
  194. [SOLVED:] Runtime Error 91: Object Variable or With Block Variable not Set (5 replies)
  195. Exam setting plan got :confused: need improvement (4 replies)
  196. VBA Excel help (4 replies)
  197. HELP: input text into htm page textbox using vba from excel (0 replies)
  198. Operator <= doesn't seem to work! (11 replies)
  199. [SOLVED:] Expected end of statement error (5 replies)
  200. Setting text format for a textbook on a form (9 replies)
  201. Subscript Out of Range (2 replies)
  202. [SOLVED:] Show value of cell above (13 replies)
  203. Function "&" with 2 columns (2 replies)
  204. Inserting Column Based On Text (2 replies)
  205. Code to extract Html from deeper than I am able to (1 replies)
  206. Copy Template and Move Data (1 replies)
  207. Offset one column (8 replies)
  208. Help with looping/dumping recordset (1 replies)
  209. Saving a copy with date problem (2 replies)
  210. Simple if statement (4 replies)
  211. input text in to htm page using vba from excel (0 replies)
  212. Making an array that selects an increasing number of objects (4 replies)
  213. textbox with date variable? (2 replies)
  214. [SOLVED:] Index Match a col of long text stings to find short text strings and return adjacent (8 replies)
  215. [SOLVED:] VBA to insert PART of a recset into a named range? (0 replies)
  216. Multiple Controls on a Form (3 replies)
  217. [SOLVED:] Deleting rows based on 2 column citeria (16 replies)
  218. VBA - Delete Entire Row if Cell contains Text variable (9 replies)
  219. Excel Name Ranges (2 replies)
  220. Help with calling Access Database for data? (1 replies)
  221. VBA Coding help to cut rows & paste to "archive" tab (2 replies)
  222. [SOLVED:] VBA formula help (5 replies)
  223. Using Cell Value in VBA (3 replies)
  224. result of filter (3 replies)
  225. Finding and renaming files from spreadsheet list (1 replies)
  226. Looking for a old members post (0 replies)
  227. [SLEEPER:] Calculate hours between two times (8 replies)
  228. [SOLVED:] Trouble with Comboboxes (1 replies)
  229. How to save as CSV file with the filename being dynamic and worksheet name static? (0 replies)
  230. Macro Help (2 replies)
  231. [SOLVED:] Enter Date After copy filtered data (30 replies)
  232. [SOLVED:] static today date function based on 2 criteria (5 replies)
  233. Pivot Refresh (5 replies)
  234. keyword search (5 replies)
  235. copy data from sheet 1 to sheet 2 when data entered in sheet 1 (0 replies)
  236. autofilter each value in a column and campare with another column (2 replies)
  237. [SOLVED:] copy paste after the lastused row of another sheet excluding the headers (2 replies)
  238. XML data with variable filenames (0 replies)
  239. [SOLVED:] #VALUE error (6 replies)
  240. [SOLVED:] copy listbox value(2 of 3 columns) to a listbox that name matches day value (3rd col) (1 replies)
  241. [SOLVED:] Combining Counts and Sum from two columns (3 replies)
  242. Modify cells using userform (1 replies)
  243. How to use MS Word Spell checker to spellcheck Excel Textbox (0 replies)
  244. [SOLVED:] offset in for each loop (3 replies)
  245. [SOLVED:] build userform calendar using "cell counting" method looping named labels (SamT) (58 replies)
  246. Fill values in another sheet based on the for the cells coloured in one color (10 replies)
  247. Macro for Descriptive Statistics fun! (calling ATPVBAEN.XLAM) (3 replies)
  248. [SOLVED:] SUMIFS Formula to pull data from next tab (3 replies)
  249. Help on updating info based on date (2 replies)
  250. [SLEEPER:] Selenium Wrapper VBA Help (2 replies)