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. Solved: Use VBA to create a named range (4 replies)
  2. Solved: Uploading a ComboBox from a Column in Excel (3 replies)
  3. Solved: Import XML Attribute Data To Worksheet (12 replies)
  4. Solved: Function to copy sheet to new file (10 replies)
  5. Solved: Allocations for CSV (19 replies)
  6. Complicated issue dealing with large file maintenance (1 replies)
  7. Solved: Global Search/Replace in Formulas (1 replies)
  8. Time Comparison (0 replies)
  9. Sleeper: Chart with user-defined range (1 replies)
  10. Slot Machine help in VBA (5 replies)
  11. Excel Mail Merge (3 replies)
  12. VBA code to click submit button in ie after checkbox is checked (1 replies)
  13. VBA code to use Other Programs with Excel (0 replies)
  14. Search for cells with comments and cocatatenate to Col(N) (0 replies)
  15. Why does this Previos Cell code some times error, most of the time not ? (0 replies)
  16. Solved: sort multi dimensional array (17 replies)
  17. Excel timeclock data vba help (5 replies)
  18. Excel Object Model and Embedded Word Document (2 replies)
  19. Set focus on check box value and not on caption (9 replies)
  20. VBA VLookup Function (6 replies)
  21. Need help with Hyperlink question (29 replies)
  22. Solved: Help with modifying error bars via VBA (3 replies)
  23. Help with cell formatting (2 replies)
  24. find and sort (0 replies)
  25. Formulas becoming values (3 replies)
  26. Solved: XLDs CFColorIndex and Chart sheets (13 replies)
  27. Solved: E-Mail from Address found in Worksheet (3 replies)
  28. Check the entire row and delete duplicate values (6 replies)
  29. Solved: vba ignore if statement in optiobutton (3 replies)
  30. Define String from Cell Cell Value (1 replies)
  31. Solved: Apply Data Validation to a Named Range (6 replies)
  32. VBA Command to Find Invoices designated as NotPrinted and place invoice number into c (4 replies)
  33. [SLEEPER:] Copy Data from Certain Cells in Multiple Workbooks to One Master Worksheet (0 replies)
  34. VBA to stack pivot table data (2 replies)
  35. Reset Autofilter and Unselect specific numbers (0 replies)
  36. Excel 2003 Sortfields VBA runtime error 438 (3 replies)
  37. [SLEEPER:] Selecting two sheets with workbook_beforeprint (0 replies)
  38. Multidimensional array problem (3 replies)
  39. Moving cells to another sheet (7 replies)
  40. Importing data into Excel based on Month (9 replies)
  41. Make highlighed cells Bold using VBA (4 replies)
  42. [SOLVED:] Export to csv (11 replies)
  43. Solved: linking with word (6 replies)
  44. VBA and vlookup (5 replies)
  45. data (0 replies)
  46. creat chart (0 replies)
  47. VBA Copy All Rows With Today's Date in a Cell (9 replies)
  48. Range("Cells(a,b),Cells(a,b)").Select is not work (2 replies)
  49. fill dates (1 replies)
  50. Help in VBA-Excel needed (4 replies)
  51. Solved: List file names and directory (1 replies)
  52. Solved: Append text to a cell with color (1 replies)
  53. select 3 columns (4 replies)
  54. filling date (1 replies)
  55. Selecting Range Names from a Table with Vlookup (6 replies)
  56. Solved: Resize a table (5 replies)
  57. [SLEEPER:] Save email attachment to existing workbook (0 replies)
  58. Excel compare data (6 replies)
  59. Solved: highlighting matching cells (8 replies)
  60. Solved: Multi page form refreshing data (4 replies)
  61. Solved: Removing Defined Names in Worksheet (9 replies)
  62. Referencing certain cells to send emails out (6 replies)
  63. total characters in a cell (1 replies)
  64. Solved: Merge/join cells if same ID (2 replies)
  65. Split the files based on the Specific Column and update the Row Count (6 replies)
  66. [SLEEPER:] Disable Arrow Keys (4 replies)
  67. Need help in Excel Macro (3 replies)
  68. Solved: VBA to do job of lookups (3 replies)
  69. Solved: Arrange Columns based on header values (11 replies)
  70. Question / Challenge - Lorenz Cipher Excel (2 replies)
  71. Automatic Create report using data from another sheets in excel (1 replies)
  72. Solved: Changing Range of sources for chart (3 replies)
  73. Excel VBA for Longtitude and Latitude Help Please!!! (2 replies)
  74. [SOLVED:] Paste & Delete Via VBA (11 replies)
  75. Solved: Formatting issues (2 replies)
  76. Solved: Use a function to access DB (5 replies)
  77. Problem Hiding Rows Based on CheckBox Event - Reaching Maximum Limit (1 replies)
  78. Solved: Dont email if no attachment exists (5 replies)
  79. Solved: Excel function: Sumproduct to match certain veriables with a date parameter (16 replies)
  80. Solved: Filling certain Cells (3 replies)
  81. Solved: Moving document to recycle bin (13 replies)
  82. Solved: CC another person on an email (3 replies)
  83. Solved: import record from text file & match with record in excel (4 replies)
  84. Extract ChildNodes' value from Website to Excel (0 replies)
  85. How to make a ComboBox select a specific value when i enter the workbook ? (5 replies)
  86. Solved: Selecting multiple cells (6 replies)
  87. Update macro application search to V2007 (1 replies)
  88. Hide and unhide rows by selecting a letter from a userform ComboBox (1 replies)
  89. Solved: Fax (2 replies)
  90. Naming the created worksheet? (1 replies)
  91. Format isn't working (2 replies)
  92. Scripting Dictionnary - key is already associated with an element of this collection (8 replies)
  93. Help with Search (1 replies)
  94. Solved: Restart macro after blank cell (10 replies)
  95. running macros (2 replies)
  96. Copy values from another workbook (5 replies)
  97. [SOLVED:] Web query help (3 replies)
  98. Please Help - Stupid Mistake (2 replies)
  99. Help with creating Excel VBA Password system (9 replies)
  100. Solved: Saving as xls (3 replies)
  101. Automatically sharing specific data to other workbooks (6 replies)
  102. Solved: Copy only part of items (2 replies)
  103. VBA / Formula approach (10 replies)
  104. Solved: .Find and activate a Visible Cell within a Filtered Range (1 replies)
  105. Excel printing continues paper printing (0 replies)
  106. Error while saving with reference to another workbook in footers (8 replies)
  107. Solved: Alert - When 3 conditions are met on the same row (5 replies)
  108. Solved: Save email in drafts (2 replies)
  109. Extract Substring, Ignore Substring for rest of txt, collect data while creating Data (2 replies)
  110. Send a fax (5 replies)
  111. Solved: Populating Combobox with Filtered Data (2 replies)
  112. Combining data with duplicate rows (0 replies)
  113. Excel & Word Mail Merge (1 replies)
  114. Solved: VBA to assign positions for outputs (5 replies)
  115. How to combine the text into one cell? (6 replies)
  116. How to add a Custom menu TAB for Seperate work book (11 replies)
  117. Urgent :How to FAST write large recordset in to a text file? (7 replies)
  118. Calculate only the given range. (3 replies)
  119. [SOLVED:] Advanced filter - vba method 'range' of object '_worksheet' failed (6 replies)
  120. Please help in auto data classification based on mapping (4 replies)
  121. staff / alternative (5 replies)
  122. Selecting: Just part of a string in a cell (1 replies)
  123. Inserting columns using VBA (1 replies)
  124. Solved: advisor name entered in one cell to auto populate their managers name in other cell (4 replies)
  125. Solved: Help to copy the formula (3 replies)
  126. Refresh button to update value of cell? (1 replies)
  127. A final push (2 replies)
  128. Solved: Speed up excel code (4 replies)
  129. compare mulitple columns and the status in another column based on the the criteria (2 replies)
  130. Solved: Copying Filtered Data (7 replies)
  131. Solved: help (5 replies)
  132. Criteria based macro (1 replies)
  133. Excel VBA Error Report (3 replies)
  134. Pivot Table Filter works in 2007, it doesn't in 2003 (0 replies)
  135. KeyPres, KeyUp, KeyDown - Debug.Print KeyCode (0 replies)
  136. Rewriting/Improving Formula (3 replies)
  137. Seeking assistance on automating some functions in Excel (3 replies)
  138. userform combox based on previous selection (23 replies)
  139. Excel 2010 and HPC Compute Cluster (0 replies)
  140. Solved: Running a sub based on the value in a cell (9 replies)
  141. [SOLVED:] Column Autochange? (18 replies)
  142. Solved: VBA Shortcut - Paste Values, Formats, Both (2 replies)
  143. Force users to classify documents before close (4 replies)
  144. Solved: linking userforms (24 replies)
  145. Invalid or Unqualified Reference (4 replies)
  146. Error 0: subscript out of order when populating an array (6 replies)
  147. VBA Excel .OCX Control (3 replies)
  148. Delete Specific Lines from Text File (10 replies)
  149. Outlokk MAcro to Maintain the text formating (0 replies)
  150. Compare two workbook and copy column content if match. (0 replies)
  151. VBA test (1 replies)
  152. Solved: Autofilter: using * in criteria for zip codes (3 replies)
  153. Skipping part of a code (13 replies)
  154. Solved: Autofilling select sells (6 replies)
  155. [SOLVED:] Find number then +1 (16 replies)
  156. Macro to compare excel sheets and add missing data (0 replies)
  157. List all function, properties and classes (3 replies)
  158. Excel 2003 - Prevent Comments in protected locked cells (2 replies)
  159. Solved: Todays Date and Time (26 replies)
  160. Determining if 'End Mode' is on (4 replies)
  161. Solved: Button movement (0 replies)
  162. Trouble creating a macro for multiplying matrices (6 replies)
  163. Need Help Searching Folder/SubFolder, then Copying to different Folder (2 replies)
  164. text format cells be treated as text (1 replies)
  165. Trigger macro when user opening any excel file (3 replies)
  166. Row index and first three characters in VBA (0 replies)
  167. Collation of error. (9 replies)
  168. Macro for CheckBox (3 replies)
  169. [SOLVED:] Find cells that contain a string, extract it, then cocatenate to value in Col 15 (27 replies)
  170. PDF Tracker Help! (1 replies)
  171. Solved: Re-arranging Data (2 replies)
  172. Parse data from Excel to IE using VBA (0 replies)
  173. Creating a detailed pivot from an existing master pivot (9 replies)
  174. Reply to Closed Thread! (0 replies)
  175. Delete Rows In A Sheet (8 replies)
  176. Needed help on copying the data from .csv file to another excel sheet (1 replies)
  177. [SLEEPER:] Protect created or saved file as encrypt documents with my user name only (1 replies)
  178. Solved: Befuddled (4 replies)
  179. Solved: Label and textbox on microsoft Forms 2.0 Frame (1 replies)
  180. Solved: Copy Xrows from WrkBk to New WrkBk (3 replies)
  181. File Browse InitialFileName not working on one Excel 2007 machine only (0 replies)
  182. Need help to create a series of covariance matrices in my worksheet (4 replies)
  183. Custom Get Open File Dialog (4 replies)
  184. Checking URL's (1 replies)
  185. updata e graph in ppt with excel data using vba in ppt (0 replies)
  186. UK Date Format not US (5 replies)
  187. Solved: Compare the active row, to row 10 (10 replies)
  188. Sleeper: Compare Column Value copy cell (0 replies)
  189. Solved: Copy Some cells from row 10 depending on which cells are selected in the active row. (2 replies)
  190. Solved: Clear Content of a4:q900 if=0 (2 replies)
  191. Returning Maximized WindowState with QueryClose_ (0 replies)
  192. Need Help using array(i) with user form label (5 replies)
  193. [SOLVED:] Criteria based counting (9 replies)
  194. Solved: Need Help Hiding Columns (2 replies)
  195. Quick Find of most recent date/time without having to sort. (2 replies)
  196. total value of a column in all the sheets to be consolidated in another worksheet (18 replies)
  197. Importing data from XL file has two sheets (0 replies)
  198. VBA Project - Registration process (6 replies)
  199. Solved: copy the first row on sheet to lastest blank row of another Sheet . (13 replies)
  200. Multiply (5 replies)
  201. Append rows to existing workbook in different folder and save in different location (0 replies)
  202. Macro to search for string in multiple worksheets and display results (1 replies)
  203. Delete rows based on dynamic data range (4 replies)
  204. [SOLVED:] Text in a Triangle Drawing Object (2 replies)
  205. Solved: problem with array loop (5 replies)
  206. Solved: Set Font Color of Cell(s) (1 replies)
  207. save combobox list to array (5 replies)
  208. Solved: Spreadsheet not updating when I open it daily? (3 replies)
  209. Solved: Delete Dash on each cell (5 replies)
  210. Solved: Vlookup in other workbooks fail (5 replies)
  211. delete rows that do not contain a defined set (8 replies)
  212. Solved: Insert Delete Rows Help. (2 replies)
  213. Problem on Merging (8 replies)
  214. Solved: Error Message when trying to highlight specific cell (4 replies)
  215. Import Active X fields in word doc to Excel (2 replies)
  216. Gathering data from one book for summary in another (2 replies)
  217. Solved: Merging Duplicate (4 replies)
  218. [SOLVED:] 65536 Row Problem (2 replies)
  219. Problem with UDF (8 replies)
  220. Code Optimisation: Name new sheets from a merge after the filename? (1 replies)
  221. Error 642 in Word Automation and Style that is not applied (2 replies)
  222. Anyone see the compile error? (1 replies)
  223. Search another spreadsheet to populate userform (3 replies)
  224. is there an opposite of 'selectedsheets' (5 replies)
  225. VBA Basics - automating the process of running commands down thousands of rows (6 replies)
  226. Solved: if its not broke... recreate it, using userforms (14 replies)
  227. Solved: How to comparing two columns (14 replies)
  228. compare few columns of data (0 replies)
  229. Excel Wont Open Full Screen (1 replies)
  230. Conditional Formatting in VBA (6 replies)
  231. Solved: VBA Coding Question (2 replies)
  232. How can I formate the date in a text box on a user form. (4 replies)
  233. Solved: what are these filter things called and how do you add them (5 replies)
  234. highlight Cell (2 replies)
  235. Updating my CSV File (4 replies)
  236. External Links issue (0 replies)
  237. Solved: Modifying code to select specific data (4 replies)
  238. [SOLVED:] For Loop help (2 replies)
  239. request formula (10 replies)
  240. Create multiple workbooks (2 replies)
  241. link two workbooks (5 replies)
  242. matching with a particular error (6 replies)
  243. Solved: only partly activity in Evene_Change (2 replies)
  244. TAB Order Workbook on KB (2 replies)
  245. Solved: Export a column to text file of certain name (7 replies)
  246. txt to xls excel macro help (1 replies)
  247. Solved: Error on VBA Code in 600000 Row (12 replies)
  248. Solved: Emailing by broker (12 replies)
  249. 255 Character Limit when copying worksheet (1 replies)
  250. Solved: macro doesn't work anymore (7 replies)