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. Calling a Sub from another Sub() (6 replies)
  2. appending textbox info from a userform to a worksheet as a comment (1 replies)
  3. [SOLVED:] Match Function Help Trying To Match Against All Worksheets In Workbook (2 replies)
  4. Vba code for 3 pivots in one sheet (2 replies)
  5. [SOLVED:] Placing Image - Different on another computer (1 replies)
  6. Excel 2010 Macro Security (2 replies)
  7. Scanning through multiple sheets and copying based on Header. (9 replies)
  8. Array Item used correctly (8 replies)
  9. [SOLVED:] Excel 2010 VBA - Issues with Drop Down box with Table Interface (6 replies)
  10. [SOLVED:] Problem with For and Cells (2 replies)
  11. [SOLVED:] Update a previously recorded row. (16 replies)
  12. Can macro simulate data? (5 replies)
  13. Excel VBA Charts to powerpoint (1 replies)
  14. [SOLVED:] Shell and Wait - 32 bit and 64 bit (37 replies)
  15. Vlookup macro replaced with an array (3 replies)
  16. VBA help to create summary table from a range of data. (7 replies)
  17. Wrong date VBA (4 replies)
  18. vba code for excel list of folder name, subfolder directory, file name and revision (4 replies)
  19. [SOLVED:] Search column header and copy (4 replies)
  20. Find two cross reference data points (2 replies)
  21. Need help with a complicated Concatenation and Abbreviation Macro (5 replies)
  22. Add current value to running total (3 replies)
  23. [SOLVED:] Changing name and range of horizonal and vertical axis in a stacked bar chart (12 replies)
  24. VBA for a calculation where the range is dynamic (2 replies)
  25. [SOLVED:] How can I fix my autofilter? (7 replies)
  26. UDF Several SUMIF optimination (3 replies)
  27. Save Workbook as HTML (7 replies)
  28. Look @ My Code - Aggregates CSV Files Into Single Spreadsheet - 2 Issues (2 replies)
  29. [SOLVED:] Run Time Error 13 - Type Mismatch Frustration (6 replies)
  30. [SOLVED:] checking if some specific workbook is open; if not then it should be opened. (5 replies)
  31. Delete data in closed workbook? (6 replies)
  32. looping help for copying data from a range and paste in another cell (1 replies)
  33. Exporting Camera Snapshots (1 replies)
  34. Please help - Procedure too long in VBA (13 replies)
  35. Bootstrapping-Random sampling with replacement (3 replies)
  36. Simple task but cant find a solution (9 replies)
  37. # of Thursdays-Fridays in a month (0 replies)
  38. How to remove an element from a nodelist. (0 replies)
  39. Sleeper: Alternative for GetElementsByTagName for filling a xmlnodelist (1 replies)
  40. Conditional Data (3 replies)
  41. Lookup functions ? how to sovle this issue ??? help me please (2 replies)
  42. Don't want to over write file ? (1 replies)
  43. Chart in userform without creating a image temporary file (1 replies)
  44. Macro to combine data under 3rd and 4th Column if condn satisfy for 1st , 2nd column (7 replies)
  45. [SOLVED:] Merging two spreadsheets using a script and creating html language (2 replies)
  46. MsoAutoShape Binding Problem (2 replies)
  47. VBA code identify rows that have exceeded a certain value in a cumulative chain (1 replies)
  48. Chart in Userform (1 replies)
  49. Loop inside if statement with listindex (4 replies)
  50. VBA many functions (1 replies)
  51. [SOLVED:] List Files and Folders (20 replies)
  52. [SOLVED:] How to open word using excel if not already open? (6 replies)
  53. Reading variable from combo box (0 replies)
  54. [SOLVED:] How to define the Key in the sort method of a range (9 replies)
  55. Produce multiple spreadshets based on columns (1 replies)
  56. Convert DD. December yyyy string into date? (6 replies)
  57. [SOLVED:] Greater than >8 then MsgBbox (10 replies)
  58. [SOLVED:] Merging Multiple excel files into a master file (4 replies)
  59. write variable in vba to text file (5 replies)
  60. [SOLVED:] Creating a VBA Script to save in a current month's folder (create folder as needed) (2 replies)
  61. VBA: Problem clicking button on second page of a website form (4 replies)
  62. create report from text in spreadsheet (2 replies)
  63. [SOLVED:] Show userform from another userform (8 replies)
  64. I am having a problem with the Application.Sumif function in vba (5 replies)
  65. [SOLVED:] .Rows.Count not working correctly? (6 replies)
  66. [SOLVED:] Help Writing Code That is Conditional on Shading of Cell (4 replies)
  67. Merge PDF files created by Foxit from Excel (2 replies)
  68. how to protect vba code in excel (12 replies)
  69. Nightingale Rose Diagram - how to add wedge outlines (1 replies)
  70. Clearing contetn of cells (2 replies)
  71. [SOLVED:] VBA Row (Couinter) Assigning Problem (1 replies)
  72. VBA code to add formula to blank cell (4 replies)
  73. To get a output from table based on condition (1 replies)
  74. [SOLVED:] Userform VLOOKUP (2 replies)
  75. I need some help printing an array from a set of values on a worksheet. (2 replies)
  76. Sleeper: Creating a one-dimensional array from a list on Excel. (1 replies)
  77. Need Help changing outputs in Excel Workbook (0 replies)
  78. [SOLVED:] Save Current WS as Workbook to Selected File Path (3 replies)
  79. [SOLVED:] Produce a word doc for each column_Docvariable+UBOUND function (5 replies)
  80. How to determine 7 calendar days? (1 replies)
  81. VBA code help needed (1 replies)
  82. Copy one range from multiple files. (3 replies)
  83. How to change the forecolor in charts? (1 replies)
  84. Count number of rows in a pdf? (2 replies)
  85. receive positive or negative numbers (7 replies)
  86. copy-paste area with objects, formulas and values (0 replies)
  87. [SOLVED:] Alternate way to move a file (2 replies)
  88. Loop through Range and copy rows based on multiple criteria (1 replies)
  89. [SOLVED:] Data Transfered but not to Target sheet (2 replies)
  90. [SOLVED:] Copying from PDFs - Only pastes last file? (1 replies)
  91. Macro to insert a row if defined value not available (5 replies)
  92. [SOLVED:] Userform ComboBox loaded from Access (3 replies)
  93. Extract data into multiple cells (1 replies)
  94. Adding a 2nd Macro (0 replies)
  95. Add/select multiple files (0 replies)
  96. VBA to convert formulas to value (9 replies)
  97. Function that searches the maximum of numbers which is smaller or equal 0.75. (1 replies)
  98. [SOLVED:] Pivot AddDataField - All data the same as first column (2 replies)
  99. [SOLVED:] Splitting one column into serveral columns (4 replies)
  100. Highlighting all row with same date (0 replies)
  101. Sleeper: How to color code a row if range of columns are blanks (4 replies)
  102. [SOLVED:] How can I fix my autofilter if criteria not met? (4 replies)
  103. Opening URL with Fragment Identifier from VBA Excel (7 replies)
  104. Find Matches for a Range of multiple criteria? (1 replies)
  105. [SOLVED:] Edit Current Selected Cell (3 replies)
  106. [SOLVED:] How to sort a list of numbers and eject one special number of this list? (6 replies)
  107. [SOLVED:] Return value from Custom Ribbon (5 replies)
  108. Finding a non-unique value and take max in another column (1 replies)
  109. How to copy a column from one worksheet to another if the Active sheet is different (4 replies)
  110. [SOLVED:] Compile Error: Expected: line number or label or statement .... (2 replies)
  111. [SOLVED:] Open a Workbook with path (4 replies)
  112. Looking for some help to find "missing" letter groups (30 replies)
  113. auto transfer multiple rows from one excel to another (1 replies)
  114. Cant use match to find cell (date) i have just copied!? (4 replies)
  115. Put comment with IF (3 replies)
  116. [SOLVED:] Random Variables (8 replies)
  117. Find and Replace VBA using Userforms (1 replies)
  118. Alternative for large data reporting (2 replies)
  119. Static Workbook but dynamic sheet - Indirect lookup (3 replies)
  120. [SOLVED:] AutoFilter Previous Months Data (5 replies)
  121. Toggle newly inserted row based on criteria (1 replies)
  122. Inserting pictures (bmps) from Macros into location of current cell (variable cell) (3 replies)
  123. Help with consolidating date on a worksheet from other worksheets (0 replies)
  124. [SOLVED:] loop certain columns (1 replies)
  125. Extract text files from zip files and import contents to Excel (3 replies)
  126. VBA code to copy differing range of cells depending on sheet name (2 replies)
  127. [SOLVED:] use variables in excel 2010 vba with batch file (3 replies)
  128. Cell Value (4 replies)
  129. building an array (1 replies)
  130. [SOLVED:] Problem Macro (0 replies)
  131. VBA for Sorting Table (7 replies)
  132. [SOLVED:] Select/Move Rows to New Sheet Based on Date (5 replies)
  133. VBA Macro a filter that consolidates and displays information in different tables (0 replies)
  134. R-Code to VBA Conversion (3 replies)
  135. [SOLVED:] IF different from blank then (2 replies)
  136. Using an IF and IN statement in VBA (0 replies)
  137. Nurse Scheduling Help (3 replies)
  138. [SOLVED:] Worksheet Change Event has gone AI :o (5 replies)
  139. [SOLVED:] If filtered rows are Yellow then delete else ignore and remove filter (3 replies)
  140. How to use VBA to apply filter to a pivot table (2 replies)
  141. [SOLVED:] Trying to create a PivotTable with VBA, constantly getting an error. (0 replies)
  142. [SOLVED:] Run JavaScript and Get Return (2 replies)
  143. Copy range in row based on criteria and paste to another row based on criteria (3 replies)
  144. Delete columns based off of formula in another cell (2 replies)
  145. [SOLVED:] Pick the fillcolor of a cell (2 replies)
  146. Help on existing macro (4 replies)
  147. [SOLVED:] loop through all public declared variables in a module (38 replies)
  148. New Comment Arrow (5 replies)
  149. Pivot Table: Difference From ... question (7 replies)
  150. Need help on the code i have created for Ping tool on vb script. (5 replies)
  151. Steer me in the right direction? (8 replies)
  152. [SOLVED:] Count Spaces Between Values (2 replies)
  153. Count Cells in Range Containing Specific Value (2 replies)
  154. Transpose from .txt files (1 replies)
  155. macro to Create a Output file based on Input file (2 replies)
  156. [SOLVED:] VBA to ignore login request? (4 replies)
  157. Reverse a matrix on VBA (1 replies)
  158. DISPLAY SUBTOTAL and SUBTOTAL % in PIVOT TABLE (0 replies)
  159. Worksheet Data Input and Data Handling (2 replies)
  160. [SOLVED:] New to VBA, Need help outputting a list of the TextBox names from my 1st project (5 replies)
  161. table filtering and sorting (0 replies)
  162. Get all occurrences of data from text file using VBA (3 replies)
  163. Code to close workbooks (16 replies)
  164. Data validation list for-loop wont go to next (8 replies)
  165. EXCEL VBA - PUSH DATA AND REFRESH (1 replies)
  166. Converting a range to a table and then creating a pivot table through a series of WBs (0 replies)
  167. [SOLVED:] IF Statement in VBA with Offset (7 replies)
  168. [SOLVED:] Delete Columns based on the font colour in row 1 (7 replies)
  169. Search Dir for Workbook and worksheet and add either as required (3 replies)
  170. How to use Excel to upload a file to web (1 replies)
  171. Multiple text file importing (7 replies)
  172. [SOLVED:] VLOOKUP help (7 replies)
  173. [SOLVED:] Listview sort when column header clicked (1 replies)
  174. [SOLVED:] Making Your Own Date Format (20 replies)
  175. Search Outlook attachments for specific content before sending new e-mail (2 replies)
  176. Copy/Paste Function not working properly in Loop (2 replies)
  177. [SOLVED:] Highlight Lowest Value in a column (11 replies)
  178. ★ Copying paragraphs from other documents with interface (3 replies)
  179. My Macro sits and spins (5 replies)
  180. Application.FileSearch substitute in excel 2010 (1 replies)
  181. Batch protect multiple sheets (1 replies)
  182. [SOLVED:] Dynamic Sort Range. How to code (2 replies)
  183. [SOLVED:] Duplicate Entire row if cell value >15 (3 replies)
  184. [SOLVED:] Simplify Code? (13 replies)
  185. Updating Row Information for Pasting Values (4 replies)
  186. [SOLVED:] Is there a Simple Way to code this. (8 replies)
  187. [SOLVED:] Creating a Function parameter pick list (2 replies)
  188. Status Bar Display (13 replies)
  189. [SOLVED:] Populating a Cell Using Value of Another Cell to Lookup the Desired Value (9 replies)
  190. Hidden sheet in vba form excel vlookup (5 replies)
  191. Loop through the range to find the duplicates and print the number of occurrences (1 replies)
  192. [SOLVED:] Filter based on 3 OR conditions and cut paste the same on different sheet (3 replies)
  193. [SOLVED:] VBA returns negative value when calculating difference between date/times (7 replies)
  194. Merging one sheet from Multiple Workbooks with Headings (1 replies)
  195. create an id generator and copy data within worksheets (13 replies)
  196. Problems with copying multiple worksheets into one workbook (6 replies)
  197. [SOLVED:] worksheet_change to select a range (3 replies)
  198. VBA TANKER volume HELP (2 replies)
  199. VBA - Vertical organization display on set chart (7 replies)
  200. Referring formulas to next row in spreadsheets (Shapes) (0 replies)
  201. [SOLVED:] Want help with a tricky sorting Macro (31 replies)
  202. VBA Filter problem (2 replies)
  203. [SOLVED:] Protecting Passwords and Workbook expiration date (12 replies)
  204. Help with .Find and .FindNext in VBA (1 replies)
  205. Stepping through cells in a range (2 replies)
  206. Age Calculate from textobx (1 replies)
  207. Change file name & path with formula or macro (2 replies)
  208. [SOLVED:] Pivot Table error - Tabular format (2 replies)
  209. Edit/Delete Data Row (0 replies)
  210. [SOLVED:] Round Robin Triggered by Button Click (5 replies)
  211. [SOLVED:] How to create a Macro Pivot Table where the range changes? (2 replies)
  212. Chart creation basis dropdown value (0 replies)
  213. [SOLVED:] Removing the Zeros from Blank Cells (12 replies)
  214. VBA: Get Range of found cell (13 replies)
  215. Use Find in a loop (2 replies)
  216. Run-time error 402 for Userform (4 replies)
  217. vba to insert vlookup between workbooks (0 replies)
  218. Deleting two buttons with similar names (6 replies)
  219. Dynamic Table Using Reference Cells to Adjust Size (10 replies)
  220. Need formula for this (0 replies)
  221. How to select highlighted cells as dynamic range? (2 replies)
  222. [SOLVED:] VBA-highlight cell(s) in a column range if empty or greater than a value (5 replies)
  223. help to write VBA code for ignoring cells with "0" in them (I'm new to this..) (5 replies)
  224. Recordset B takes longer to copy/paste to worksheet than Recordset A, but is smaller! (0 replies)
  225. Need to replace SUMIFS function with VBA code (2 replies)
  226. HELP VBA code (5 replies)
  227. Formula Conumdrum Is Excel up to it. (2 replies)
  228. List to Labels (6 replies)
  229. [help][Important to learn VBA] export the list of classes from VBA Object libraries (9 replies)
  230. macro to search & copy columns from another workbook (5 replies)
  231. [SOLVED:] Excel VBA User Form ( Need Help here please ) (6 replies)
  232. Open all Zipped files within folder of the xlsm file. (1 replies)
  233. Create button with different Find range (1 replies)
  234. [SOLVED:] Importing Worksheets from different Workbook (12 replies)
  235. Creating button by offsetting space (2 replies)
  236. [SOLVED:] Unable to remove "Overflow" message while running the macro (3 replies)
  237. VBA code to import data from a website (1 replies)
  238. [SOLVED:] Macro to find duplicates in a column and add the cell contents together (1 replies)
  239. VBA for Pivot Tables and Slicers (1 replies)
  240. Can someone critique my code please (20 replies)
  241. Vlookup in vba isn't working (2 replies)
  242. [SOLVED:] Macro filtered in column no fill cells in selected sheets (6 replies)
  243. Macro Loop to Copy/Paste picture and set of columns if Checkbox (0 replies)
  244. [SOLVED:] Create a Named range for each Unique Value in Column (7 replies)
  245. Need Help Writing Macro to Simulate Roulette Spins (0 replies)
  246. [SOLVED:] Efficiently searching text array? (4 replies)
  247. conditional formatting based on other cell (over multiple Rows & Column) (0 replies)
  248. [SOLVED:] Macro to copy from Merged Cells (Same Range) to Columns of a New Worksheet (1 replies)
  249. Help Needed: filtering data from to sheets in another sheet currency wise (3 replies)
  250. [SOLVED:] How to replace a symbol like ≤ by using VBA? (13 replies)