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. Copy Cell From Workbook and Paste to Another Workbook's Cell (12 replies)
  2. Solved: Changing Text in Buttons (3 replies)
  3. Analysis of Amount based on following criterion. (8 replies)
  4. Computing 99% of COl M while cell is in filtered mode. (1 replies)
  5. Poll of numbers HELP! (12 replies)
  6. At a loss for direction.. (8 replies)
  7. New worksheet using template based on cell values (31 replies)
  8. Solved: Finding Last Visible Row (2 replies)
  9. Costing schedules (5 replies)
  10. Solved: Unexpected error. (16 replies)
  11. Solved: If Esle..If VBA (8 replies)
  12. VBA script in excel! help (7 replies)
  13. Solved: lookup function in VBA (4 replies)
  14. sort columns via listview (0 replies)
  15. how to open a existing worksheet from certain folder and creating new workbook (2 replies)
  16. Excel Status bar will not update (14 replies)
  17. cells contain hidden values (3 replies)
  18. Solved: Accessing specific sheet by password box (4 replies)
  19. Solved: A macro to saveas a worksheet as a new workbook (2 replies)
  20. Solved: macro to replace error formula cells in a column with some other text or number. (2 replies)
  21. Solved: macro to Delete entire row based on a criteria. (16 replies)
  22. Number format of cell which contains formula (2 replies)
  23. Solved: referencing specific worksheets in vba (17 replies)
  24. How to colour an entire row, on row number click (9 replies)
  25. Filter not work with xl2007? (3 replies)
  26. Solved: Delete zeros (4 replies)
  27. Solved: IF Statement Limit Reached (15 replies)
  28. How to filter data with a multi-selection listbox (28 replies)
  29. Solved: Create backup to another location (6 replies)
  30. Data mapping from one excel workbook to another excel workbook (0 replies)
  31. Solved: Combobox data to listbox or textbox? (6 replies)
  32. Solved: Listbox Related Question (4 replies)
  33. Solved: Similar case (3 replies)
  34. Solved: Add negatives? (4 replies)
  35. Solved: Auto open macro help (7 replies)
  36. Save Excel using VBA (6 replies)
  37. Solved: Need help exporting data based on listbox selection (5 replies)
  38. How can i plot a Graph on Microsoft Excel? (1 replies)
  39. How to define workbook is open in which process (12 replies)
  40. Solved: Questions regarding Excel vs VBA (14 replies)
  41. public object module error (9 replies)
  42. Using a case statement (3 replies)
  43. highlight specific cells in active row/column (2 replies)
  44. Solved: How to show a Calendar in Combo cube dropdown on a excel Userform. (2 replies)
  45. What are CUBES when used in Excel (9 replies)
  46. Adjusting macro to loop through criteria (0 replies)
  47. Solved: Does VBA need a pause inserted (5 replies)
  48. Solved: Clear Contents on Workbook Close (5 replies)
  49. remote update of code (1 replies)
  50. Delete Rows when Condition is met (1 replies)
  51. Solved: Combining 1 Cell from sheets into List (2 replies)
  52. Scanning data series and plotting based on data (1 replies)
  53. Solved: Run Macro on Cell Change (2 replies)
  54. A faster/more efficient way? (3 replies)
  55. SaveAs and Fileformat (0 replies)
  56. Copy/Paste if cell contains "123" characters (3 replies)
  57. working with ranges of merged cells (0 replies)
  58. Solved: Insert Rows, AutoFilter, xlCellTypeVisible (8 replies)
  59. How To Write Find Function Using Macro (7 replies)
  60. VBA - Dodgy IF statement results from certain numbers (2 replies)
  61. Solved: populate multicolumns of listview (3 replies)
  62. Solved: Changing Arrays (4 replies)
  63. hiding formulae in excel 2007 (2 replies)
  64. [SLEEPER:] Min,Max,First and Last Values within Time window (16 replies)
  65. Solved: put a range into a variable (6 replies)
  66. External Formula (17 replies)
  67. Solved: Working with a Filtered Dataset (6 replies)
  68. Solved: Multipage/Treeview Expansion problem (3 replies)
  69. Solved: How to delete columns that go through an area with merged cells (5 replies)
  70. Solved: Formulas are not being copied correctly (12 replies)
  71. [SOLVED:] ISERROR VBA CODE (14 replies)
  72. Solved: VLookup in VBA (2 replies)
  73. Solved: find the letter for the last colomn (4 replies)
  74. Save to new workbook and delete a specific sheet (1 replies)
  75. How to only keep duplicate values (2 replies)
  76. emailing cell range (1 replies)
  77. Copying rows in range based on criteria (8 replies)
  78. Copy and Paste in Filter (10 replies)
  79. Solved: Enter a cummulative value into a cell (2 replies)
  80. Automatically Update/Populate Listbox based on selections of other listbox (4 replies)
  81. initial value for listview from excel (2 replies)
  82. Solved: Protect and unprotect worksheet change (2 replies)
  83. how to Delete Data Row with use of VBA code (4 replies)
  84. 'merge' sheet and adding new sheets; shname() (5 replies)
  85. Solved: Selecting Row with variable (4 replies)
  86. Check box question (6 replies)
  87. Solved: Test if Folder Exists (3 replies)
  88. Solved: stops all other macros except this one (2 replies)
  89. OLE created workbook vs User Created (1 replies)
  90. Solved: How to Delete Data on the other sheet using VBA? (3 replies)
  91. Time capture activity require. (0 replies)
  92. Picking only records based on po #. (4 replies)
  93. How can I put multiple codes in 1 sheet? (7 replies)
  94. Rand() in excel 2000 (3 replies)
  95. Extract data from MS Access table using excel macro. (3 replies)
  96. Lookup value in Table (4 replies)
  97. macro search (15 replies)
  98. User form OHR and Password break. (4 replies)
  99. Search and Replace Macro (7 replies)
  100. can't get caluclate event to fire vba (13 replies)
  101. Trial Code Error (11 replies)
  102. Solved: Binding Macros to Buttons (15 replies)
  103. Paste data in clipboard (1 replies)
  104. Solved: dual purpose TextBox string (6 replies)
  105. Cell Format Number Issue (8 replies)
  106. Terminate Excel Process (4 replies)
  107. Solved: How to stop nuisance warnings (3 replies)
  108. Solved: Date Problem In Chart (6 replies)
  109. Solved: Macro "Stautsbar" from ThisWorkbook i want for whole excel (8 replies)
  110. [SLEEPER:] Email files with same names from folder (5 replies)
  111. [SLEEPER:] Groupwise VBA to Change "From" field (0 replies)
  112. Solved: What's wrong with my copy/paste VBA code (2 replies)
  113. Solved: Range Copy to different worksheets (3 replies)
  114. Copy and paste data based on criteria (0 replies)
  115. Solved: Lookup Values Across Tabs and Set Flag (3 replies)
  116. Solved: Reverse find (2 replies)
  117. Searching folders (0 replies)
  118. Solved: Multiple Column Colour Change (2 replies)
  119. Nice image import code (12 replies)
  120. Solved: Filter worksheet using List Box (multi select) Selections (3 replies)
  121. Solved: Class module for two-dimensional array (2 replies)
  122. Solved: Clear cell not entire row (6 replies)
  123. Skipping the Browse For Folder (3 replies)
  124. Solved: MsgBox - Error (7 replies)
  125. Copy Data From Orders to Database (7 replies)
  126. Solved: A simple formula would probably do the trick (5 replies)
  127. Solved: Rearranging columns (17 replies)
  128. Solved: Import of csv file fails in 2007 only (3 replies)
  129. Dynamicly Fill Listbox with column headers? (2 replies)
  130. [SLEEPER:] Populate ComboBox with contents of ListBox (24 replies)
  131. Multiconditional sort, match and list with exceptions (0 replies)
  132. Lookup from external text file (0 replies)
  133. Arrange sheet data (2 replies)
  134. Solved: Add another sheet to the search (11 replies)
  135. Solved: Search all worksheets (14 replies)
  136. Solved: FileSearch VBA (10 replies)
  137. Solved: Looping named cells (4 replies)
  138. Solved: Email file with password HELP please (8 replies)
  139. Rearrangement of Code & Immediate Windows! (1 replies)
  140. Solved: How to design a code based on excel formula? (2 replies)
  141. Solved: Excel Scatter Graph Horizontal Line (3 replies)
  142. Solved: Populate ListBox with Multiple Rows of Data (4 replies)
  143. complicated Match (3 replies)
  144. Solved: Save As dialog help.......please! (2 replies)
  145. Splitting summary sheet based on workorder ColA. (0 replies)
  146. Solved: DOUBLE LOOKUP HELP (18 replies)
  147. Solved: Outputting Listbox values AND filtering using those values (6 replies)
  148. Extract from worksheet into new workbook, for daily reporting. (3 replies)
  149. Solved: Change Values (4 replies)
  150. Using a defined string in a vlookup (1 replies)
  151. Solved: trim function. (5 replies)
  152. uneditable comboboxes (17 replies)
  153. Identify the write mode of a workbook (3 replies)
  154. Partial format of cell (4 replies)
  155. create list of references (1 replies)
  156. Need a code to place Excel charts to Powerpoint (Different Sizes) (1 replies)
  157. Sleeper: VBA code needed for creating references in Excel (5 replies)
  158. Solved: Copy Worksheets from one Workbook to Another (1 replies)
  159. [SOLVED:] Need macro to remove text (7 replies)
  160. VBA Date Range Argument (4 replies)
  161. Take the size of the Array (3 replies)
  162. Paste Especial/Value/Transpose . . . (8 replies)
  163. Solved: Checkbox control(s)........looping (7 replies)
  164. open multiple workbooks and enable macros, then close (6 replies)
  165. How to get this formula shorter (3 replies)
  166. Solved: Extract data from Website to Excel (5 replies)
  167. windows services in Excel VBA (2 replies)
  168. Holiday and earned time minor problem (2 replies)
  169. delete (33 replies)
  170. Solved: Restrict Saving WorkBook (2 replies)
  171. Calculating 99% in entire cell in Col M. Col M is filtered (5 replies)
  172. How to copy only the headers and columns of requested (3 replies)
  173. Strange things happening (1 replies)
  174. Text Format need help (2 replies)
  175. Solved: the number in this cell is formatted as text (6 replies)
  176. Solved: How to create a VBA program based on lookup formula (10 replies)
  177. Extract GPS data from jpeg file properties with VBA? (5 replies)
  178. A macro to authorize a user to run another macro. (3 replies)
  179. copy transpose (5 replies)
  180. How to alter Paste Range in VBA (2 replies)
  181. Solved: Date Delete (7 replies)
  182. Copy Colours (7 replies)
  183. A macro code to check whether any workbook is currently open or not. (2 replies)
  184. [SOLVED:] Make Selection on sheet1 that will duplicate on all worksheets (5 replies)
  185. Sleeper: Get Combobox2 value if a value is selected in combobox1 in the WorkSheet (1 replies)
  186. Book Recommendation (3 replies)
  187. pivot table question (2 replies)
  188. loop (1 replies)
  189. Solved: Convert time entered on row to ascending dates (6 replies)
  190. Solved: Misserable example.... (3 replies)
  191. Solved: How to assign different face id to macros in a toolbar (3 replies)
  192. display label as Year & text (1 replies)
  193. Solved: Copy Sheets to new workbook and save copy (4 replies)
  194. [SOLVED:] Please Help with Checkbox Alternative (9 replies)
  195. Solved: Populating a userform.... (11 replies)
  196. Column to headings& heading contents to rows (13 replies)
  197. Center userform using Printform (1 replies)
  198. Solved: moltyply times (2 replies)
  199. Solved: DELETE LAST (1 replies)
  200. Solved: Formula Problem (2 replies)
  201. mark duplicate row with condition (1 replies)
  202. INDIRECT VLOOKUP formula problem (4 replies)
  203. Instant messenger in EXCEL (0 replies)
  204. Solved: translate from Excel in VBA (9 replies)
  205. Solved: Calculating Hours Earned (12 replies)
  206. VBA Macro for Log File (5 replies)
  207. Solved: Move columns (8 replies)
  208. Solved: QueryTable wont work in Excel 2007 (3 replies)
  209. Display percent value (5 replies)
  210. Solved: Help With a Formula (14 replies)
  211. [SOLVED:] Adding values (5 replies)
  212. Solved: Problems with running pre-Excel 2007 macros (1 replies)
  213. Autofilter, copy-paste to new sheet (3 replies)
  214. Solved: VLOOKUP in multiple arrays (17 replies)
  215. [SOLVED:] Listing file/folder attributes from user input (2 replies)
  216. Create userForm by code (8 replies)
  217. Solved: Calculating Hours Earned (4 replies)
  218. Solved: How modify VBA to split multiple cell? (4 replies)
  219. Combining multiple worksheets WITHOUT the same arrangement. (1 replies)
  220. Solved: Sort Data Based on Value of a Cell (11 replies)
  221. Solved: Finding Matching Date (7 replies)
  222. Solved: FILE DATE (8 replies)
  223. Solved: Debugging a VBA programm in Visual Basic Editor (VBA Excel ) (1 replies)
  224. Solved: (location) inside of the combobox (5 replies)
  225. Solved: Inserting dynamic range into new table (2 replies)
  226. Solved: Keep selected cell centred (3 replies)
  227. Solved: Macro to sort data ascending (6 replies)
  228. Excel 2000 vs 2003; additional control; substitute (6 replies)
  229. Solved: Managing the Case of First Letter (5 replies)
  230. Sleeper: Invalid references table and copy the valids to another table (1 replies)
  231. Solved: How to calculate running totals (2 replies)
  232. Solved: Question About Circular References (2 replies)
  233. Restrict Worksheet Scrolling Help (4 replies)
  234. Solved: Nested IF function (4 replies)
  235. Solved: One variable defined as text, the other as integer Problem (4 replies)
  236. excel formula in vba (2 replies)
  237. Referring to an array in many subs (1 replies)
  238. How to create a UDF Function? (10 replies)
  239. [SOLVED:] Circular reference in a formula (4 replies)
  240. Mapping Values (1 replies)
  241. VBA - answer "yes" or "no" (3 replies)
  242. SUMIF IN VBA with external references (12 replies)
  243. Unhide Hidden Rows (9 replies)
  244. Solved: VeryHiding Sheets after given date (13 replies)
  245. Report Based on following sample of data (1 replies)
  246. Plugging time in excel sheet (4 replies)
  247. Solved: Data input macro help needed (4 replies)
  248. Solved: Finding Bad Names (13 replies)
  249. How to paste in selected rows of the selected column (19 replies)
  250. Set max value in array item? (6 replies)