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. Delete rows if cell less than 4 (7 replies)
  2. Solved: Pivot Refresh Problem (6 replies)
  3. [SLEEPER:] Excel to open and run Access Macro (0 replies)
  4. Problem saving as macro-enabled workbook (7 replies)
  5. [SLEEPER:] Looking for the correct sheet and fill in the value refer to date (0 replies)
  6. Delete a worksheet without losing Formula reference (1 replies)
  7. Solved: Import External data into Excel (1 replies)
  8. UserFrom ListBox FilterInPlace on inactive sheet (0 replies)
  9. Solved: Looping Goal Seek Function (8 replies)
  10. Resize Pictures (3 replies)
  11. Object visibility? (4 replies)
  12. Solved: Use of AddShape to add circle (2 replies)
  13. Solved: Cell Reference (6 replies)
  14. How to parse HTML file from VBA code into Excel ? (5 replies)
  15. VBA and cell references (7 replies)
  16. Excel Look up data in a access database (0 replies)
  17. Solved: I want to add a textbox on the chart (1 replies)
  18. Solved: Drop Down Box - (10 replies)
  19. Solved: Help needed with VBA for Alt+F11 (6 replies)
  20. Printing all worksheets in a workbook as a single file.. (6 replies)
  21. Need help with MkDir form Cell (10 replies)
  22. How do I do a best fitting line on Microsoft excel? (1 replies)
  23. Refining ListBoxes (2 replies)
  24. Solved: How to change color of Form Control Button? (2 replies)
  25. Solved: How to protect your VBA codes? (2 replies)
  26. Help needed on variable workbook name. (7 replies)
  27. download file (0 replies)
  28. Solved: combobox on the fly (5 replies)
  29. display records by office (4 replies)
  30. Solved: Write number as string (3 replies)
  31. Need help with events in HTML Table - Excel 2007 (7 replies)
  32. Solved: Do a .Replace on an inactive sheet (1 replies)
  33. Dynamically change size of Array (5 replies)
  34. A rather nasty COUNTIFS statement issue (16 replies)
  35. Solved: Hiding Cells (4 replies)
  36. Activate Excel Window (2 replies)
  37. display records by office (1 replies)
  38. Copy Records to Worksheets based on value (2 replies)
  39. executing T-sql stmts in Excel VBA (3 replies)
  40. Sorting and removing duplets (4 replies)
  41. Solved: How to open sheets as hidden (3 replies)
  42. Solved: Extract data from text file (4 replies)
  43. Email macro stops after sending first email (1 replies)
  44. Trim bug? (0 replies)
  45. data fram pdf (9 replies)
  46. Solved: How to troubleshoot error on my macro? (2 replies)
  47. Problem with Date Filter between two dates (2 replies)
  48. Solved: .Copy Destination (Error) (2 replies)
  49. How to get currently logged on user's account name? (5 replies)
  50. Solved: How will I modify a VBA code that will only calculate the last populated row? (4 replies)
  51. Solved: Error: 1004 - Application-defined... (6 replies)
  52. Solved: Play .wav sound file when userform opened (4 replies)
  53. Formula VBA Help (8 replies)
  54. Need to test if Worksheet Name Exists (4 replies)
  55. Arrange columns of names & addresses into rows (10 replies)
  56. Solved: Update records without looping? (7 replies)
  57. Solved: Excel Formulas based on Lowest cost (8 replies)
  58. Problem with coding Sub (2 replies)
  59. Groupwise attachment loop (0 replies)
  60. Solved: Call Sub Help (11 replies)
  61. Speeding up a loop, that does an action when encounters a value (3 replies)
  62. Solved: Help on alpha numeric subraction... (2 replies)
  63. Hiding column need to be unhide. (2 replies)
  64. Automatically saved into the drop-down list and show edit comments (1 replies)
  65. Finding the difference of two dates based on criterion. (1 replies)
  66. If filename is in sheet, return true/false? (3 replies)
  67. Solved: Auto Protection (7 replies)
  68. Solved: Excel AutoSum (2 replies)
  69. Best Place for Subs (7 replies)
  70. Formula Help (8 replies)
  71. Function or UDF (7 replies)
  72. Filter date from multiple Pivot tables (0 replies)
  73. Solved: reference to a sheet (2 replies)
  74. Run Time Error 1004 (6 replies)
  75. Solved: Sort Question (2 replies)
  76. Solved: 2 sheet search (5 replies)
  77. Solved: list data from 53 sheets (11 replies)
  78. Solved: IF/ ELSEIF Help (10 replies)
  79. How to copy different excel worksheets in one workbook? (1 replies)
  80. Excel 2003 VBA help (9 replies)
  81. Solved: Where can I find a VBA guide? (11 replies)
  82. Excel 2003 question ( using If ) (8 replies)
  83. Checking ref # status based on sheet2 ref #. (0 replies)
  84. accessing gmail attachments (3 replies)
  85. Solved: Finding the Correct Value (3 replies)
  86. line breaks & spaces (6 replies)
  87. Deleting the row that contain the text " Dismantle" (2 replies)
  88. =OFFSET(EntrySht!$B$9,1,0,COUNTA(EntrySht!$B:$B)-1,1) working functionality require. (2 replies)
  89. Next row down (1 replies)
  90. Inserting a row or a column (5 replies)
  91. Solved: Referencing Another Sheet in Workbook (16 replies)
  92. Copy Cell From Workbook and Paste to Another Workbook's Cell (12 replies)
  93. Solved: Changing Text in Buttons (3 replies)
  94. Analysis of Amount based on following criterion. (8 replies)
  95. Computing 99% of COl M while cell is in filtered mode. (1 replies)
  96. Poll of numbers HELP! (12 replies)
  97. At a loss for direction.. (8 replies)
  98. New worksheet using template based on cell values (31 replies)
  99. Solved: Finding Last Visible Row (2 replies)
  100. Costing schedules (5 replies)
  101. Solved: Unexpected error. (16 replies)
  102. Solved: If Esle..If VBA (8 replies)
  103. VBA script in excel! help (7 replies)
  104. Solved: lookup function in VBA (4 replies)
  105. sort columns via listview (0 replies)
  106. how to open a existing worksheet from certain folder and creating new workbook (2 replies)
  107. Excel Status bar will not update (14 replies)
  108. cells contain hidden values (3 replies)
  109. Solved: Accessing specific sheet by password box (4 replies)
  110. Solved: A macro to saveas a worksheet as a new workbook (2 replies)
  111. Solved: macro to replace error formula cells in a column with some other text or number. (2 replies)
  112. Solved: macro to Delete entire row based on a criteria. (16 replies)
  113. Number format of cell which contains formula (2 replies)
  114. Solved: referencing specific worksheets in vba (17 replies)
  115. How to colour an entire row, on row number click (9 replies)
  116. Filter not work with xl2007? (3 replies)
  117. Solved: Delete zeros (4 replies)
  118. Solved: IF Statement Limit Reached (15 replies)
  119. How to filter data with a multi-selection listbox (28 replies)
  120. Solved: Create backup to another location (6 replies)
  121. Data mapping from one excel workbook to another excel workbook (0 replies)
  122. Solved: Combobox data to listbox or textbox? (6 replies)
  123. Solved: Listbox Related Question (4 replies)
  124. Solved: Similar case (3 replies)
  125. Solved: Add negatives? (4 replies)
  126. Solved: Auto open macro help (7 replies)
  127. Save Excel using VBA (6 replies)
  128. Solved: Need help exporting data based on listbox selection (5 replies)
  129. How can i plot a Graph on Microsoft Excel? (1 replies)
  130. How to define workbook is open in which process (12 replies)
  131. Solved: Questions regarding Excel vs VBA (14 replies)
  132. public object module error (9 replies)
  133. Using a case statement (3 replies)
  134. highlight specific cells in active row/column (2 replies)
  135. Solved: How to show a Calendar in Combo cube dropdown on a excel Userform. (2 replies)
  136. What are CUBES when used in Excel (9 replies)
  137. Adjusting macro to loop through criteria (0 replies)
  138. Solved: Does VBA need a pause inserted (5 replies)
  139. Solved: Clear Contents on Workbook Close (5 replies)
  140. remote update of code (1 replies)
  141. Delete Rows when Condition is met (1 replies)
  142. Solved: Combining 1 Cell from sheets into List (2 replies)
  143. Scanning data series and plotting based on data (1 replies)
  144. Solved: Run Macro on Cell Change (2 replies)
  145. A faster/more efficient way? (3 replies)
  146. SaveAs and Fileformat (0 replies)
  147. Copy/Paste if cell contains "123" characters (3 replies)
  148. working with ranges of merged cells (0 replies)
  149. Solved: Insert Rows, AutoFilter, xlCellTypeVisible (8 replies)
  150. How To Write Find Function Using Macro (7 replies)
  151. VBA - Dodgy IF statement results from certain numbers (2 replies)
  152. Solved: populate multicolumns of listview (3 replies)
  153. Solved: Changing Arrays (4 replies)
  154. hiding formulae in excel 2007 (2 replies)
  155. Sleeper: Min,Max,First and Last Values within Time window (16 replies)
  156. Solved: put a range into a variable (6 replies)
  157. External Formula (17 replies)
  158. Solved: Working with a Filtered Dataset (6 replies)
  159. Solved: Multipage/Treeview Expansion problem (3 replies)
  160. Solved: How to delete columns that go through an area with merged cells (5 replies)
  161. Solved: Formulas are not being copied correctly (12 replies)
  162. Solved: ISERROR VBA CODE (14 replies)
  163. Solved: VLookup in VBA (2 replies)
  164. Solved: find the letter for the last colomn (4 replies)
  165. Save to new workbook and delete a specific sheet (1 replies)
  166. How to only keep duplicate values (2 replies)
  167. emailing cell range (1 replies)
  168. Copying rows in range based on criteria (8 replies)
  169. Copy and Paste in Filter (10 replies)
  170. Solved: Enter a cummulative value into a cell (2 replies)
  171. Automatically Update/Populate Listbox based on selections of other listbox (4 replies)
  172. initial value for listview from excel (2 replies)
  173. Solved: Protect and unprotect worksheet change (2 replies)
  174. how to Delete Data Row with use of VBA code (4 replies)
  175. 'merge' sheet and adding new sheets; shname() (5 replies)
  176. Solved: Selecting Row with variable (4 replies)
  177. Check box question (6 replies)
  178. Solved: Test if Folder Exists (3 replies)
  179. Solved: stops all other macros except this one (2 replies)
  180. OLE created workbook vs User Created (1 replies)
  181. Solved: How to Delete Data on the other sheet using VBA? (3 replies)
  182. Time capture activity require. (0 replies)
  183. Picking only records based on po #. (4 replies)
  184. How can I put multiple codes in 1 sheet? (7 replies)
  185. Rand() in excel 2000 (3 replies)
  186. Extract data from MS Access table using excel macro. (3 replies)
  187. Lookup value in Table (4 replies)
  188. macro search (15 replies)
  189. User form OHR and Password break. (4 replies)
  190. Search and Replace Macro (7 replies)
  191. can't get caluclate event to fire vba (13 replies)
  192. Trial Code Error (11 replies)
  193. Solved: Binding Macros to Buttons (15 replies)
  194. Paste data in clipboard (1 replies)
  195. Solved: dual purpose TextBox string (6 replies)
  196. Cell Format Number Issue (8 replies)
  197. Terminate Excel Process (4 replies)
  198. Solved: How to stop nuisance warnings (3 replies)
  199. Solved: Date Problem In Chart (6 replies)
  200. Solved: Macro "Stautsbar" from ThisWorkbook i want for whole excel (8 replies)
  201. [SLEEPER:] Email files with same names from folder (5 replies)
  202. Groupwise VBA to Change "From" field (0 replies)
  203. Solved: What's wrong with my copy/paste VBA code (2 replies)
  204. Solved: Range Copy to different worksheets (3 replies)
  205. Copy and paste data based on criteria (0 replies)
  206. Solved: Lookup Values Across Tabs and Set Flag (3 replies)
  207. Solved: Reverse find (2 replies)
  208. Searching folders (0 replies)
  209. Solved: Multiple Column Colour Change (2 replies)
  210. Nice image import code (12 replies)
  211. Solved: Filter worksheet using List Box (multi select) Selections (3 replies)
  212. Solved: Class module for two-dimensional array (2 replies)
  213. Solved: Clear cell not entire row (6 replies)
  214. Skipping the Browse For Folder (3 replies)
  215. Solved: MsgBox - Error (7 replies)
  216. Copy Data From Orders to Database (7 replies)
  217. Solved: A simple formula would probably do the trick (5 replies)
  218. Solved: Rearranging columns (17 replies)
  219. Solved: Import of csv file fails in 2007 only (3 replies)
  220. Dynamicly Fill Listbox with column headers? (2 replies)
  221. Populate ComboBox with contents of ListBox (24 replies)
  222. Multiconditional sort, match and list with exceptions (0 replies)
  223. Lookup from external text file (0 replies)
  224. Arrange sheet data (2 replies)
  225. Solved: Add another sheet to the search (11 replies)
  226. Solved: Search all worksheets (14 replies)
  227. Solved: FileSearch VBA (10 replies)
  228. Solved: Looping named cells (4 replies)
  229. Solved: Email file with password HELP please (8 replies)
  230. Rearrangement of Code & Immediate Windows! (1 replies)
  231. Solved: How to design a code based on excel formula? (2 replies)
  232. Solved: Excel Scatter Graph Horizontal Line (3 replies)
  233. Solved: Populate ListBox with Multiple Rows of Data (4 replies)
  234. complicated Match (3 replies)
  235. Solved: Save As dialog help.......please! (2 replies)
  236. Splitting summary sheet based on workorder ColA. (0 replies)
  237. Solved: DOUBLE LOOKUP HELP (18 replies)
  238. Solved: Outputting Listbox values AND filtering using those values (6 replies)
  239. Extract from worksheet into new workbook, for daily reporting. (3 replies)
  240. Solved: Change Values (4 replies)
  241. Using a defined string in a vlookup (1 replies)
  242. Solved: trim function. (5 replies)
  243. uneditable comboboxes (17 replies)
  244. Identify the write mode of a workbook (3 replies)
  245. Partial format of cell (4 replies)
  246. create list of references (1 replies)
  247. Need a code to place Excel charts to Powerpoint (Different Sizes) (1 replies)
  248. Sleeper: VBA code needed for creating references in Excel (5 replies)
  249. Solved: Copy Worksheets from one Workbook to Another (1 replies)
  250. [SOLVED:] Need macro to remove text (7 replies)