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. Automatically Update/Populate Listbox based on selections of other listbox (4 replies)
  2. initial value for listview from excel (2 replies)
  3. Solved: Protect and unprotect worksheet change (2 replies)
  4. how to Delete Data Row with use of VBA code (4 replies)
  5. 'merge' sheet and adding new sheets; shname() (5 replies)
  6. Solved: Selecting Row with variable (4 replies)
  7. Check box question (6 replies)
  8. Solved: Test if Folder Exists (3 replies)
  9. Solved: stops all other macros except this one (2 replies)
  10. OLE created workbook vs User Created (1 replies)
  11. Solved: How to Delete Data on the other sheet using VBA? (3 replies)
  12. Time capture activity require. (0 replies)
  13. Picking only records based on po #. (4 replies)
  14. How can I put multiple codes in 1 sheet? (7 replies)
  15. Rand() in excel 2000 (3 replies)
  16. Extract data from MS Access table using excel macro. (3 replies)
  17. Lookup value in Table (4 replies)
  18. macro search (15 replies)
  19. User form OHR and Password break. (4 replies)
  20. Search and Replace Macro (7 replies)
  21. can't get caluclate event to fire vba (13 replies)
  22. Trial Code Error (11 replies)
  23. Solved: Binding Macros to Buttons (15 replies)
  24. Paste data in clipboard (1 replies)
  25. Solved: dual purpose TextBox string (6 replies)
  26. Cell Format Number Issue (8 replies)
  27. Terminate Excel Process (4 replies)
  28. Solved: How to stop nuisance warnings (3 replies)
  29. Solved: Date Problem In Chart (6 replies)
  30. Solved: Macro "Stautsbar" from ThisWorkbook i want for whole excel (8 replies)
  31. [SLEEPER:] Email files with same names from folder (5 replies)
  32. [SLEEPER:] Groupwise VBA to Change "From" field (0 replies)
  33. Solved: What's wrong with my copy/paste VBA code (2 replies)
  34. Solved: Range Copy to different worksheets (3 replies)
  35. Copy and paste data based on criteria (0 replies)
  36. Solved: Lookup Values Across Tabs and Set Flag (3 replies)
  37. Solved: Reverse find (2 replies)
  38. Searching folders (0 replies)
  39. Solved: Multiple Column Colour Change (2 replies)
  40. Nice image import code (12 replies)
  41. Solved: Filter worksheet using List Box (multi select) Selections (3 replies)
  42. Solved: Class module for two-dimensional array (2 replies)
  43. Solved: Clear cell not entire row (6 replies)
  44. Skipping the Browse For Folder (3 replies)
  45. Solved: MsgBox - Error (7 replies)
  46. Copy Data From Orders to Database (7 replies)
  47. Solved: A simple formula would probably do the trick (5 replies)
  48. Solved: Rearranging columns (17 replies)
  49. Solved: Import of csv file fails in 2007 only (3 replies)
  50. Dynamicly Fill Listbox with column headers? (2 replies)
  51. Populate ComboBox with contents of ListBox (24 replies)
  52. Multiconditional sort, match and list with exceptions (0 replies)
  53. Lookup from external text file (0 replies)
  54. Arrange sheet data (2 replies)
  55. Solved: Add another sheet to the search (11 replies)
  56. Solved: Search all worksheets (14 replies)
  57. Solved: FileSearch VBA (10 replies)
  58. Solved: Looping named cells (4 replies)
  59. Solved: Email file with password HELP please (8 replies)
  60. Rearrangement of Code & Immediate Windows! (1 replies)
  61. Solved: How to design a code based on excel formula? (2 replies)
  62. Solved: Excel Scatter Graph Horizontal Line (3 replies)
  63. Solved: Populate ListBox with Multiple Rows of Data (4 replies)
  64. complicated Match (3 replies)
  65. Solved: Save As dialog help.......please! (2 replies)
  66. Splitting summary sheet based on workorder ColA. (0 replies)
  67. Solved: DOUBLE LOOKUP HELP (18 replies)
  68. Solved: Outputting Listbox values AND filtering using those values (6 replies)
  69. Extract from worksheet into new workbook, for daily reporting. (3 replies)
  70. Solved: Change Values (4 replies)
  71. Using a defined string in a vlookup (1 replies)
  72. Solved: trim function. (5 replies)
  73. uneditable comboboxes (17 replies)
  74. Identify the write mode of a workbook (3 replies)
  75. Partial format of cell (4 replies)
  76. create list of references (1 replies)
  77. Need a code to place Excel charts to Powerpoint (Different Sizes) (1 replies)
  78. Sleeper: VBA code needed for creating references in Excel (5 replies)
  79. Solved: Copy Worksheets from one Workbook to Another (1 replies)
  80. [SOLVED:] Need macro to remove text (7 replies)
  81. VBA Date Range Argument (4 replies)
  82. Take the size of the Array (3 replies)
  83. Paste Especial/Value/Transpose . . . (8 replies)
  84. Solved: Checkbox control(s)........looping (7 replies)
  85. open multiple workbooks and enable macros, then close (6 replies)
  86. How to get this formula shorter (3 replies)
  87. Solved: Extract data from Website to Excel (5 replies)
  88. windows services in Excel VBA (2 replies)
  89. Holiday and earned time minor problem (2 replies)
  90. delete (33 replies)
  91. Solved: Restrict Saving WorkBook (2 replies)
  92. Calculating 99% in entire cell in Col M. Col M is filtered (5 replies)
  93. How to copy only the headers and columns of requested (3 replies)
  94. Strange things happening (1 replies)
  95. Text Format need help (2 replies)
  96. Solved: the number in this cell is formatted as text (6 replies)
  97. Solved: How to create a VBA program based on lookup formula (10 replies)
  98. Extract GPS data from jpeg file properties with VBA? (5 replies)
  99. A macro to authorize a user to run another macro. (3 replies)
  100. copy transpose (5 replies)
  101. How to alter Paste Range in VBA (2 replies)
  102. Solved: Date Delete (7 replies)
  103. Copy Colours (7 replies)
  104. A macro code to check whether any workbook is currently open or not. (2 replies)
  105. [SOLVED:] Make Selection on sheet1 that will duplicate on all worksheets (5 replies)
  106. Sleeper: Get Combobox2 value if a value is selected in combobox1 in the WorkSheet (1 replies)
  107. Book Recommendation (3 replies)
  108. pivot table question (2 replies)
  109. loop (1 replies)
  110. Solved: Convert time entered on row to ascending dates (6 replies)
  111. Solved: Misserable example.... (3 replies)
  112. Solved: How to assign different face id to macros in a toolbar (3 replies)
  113. display label as Year & text (1 replies)
  114. Solved: Copy Sheets to new workbook and save copy (4 replies)
  115. [SOLVED:] Please Help with Checkbox Alternative (9 replies)
  116. Solved: Populating a userform.... (11 replies)
  117. Column to headings& heading contents to rows (13 replies)
  118. Center userform using Printform (1 replies)
  119. Solved: moltyply times (2 replies)
  120. Solved: DELETE LAST (1 replies)
  121. Solved: Formula Problem (2 replies)
  122. mark duplicate row with condition (1 replies)
  123. INDIRECT VLOOKUP formula problem (4 replies)
  124. Instant messenger in EXCEL (0 replies)
  125. Solved: translate from Excel in VBA (9 replies)
  126. Solved: Calculating Hours Earned (12 replies)
  127. VBA Macro for Log File (5 replies)
  128. Solved: Move columns (8 replies)
  129. Solved: QueryTable wont work in Excel 2007 (3 replies)
  130. Display percent value (5 replies)
  131. Solved: Help With a Formula (14 replies)
  132. Adding values (5 replies)
  133. Solved: Problems with running pre-Excel 2007 macros (1 replies)
  134. Autofilter, copy-paste to new sheet (3 replies)
  135. Solved: VLOOKUP in multiple arrays (17 replies)
  136. Solved: Listing file/folder attributes from user input (2 replies)
  137. Create userForm by code (8 replies)
  138. Solved: Calculating Hours Earned (4 replies)
  139. Solved: How modify VBA to split multiple cell? (4 replies)
  140. Combining multiple worksheets WITHOUT the same arrangement. (1 replies)
  141. Solved: Sort Data Based on Value of a Cell (11 replies)
  142. Solved: Finding Matching Date (7 replies)
  143. Solved: FILE DATE (8 replies)
  144. Solved: Debugging a VBA programm in Visual Basic Editor (VBA Excel ) (1 replies)
  145. Solved: (location) inside of the combobox (5 replies)
  146. Solved: Inserting dynamic range into new table (2 replies)
  147. Solved: Keep selected cell centred (3 replies)
  148. Solved: Macro to sort data ascending (6 replies)
  149. Excel 2000 vs 2003; additional control; substitute (6 replies)
  150. Solved: Managing the Case of First Letter (5 replies)
  151. Sleeper: Invalid references table and copy the valids to another table (1 replies)
  152. Solved: How to calculate running totals (2 replies)
  153. Solved: Question About Circular References (2 replies)
  154. Restrict Worksheet Scrolling Help (4 replies)
  155. Solved: Nested IF function (4 replies)
  156. Solved: One variable defined as text, the other as integer Problem (4 replies)
  157. excel formula in vba (2 replies)
  158. Referring to an array in many subs (1 replies)
  159. How to create a UDF Function? (10 replies)
  160. [SOLVED:] Circular reference in a formula (4 replies)
  161. Mapping Values (1 replies)
  162. VBA - answer "yes" or "no" (3 replies)
  163. SUMIF IN VBA with external references (12 replies)
  164. Unhide Hidden Rows (9 replies)
  165. Solved: VeryHiding Sheets after given date (13 replies)
  166. Report Based on following sample of data (1 replies)
  167. Plugging time in excel sheet (4 replies)
  168. Solved: Data input macro help needed (4 replies)
  169. Solved: Finding Bad Names (13 replies)
  170. How to paste in selected rows of the selected column (19 replies)
  171. Set max value in array item? (6 replies)
  172. Solved: Code to stop all subsequent code and return to userform (6 replies)
  173. C&P format & formula if certain data entered (5 replies)
  174. Imported dates (15 replies)
  175. Solved: Counting Text with commas (5 replies)
  176. Solved: Show Desktop (2 replies)
  177. Picking respective value from different col based on a particular value input. (1 replies)
  178. Code to save to a sub folder? (1 replies)
  179. Solved: VB code to save file to app directory? (6 replies)
  180. Solved: Calculating stock price volatility over and over and over... (7 replies)
  181. Solved: Ending a loop at the bottom of column (13 replies)
  182. Adding to Named Range and Disappearing coloring (3 replies)
  183. Problems with interface design for when long macros process (suggestions welcome!) (3 replies)
  184. Solved: Arrays with Arrays (20 replies)
  185. Solved: Comparing two columns of data and outputting the differences (3 replies)
  186. Solved: Create on the fly labels with click events (7 replies)
  187. Interacting the Search Dialogue Box (9 replies)
  188. Solved: Conditional Formatting (5 replies)
  189. Solved: Adding text to a cell with CheckBoxes (8 replies)
  190. Enable Macros when opening Worksheet (2 replies)
  191. Solved: Animation Control limitations (2 replies)
  192. Solved: MkDir, multiple directories? (3 replies)
  193. Solved: Age calculation (6 replies)
  194. AfterUpdate Event (5 replies)
  195. Interesting Issue With Labeling Data Points (1 replies)
  196. Solved: UDF in Conditional Formating (0 replies)
  197. Solved: Week Number Of The Month (0 replies)
  198. How to Make Handwritten Code or Macros (5 replies)
  199. Spin Button (2 replies)
  200. Solved: Macro processes too much, so Office apps hang until finished! Ideas? (6 replies)
  201. Staff ID Number format (13 replies)
  202. Solved: Userform + Range=#value (8 replies)
  203. Solved: label.caption take text from file (3 replies)
  204. Trigger Macro by change in formula value within a cell (7 replies)
  205. camembert (4 replies)
  206. Solved: Determining size of chart area? (2 replies)
  207. Solved: Run a macro with inputbox (2 replies)
  208. Solved: insert text in columns with itineration (9 replies)
  209. Import txt files into excel (3 replies)
  210. Bring chart infront of web browser (0 replies)
  211. Sending the Email by Excel by searching the Attachment names start with 302568 (0 replies)
  212. Solved: FindNext (16 replies)
  213. unable to set the text property of the characters class (14 replies)
  214. VBA: Identify Last Column with data in a specific Range and copy to next column (3 replies)
  215. Solved: other possibilities? (4 replies)
  216. Exporting Data into Different Cells at Set Intervals (3 replies)
  217. Macro to countif multiple criteria (3 replies)
  218. Excel File Properties in Windows Explorer (2 replies)
  219. Solved: ignore files which are blank? (2 replies)
  220. Solved: text box dependent on list box in userform (2 replies)
  221. Webbrowser control (1 replies)
  222. Populating Oracle SQL Queries in different Sheets in Excel using VBA code (9 replies)
  223. How to control which vba Excel program has control on computer (5 replies)
  224. Converting formula into values. (1 replies)
  225. Excel Custom Headers and Footer (1 replies)
  226. Dynamically Specifying Series and X/Y Values of a Chart (1 replies)
  227. Merging Cells (10 replies)
  228. copy down formula (1 replies)
  229. Solved: SUMIFS (2 replies)
  230. Extending chart series range (2 replies)
  231. Write to Module Using VBA (3 replies)
  232. Help in sorting in data or macro or simple method. (1 replies)
  233. Solved: Option Explicit (6 replies)
  234. Speeding Up Vlookups (2 replies)
  235. Autofilter on row 3 (2 replies)
  236. Solved: error when looping (5 replies)
  237. VBA Column Looping (1 replies)
  238. Excel - transpose multiple records (9 replies)
  239. Solved: Make Code run only on xls files (4 replies)
  240. Solved: Displa first item in combo box (2 replies)
  241. Sumif formula (1 replies)
  242. Solved: Sort Not Working When Formatting Applied (2 replies)
  243. Loop trough workbooks and Paste values (5 replies)
  244. VBA Code to export formula to cells? (3 replies)
  245. Create a List based on Cell Values from multiple Sheets & Columns (2 replies)
  246. Macros for excel (2 replies)
  247. Solved: Applying an Advanced Filter Using VBA (6 replies)
  248. Inter related items (7 replies)
  249. Stop code from running when opening (1 replies)
  250. Solved: Adding pre-fixes (11 replies)