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. Solved: Possible Index/Match formula (2 replies)
  2. Assigning a null value to an Integer (2 replies)
  3. mimimum length for a textbox (1 replies)
  4. Solved: compare two columns and delete matches (3 replies)
  5. Solved: Automatically Importing CSV Files into Excel. (10 replies)
  6. display negative values as $0.00 (2 replies)
  7. Solved: Private Sub Help (9 replies)
  8. Creating a new worksheet with appropriate "(name)" attribute (6 replies)
  9. Solved: Lookup / Sumproduct Issue (3 replies)
  10. SUMPRODUCT help needed! (2 replies)
  11. [SOLVED:] Adding a functionality to change the color of ASINS (6 replies)
  12. Solved: extract specific data into the sheet (2 replies)
  13. How to get International formats? (9 replies)
  14. Solved: insert letter into blank cells (2 replies)
  15. Solved: Excel 2007 _Can I store a HELP .txt file inside and .xlsm file? (5 replies)
  16. When I type a word, a formula will be entered in the cell in column D on the same row (3 replies)
  17. Dislay an asterisk after a number (6 replies)
  18. Open PDF file (0 replies)
  19. Solved: Copy a Sheet,delete a range Then save the org Template (1 replies)
  20. Solved: Transposing Data with Non-Standard Fields (13 replies)
  21. Excel 2003 - Clean Up Formula Error Values and other (6 replies)
  22. Automating Userform Mapping to worksheet (2 replies)
  23. Solved: How to get an age from a DOB header with a Stop date? (2 replies)
  24. Macros crash Excel (4 replies)
  25. Solved: Remove Zero Calculated Rows from Pivot Table (2 replies)
  26. Macro to Display Certain Items of a Pivot Field (0 replies)
  27. Solved: Sub arguments (simplifying code) (6 replies)
  28. Combine text using loop (5 replies)
  29. Solved: Help with replace [a-z][A-Z][0-9] (8 replies)
  30. Sleeper: Consolidate files (6 replies)
  31. VBA Project password (2 replies)
  32. Help! Prompt User for Pivot Table Sort Criteria? (0 replies)
  33. Solved: Populate combo box (2 replies)
  34. Solved: How to reference an option box in a checkbox? (5 replies)
  35. Command Button To Expand / Collaspe Subtotals (1 replies)
  36. Problem with Union function when opening multiple datasets (12 replies)
  37. Copy Rows based on cell value! (29 replies)
  38. Solved: Import sheet from closed work book? (2 replies)
  39. Solved: Holiday tracker - suggestions? (1 replies)
  40. Copy Excel workbook without formulas?? (18 replies)
  41. Export a range of data From Excel to Access Database and check for duplication (7 replies)
  42. [SOLVED:] Spell Check an ActiveX TextBox? (5 replies)
  43. Solved: How To Set Global Parameter for macros based on the userform check box clicked (5 replies)
  44. handler for external event (5 replies)
  45. [SOLVED:] Need help with a macro! (2 replies)
  46. Protected Sheet and Data Validation (1 replies)
  47. flashing code (1 replies)
  48. Change Chart Source Range Using Drop Down Box (10 replies)
  49. Solved: Extract Data for specific columns - Formula (2 replies)
  50. mail cc (1 replies)
  51. Check pivot table for value fields (0 replies)
  52. Solved: remove the repeated words/numbers in a cell (6 replies)
  53. Solved: Fill blank cells with date using a criteria (5 replies)
  54. Solved: Userform not opening with a Button (5 replies)
  55. Solved: Compare cells contents (VBA) (2 replies)
  56. Sort Pivot Table based on value of Drop Down List (0 replies)
  57. Solved: Word to Excel Copy (3 replies)
  58. Excel:VB Sum up value in specific field (5 replies)
  59. 2003 vs 2007 (4 replies)
  60. Am stuck! how do I force exit a macro? (4 replies)
  61. clearing text without removing color (1 replies)
  62. Solved: CountIF using two criteria (11 replies)
  63. Solved: Not to highlight when selected (4 replies)
  64. Solved: display 100% maximum (2 replies)
  65. Safe save file in *. xls (12 replies)
  66. how to check a given input is a String (3 replies)
  67. Solved: Delete Column and Row (2 replies)
  68. Using a loop and time delay (5 replies)
  69. list all items (1 replies)
  70. Solved: udf: countif for multiple ranges and sigle or multiple criteria (6 replies)
  71. Cleaning out pivot table and then using same pivot vache (2 replies)
  72. Solved: SUMIF or vba workaround (3 replies)
  73. Solved: Should be a simple sort, but is it? (15 replies)
  74. VBA Code (Excel) - Please Help (4 replies)
  75. Automation of an system issue. (7 replies)
  76. Solved: Global Unknown Size Array (5 replies)
  77. Solved: Unprotecting Cells (3 replies)
  78. Unlocking Options Buttons, Forms and Checkeboxes (7 replies)
  79. Solved: How do I adapt this code to export Multiple Charts? (10 replies)
  80. Solved: Loop In VB Code (6 replies)
  81. Macro to paste a picture in Word (0 replies)
  82. Looping the String in SQL Statement (11 replies)
  83. Solved: Use Advanced Filter In Excel 2003 (2 replies)
  84. Controlling settings in Publisher from Excel (2 replies)
  85. Solved: How to input data from a text to excel using Excel VBA? (3 replies)
  86. move worksheet to end (1 replies)
  87. select a sheet from list (3 replies)
  88. Optional argument in a function error (3 replies)
  89. Solved: create the button on file A, but use it for file B (11 replies)
  90. Reduce macro code size (6 replies)
  91. How can I read a text file and write values into an excel sheet (3 replies)
  92. How to count nbr of QueryTables in workbook (1 replies)
  93. Solved: Find values and distribute in cells (10 replies)
  94. Solved: Renewing data upon opening workbook (2 replies)
  95. Solved: Populate values multiple times date wise (15 replies)
  96. open Microsoft windows mail and attach (4 replies)
  97. Solved: Data Collection (5 replies)
  98. Chart/picture location problem (0 replies)
  99. File on hard drive or network drive (1 replies)
  100. display negative number if greater then 0 (1 replies)
  101. Tab from specific cell to cell (3 replies)
  102. Solved: combo bug in userform (it makes roller) (11 replies)
  103. Solved: How to display information in other columns with missing information (10 replies)
  104. Application.Run (RptObj.Name & "!Main") vs Application.ExecuteExcel4Macro "RUN(""Main (0 replies)
  105. How To Do Relative xPath In CustomXMLNode? (1 replies)
  106. Solved: countdown timer (2 replies)
  107. match/copy/paste (4 replies)
  108. Create "Save As" button on UserForm (2 replies)
  109. Excel 2003/2007 - AutoComplete is inconsistent (0 replies)
  110. VB Inserting image to specific cell in excel (2 replies)
  111. Solved: Macro with launch button (5 replies)
  112. Solved: Excel 2003 - Delete rows with no values in Columns A thru E (5 replies)
  113. Excel VBA - How to Create Read Write Edit Del by ADO - Jet.OLEDB - Access - MDB (3 replies)
  114. Solved: Exporting word data to Excel vba (16 replies)
  115. UserForm Trouble (13 replies)
  116. Solved: Copy values to Empty cells below filled cells in selection (4 replies)
  117. Returning Values (4 replies)
  118. [SLEEPER:] Different pivot charts 'different windows' in the same worksheet (0 replies)
  119. Modifying The Code to Check if the entry exists (2 replies)
  120. Solved: Design Time Vs Run Time (7 replies)
  121. Connecting oracle and excel sheet (10 replies)
  122. Excel 2003 - Need to detect Cell Insert shift left or shift down or Entire Column (5 replies)
  123. Solved: Response Time Formula (2 replies)
  124. userform cancel button (5 replies)
  125. Solved: Change Event not triggering with "Tab" key (2 replies)
  126. Excel-Copy worksheet and timestamp (1 replies)
  127. Solved: MsgBox Item (12 replies)
  128. Powerball Reconciliation (10 replies)
  129. Control Internet Explorer using active URL (1 replies)
  130. Classic 2003 Excel Menu add-in for 2007? (3 replies)
  131. Solved: Autofill till cell left of it is empty (6 replies)
  132. insert control Toolbox failed (2 replies)
  133. Automatically copy cell contents (1 replies)
  134. Copying Contents from one sheet to another (4 replies)
  135. Solved: Drop Down List (6 replies)
  136. Solved: Print different sheets - Print area does not clear - Print_area already exists (2 replies)
  137. Solved: Excel 2003 - Need to determine if any text has been entered into a numbers only cell (1 replies)
  138. Solved: Excel 2003 - Need to clean extra commas from string (8 replies)
  139. Using Index Match across multiple worksheets (5 replies)
  140. Solved: Import Module via VBA code and delete existing Module with same name (4 replies)
  141. Solved: Number Formatting (7 replies)
  142. Input restriction (3 replies)
  143. Updating fields on external input (5 replies)
  144. Changing Tooltip size and color (21 replies)
  145. VBA for Find & Replace (1 replies)
  146. Copying Columns from One Sheet to Another (4 replies)
  147. insert figure end of formula (2 replies)
  148. getting values dynamically from cells A1 t0 A100 (22 replies)
  149. Selecting Blank Cells with in the selection (6 replies)
  150. Solved: Select Collumn based on Cell Value (6 replies)
  151. end(xlup) cant work (6 replies)
  152. Open text file and write to excel file (9 replies)
  153. formula to vba (7 replies)
  154. [SOLVED:] ListBox on a worksheet from Forms Controls Toolbox (9 replies)
  155. Search (3 replies)
  156. code from snow (4 replies)
  157. Asking for VBA help (1 replies)
  158. Solved: Word to Excel (4 replies)
  159. indirect address + skipping cell (0 replies)
  160. macro for workbook source change (1 replies)
  161. Show/Hide button - Excel vba macro - List (5 replies)
  162. Solved: Using Variable Cell in IF Statement Formula (2 replies)
  163. How to create one button for locking/unlocking all sheets (3 replies)
  164. Numbers from strings (6 replies)
  165. Solved: COPY/PASTE OR JOIN (2 replies)
  166. VBA Help (3 replies)
  167. Solved: Slow Down On Running Code (23 replies)
  168. Stuck in OFFICE12 folder after SendMail (1 replies)
  169. Solved: LOAD only visible cells to combobox in userform (4 replies)
  170. find/place based on cell but absolute reference issue/macro mainting sequential order (0 replies)
  171. Solved: copy cell data (2 replies)
  172. Solved: multiple Application objects (3 replies)
  173. copy (3 replies)
  174. Not able to get HTML text including formatting (4 replies)
  175. Solved: Check cell string in column (10 replies)
  176. HELP with VB/HTML code. (5 replies)
  177. Archiving weekly data (7 replies)
  178. Office clipboard as datasource (0 replies)
  179. Solved: Select Case with multiple criteria (12 replies)
  180. VBA Forms - Passing a Variable (4 replies)
  181. Create workbook from template, enable link updating (1 replies)
  182. Solved: WorksheetFunction.Match can't find date (5 replies)
  183. Solved: Excel 2003 - Something faster than a Loop to check the used range surrounding Border (3 replies)
  184. Solved: referencing a tab name in a sumproduct formula (4 replies)
  185. scrolling text on a form (2 replies)
  186. Solved: Color banding (7 replies)
  187. Fill combobox from different worksheet (10 replies)
  188. Trial some VBA CD burn code (0 replies)
  189. Copyingmultiple worksheets (2 replies)
  190. Graphs: Return null value. (4 replies)
  191. Copy Pasting from one workbook to another (8 replies)
  192. Solved: msg box then deleting field when cell changed (6 replies)
  193. Solved: Excel 2003 - Is there a way I can speed up my AutoFill Formula for 15,000 rows? (6 replies)
  194. Solved: Event Macro to trigger if a query should refresh or not (4 replies)
  195. Error running Word from Excel (3 replies)
  196. Solved: Preventing undesired jumping of mark (7 replies)
  197. Remove Contents of a cell based another cell's change... (8 replies)
  198. Solved: Excel 2003- Can a formula in a cell detect how many rows are above it? (2 replies)
  199. Solved: Excel 2003/2007 - Need to trigger the change event if new row is inserted, or deleted (6 replies)
  200. [SOLVED:] Less specific search (9 replies)
  201. search replace Diogonally (12 replies)
  202. Finding and Moving Cells (5 replies)
  203. ADO Connections (6 replies)
  204. CONCATENATE (8 replies)
  205. loop, if and empty (3 replies)
  206. Solved: Counting weekdays (9 replies)
  207. A continuation... Question of method... (1 replies)
  208. Help with Error 91 (4 replies)
  209. pagebreaks (4 replies)
  210. Solved: Output Data from a Userform to a txt file (4 replies)
  211. Hi. Need help creating/saving workbooks. (6 replies)
  212. Using VBA to insert or delete row and column automatic (1 replies)
  213. Solved: Extract and find (6 replies)
  214. Solved: 4 letters (7 replies)
  215. List of Folder,Subfolder & filename (3 replies)
  216. Solved: Excel 2003 - Highlighted row using top & bottom borders. Would like to speed up code (22 replies)
  217. Solved: Excel 2003/2007 - Need to delete top and botom row borders after selection change (2 replies)
  218. Solved: paste to non contiguous named range (12 replies)
  219. Solved: Excel 2003 - how do I Auto Fill a Formula down to the Last Row in a Column? (2 replies)
  220. Solved: Excel Caption (2 replies)
  221. Kindly help me write these excel macros (6 replies)
  222. [SOLVED:] Quick table lookup (2 replies)
  223. Condiitonal formatting dependent on a Comment (4 replies)
  224. Solved: sorting by cell icon (2 replies)
  225. Solved: Countifs Help (4 replies)
  226. COUNT AND FILTER (9 replies)
  227. Getting/Searching Cell value from another Excel Worksheet (4 replies)
  228. Solved: Autofill, last row in column (4 replies)
  229. Solved: Excel 2003 - What is the Cell Character limit? And why do I see #### in the cell? (7 replies)
  230. Solved: Excel 2003 - Need to sum numbers that are in cells formated as text (3 replies)
  231. Fix excel error "Too Many different cell formats" (2 replies)
  232. Solved: Excel Form (6 replies)
  233. Solved: Excel 2003 - Need to change the value in cell that contains a specific autoshape (1 replies)
  234. Solved: Copy current data to a new sheet.... (2 replies)
  235. [SOLVED:] Code for pushbutton click (8 replies)
  236. Solved: Hide worksheets (2 replies)
  237. Solved: Drop Down List (7 replies)
  238. Sum multiple lines based on multiple criteria (7 replies)
  239. Solved: Using Variable Col_Index with VLOOKUP (2 replies)
  240. Goal Seek for multiple rows with blanks between them (4 replies)
  241. Solved: Change Default Font for New Workbook (1 replies)
  242. Solved: Data Validation - Formula Question (3 replies)
  243. How do you merge workbooks into one complete spreadsheet. (6 replies)
  244. rMOVE ZERO (3 replies)
  245. Read out - VBA (1 replies)
  246. Solved: print code (2 replies)
  247. Solved: cell contents were missing once i reopen a file (4 replies)
  248. Solved: Excel 2003 How can I delete a specific shape type within the ActiveSheet (2 replies)
  249. Solved: Excel 2003 Change Event to concatenate Column 8 value to Column 12 Value (2 replies)
  250. Solved: vlookup:Search from bottom row instead of top row (3 replies)