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 Row if Cell Contents = "ABC" (6 replies)
  2. Solved: Copy rows from one worksheet to another with some condition. (4 replies)
  3. Auto sort consolidation book (7 replies)
  4. Solved: Data Validation list based on a filtered list. (2 replies)
  5. Pivot Table Stored Proc with Parameter (1 replies)
  6. save sheets as new version: changes required in existing macro (1 replies)
  7. Solved: Copy the text from WORD to EXCEL (4 replies)
  8. Absolute value (1 replies)
  9. Sorting a table (1 replies)
  10. excel save as csv (4 replies)
  11. Using 'IsNumber' in a Select Case (2 replies)
  12. Solved: Timing a For Loop (2 replies)
  13. referring to numbers/alphabets (8 replies)
  14. Solved: (VBA) Recursively list files and output to csv (2 replies)
  15. Pivot Table - Getting Correct Profit % (2 replies)
  16. ADO Version (2 replies)
  17. Solved: locking VBA project (5 replies)
  18. Solved: Inserting formulae into Used range (2 replies)
  19. Solved: Deleting Rows (2 replies)
  20. Scrolling not working for TreeView (0 replies)
  21. Need comments (1 replies)
  22. [SOLVED:] Delete Sheet In VBA Project Window (1 replies)
  23. Printing In Excel (2 replies)
  24. Solved: Problem Launching Excel from Access with CreateObject (2 replies)
  25. Solved: hiding Rows using index number (3 replies)
  26. Solved: worksheet value change affecting 2 cells (5 replies)
  27. Solved: Why is this not working? (7 replies)
  28. how come temp files keep showing up (2 replies)
  29. Solved: little sub that can MERGE (3 replies)
  30. ODBC in VBA excel (5 replies)
  31. Solved: intersection of named range and a column (3 replies)
  32. preserve regional settings when saving to xlTextPrinter (1 replies)
  33. Run macro whenever you change sheets (2 replies)
  34. Format values copied and concatenated (2 replies)
  35. How to use ' to ignore large section of codes (4 replies)
  36. Count Empty Range and MsgBox (4 replies)
  37. Input Box/User Form (3 replies)
  38. Chart object fails (8 replies)
  39. ListBox Transfer Query (2 replies)
  40. Solved: Search directory and return values (19 replies)
  41. Import range from closed excel file (1 replies)
  42. Using if statements in PivotTable formulas (2 replies)
  43. Folder Search File List (4 replies)
  44. Passing data between a main code and an UserForm (6 replies)
  45. Find matching columns/cells and copying over data (1 replies)
  46. using wildcards in Formulas (1 replies)
  47. Verify that a Hyperlink successfully opened (0 replies)
  48. Adding a,b,c letter to duplicates (4 replies)
  49. how to check if file is read only, but from other file (4 replies)
  50. Excel refresh page (3 replies)
  51. Solved: Resize autofilter (2 replies)
  52. Changing Colour Palette (3 replies)
  53. Evaluating a string of an array (3 replies)
  54. Solved: Lookup Column A value and add Column X- then copy to other sheet (5 replies)
  55. Solved: Copying formula down used range (2 replies)
  56. Convert entity in excel (1 replies)
  57. Need to know how to copy into next blank column (1 replies)
  58. [SOLVED:] Auto Fill into Text Box / cell (3 replies)
  59. Renaming not working correctly (7 replies)
  60. Solved: Problems with creating a shift-plan for a new year (10 replies)
  61. Sleeper: Activecell.offset (3 replies)
  62. append color text (VBA) (2 replies)
  63. 3D Chart (10 replies)
  64. Filter data (8 replies)
  65. Solved: OFFSET and MATCH formula not working (4 replies)
  66. Creating a standard form (1 replies)
  67. Why does the path appears in some function formulas but not in others? (5 replies)
  68. Solved: Need errorhandling for "print sheet" buttons (6 replies)
  69. Lookup on two values and copy cells when match found (7 replies)
  70. Solved: VBA: 'Subscript out of range' Error ... (20 replies)
  71. Button macro (9 replies)
  72. Get data from protected file, changes required in existing code (4 replies)
  73. Copy row data another worksheet in columns (0 replies)
  74. File Chooser Needed (6 replies)
  75. auto conversion (0 replies)
  76. .Find and Dates.. (13 replies)
  77. Have worksheet refresh only for changes in certain cells (3 replies)
  78. Excel 2007 Legend Border (1 replies)
  79. Solved: pivot table problem (5 replies)
  80. return column of change (3 replies)
  81. Solved: Remove first word in a string (13 replies)
  82. Solved: Worksheet Protection except Specific Column (3 replies)
  83. Solved: Excel: Sumproduct or Nested IF statement help (3 replies)
  84. Intersect function to find matching row AND column? (3 replies)
  85. Counting Forward x number of months from given date (1 replies)
  86. E-mail attachment with VBA from Excel (4 replies)
  87. Solved: Insert Row every nth row (3 replies)
  88. Vlookup from autoupdating master (5 replies)
  89. Help! Macro to copy worksheet from different templates (6 replies)
  90. Test 3 spots (1 replies)
  91. Solved: Determining Type of Data in a Column (5 replies)
  92. Using VBA to create WordArt (4 replies)
  93. Adding Comments to a Formula (8 replies)
  94. Multicolumn ListBox - Moving item upwards (1 replies)
  95. Print Multiple Pages from DropDown Box using Macros? (5 replies)
  96. Conditional selection in excel VBA? (3 replies)
  97. Solved: Need Help : VBA in EXCEL / (if possible in DIAdem software) (25 replies)
  98. Vlookup from two cells (5 replies)
  99. highlighting over due dates (1 replies)
  100. Simple find? (8 replies)
  101. Solved: Cell Interior.ColorIndex Property Changing (2 replies)
  102. Solved: VBA HTML - how do I access this button? (2 replies)
  103. Solved: Formula to capture cell's displayed value (6 replies)
  104. Solved: populate text box from combo box via vlookup function (4 replies)
  105. Solved: Editing Cell Comments Via VBA (2 replies)
  106. New to VBA (6 replies)
  107. Solved: .AddItme help (4 replies)
  108. Removing duplicates with a difference (2 replies)
  109. activecell.value - change from sub (3 replies)
  110. Compting 99% of a col range while autofilter is on. (1 replies)
  111. Conditional Formatting & Reading Fill Value (5 replies)
  112. Solved: Passing Variables from Sheet Code to Module Code (1 replies)
  113. Formula in VBA problem (3 replies)
  114. 2 dimensonial lookup formula not working (1 replies)
  115. Solved: Combo Box question (2 replies)
  116. Closing Excel & Opening Access (1 replies)
  117. Solved: Insert Formula by VBA method (5 replies)
  118. Solved: for loop (1 replies)
  119. How to Fetch Web Data into Excle (19 replies)
  120. Solved: Read Only: Disable opening/or disable prompt-to-save-as? (5 replies)
  121. Tooltip Variable Values Vanished from VBE! (0 replies)
  122. lines in a cell or dropdown to next cell (10 replies)
  123. How to randomly choose sample rows after using Autofilter?? (19 replies)
  124. using sumproduct or sumif (6 replies)
  125. Setting the value of a cell to the value of a variable (6 replies)
  126. qty breakdown for inventory (5 replies)
  127. Solved: Before print function (4 replies)
  128. Solved: If/then statment where "then" does multiple actions? (6 replies)
  129. Excel and Access (1 replies)
  130. excel vba to autofit row after cell update (1 replies)
  131. Solved: Select Case with > 1 Variable (3 replies)
  132. Help RC FORMULA STYLE (3 replies)
  133. Copying to next empty row (0 replies)
  134. auto create text (3 replies)
  135. Solved: Add Text to Old Call/New Call (7 replies)
  136. PIvot Tabel macro no longer works since upgrade to Excel 2007 (0 replies)
  137. Inserting a row and moving a particular cell down one row (6 replies)
  138. txtDate (6 replies)
  139. Solved: How did I screw up Johnske's routine to force macro enabling? (2 replies)
  140. Automation of Data Transformation and Consolidation (0 replies)
  141. help with re-calculating Excel UDF (3 replies)
  142. Accessing files on webpage (0 replies)
  143. Excel 2007 Populate table with web query (0 replies)
  144. Compare cells and highlight on a result (2 replies)
  145. change formulas to (8 replies)
  146. Copy Entire Row if Column Value is Negative (20 replies)
  147. Solved: named ranges (3 replies)
  148. Solved: move sheets from specific files each time a macro runs (8 replies)
  149. Can we compare the Excel columns alone (5 replies)
  150. Problem when using OFFSET (7 replies)
  151. Solved: BIN2HEX Worksheet Problem (8 replies)
  152. [SLEEPER:] Initialize cell with mmult formula (2 replies)
  153. Solved: Pass an InputBox value into number of rows (3 replies)
  154. set cell value (3 replies)
  155. Solved: Select large array of non-contiguous ranges (4 replies)
  156. Ticking Clock (4 replies)
  157. First Time VBA'(er?) (2 replies)
  158. Solved: Using A Date in DSum formula (1 replies)
  159. Solved: Setting default date in calendar (4 replies)
  160. Help require in lookin for option button click event code. (1 replies)
  161. number format (2 replies)
  162. Execute diferent formula depending on cell value (3 replies)
  163. Problem with SetFocus (8 replies)
  164. Solved: Counting based on 2 criteria (2 replies)
  165. Solved: Looking up date and calculating monthly returns (11 replies)
  166. Activate Method of Range Fails (2 replies)
  167. Solved: Formula Improvement - Hours * Rate (2 replies)
  168. Tabing issue in Combo box (12 replies)
  169. Solved: Worksheet change event to populate timestamp (3 replies)
  170. Finding Holidays Formula (3 replies)
  171. Solved: Loop Through cells and sum (5 replies)
  172. Solved: Extract Date (7 replies)
  173. Speeding up loop: deleting rows (7 replies)
  174. Solved: Date Picker default date (9 replies)
  175. Solved: Userform Show/Hide Problem (2 replies)
  176. Restricting access to a user to update a cell that is being updated by another user (3 replies)
  177. Screen Flickers with screenupdating set to false (4 replies)
  178. Sleeper: Compare two lists... and make changes (2 replies)
  179. Solved: Save Data Based on Vlookup (2 replies)
  180. Solved: Populating Combo Box With Values VBA (2 replies)
  181. Delete the row if cell contains null value else as it is ? (4 replies)
  182. Extracting data text and so on. (4 replies)
  183. show popup of all sheet tabs (8 replies)
  184. Populate combo box from selection of different combo box (11 replies)
  185. Solved: Lookup Intersection and copy column data into another sheet (6 replies)
  186. Solved: Need help "Run-Time error 91" (7 replies)
  187. Open to specific location of worksheet (6 replies)
  188. Excel Creating an Email Error (3 replies)
  189. Solved: Formula property compile error (8 replies)
  190. Solved: userform textbox format for currency (2 replies)
  191. Solved: Get state of checkboxes (3 replies)
  192. Blank or null string in drop-down (17 replies)
  193. Solved: variables carrying over from userform to Module (11 replies)
  194. find next and loop combined (4 replies)
  195. Solved: Return Sheet Index of Last Sheet (2 replies)
  196. Solved: reversed sequences in code (1 replies)
  197. Solved: Find does not do an exact match (2 replies)
  198. Sampling after Auto-filtering (9 replies)
  199. Solved: Finding the rows of a Selection (6 replies)
  200. count subfolders (2 replies)
  201. consolidating the difference in counts on hourly basis (6 replies)
  202. Protect a column ins workbook with macros (8 replies)
  203. Solved: Validation In Cell (14 replies)
  204. Solved: Delete a CSV Workbook from Another Workbook? (1 replies)
  205. A little (?) VBA help (8 replies)
  206. Copying Worksheet to another book with new name (2 replies)
  207. Solved: Converting Minutes Into Hours (1 replies)
  208. How can i speed this up? (3 replies)
  209. Hide comments programmatetically (1 replies)
  210. Solved: Hide row with a 1 on selection change (4 replies)
  211. Link userform check boxes with corresponding text boxes (4 replies)
  212. Solved: Selecting a hyperlink using Data Validation (8 replies)
  213. Solved: How to rename text file to date and time format (3 replies)
  214. Need Code to Check if .CSV file has finished writing (2 replies)
  215. Solved: Finding Specific Days In a Year (6 replies)
  216. Solved: deleting duplicate rows (3 replies)
  217. Solved: Create Multiple Sheets and Save As CSV (COMMA DILIMITED) FORMAT (8 replies)
  218. Regarding getting values for Multi Column LISTBOX (5 replies)
  219. Hyperlink to Chart or Range by Double-click Named range (1 replies)
  220. working on range (6 replies)
  221. Solved: Using comments to track changes (6 replies)
  222. Excel values to Website, web data extractn back to Xls. PLEASE Help!!! (1 replies)
  223. Linking excel with folders and show the content (5 replies)
  224. IF, Solver and Clearing Cells based on the IF (1 replies)
  225. Button w/drop down list (3 replies)
  226. [SOLVED:] TAT Calculate in office hours (3 replies)
  227. Copy/Past cell contents into a PDF Field (0 replies)
  228. Look For and delete (5 replies)
  229. Accessing Excel Spreadsheet via Sharepoint (0 replies)
  230. Excel CSV Read issue (5 replies)
  231. Compare Columns (3 replies)
  232. VBA Performance Query (3 replies)
  233. Cnverting Excel if into UDF. (4 replies)
  234. Solved: excel's IF function (3 replies)
  235. Solved: excels AND function (6 replies)
  236. Solved: shapes in a worksheet (2 replies)
  237. Solved: Simple question for CheckBox in sheet (1 replies)
  238. Make other cells invisible or locked programmatically (6 replies)
  239. Need a solver (3 replies)
  240. Save different filename based on multiple selection (3 replies)
  241. Insert Rows (8 replies)
  242. Match function for 2 columns (5 replies)
  243. Solved: excel to word for Labels (3 replies)
  244. Combine 2 similar worksheets (live document) (1 replies)
  245. Return cell address in messagebox (5 replies)
  246. Exclude a single xl file from macro (13 replies)
  247. Excel Macro that creates an Auto Macro (1 replies)
  248. Formula Referencing other cells (5 replies)
  249. Cant read txt file with Unicode symbols and store it to cell (2 replies)
  250. Solved: vba to make formulas work (3 replies)