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: Comparing Between 2 Workbooks and Inserting Missing Data (9 replies)
  2. Workbook Revision Update Onload? (1 replies)
  3. Autofill range in formula (4 replies)
  4. How to create a macro that opens a webpage and introduces text into a form ! (1 replies)
  5. Solved: Excel 2007 vba - Filter criteria problem (1 replies)
  6. extract html data (not in table) from website to excel (4 replies)
  7. Solved: Worksheet_Change vs Worksheet_BeforeDoubleClick (20 replies)
  8. Unzip only "text" files in a particular folder (0 replies)
  9. VBA code to read and update text file (18 replies)
  10. How to keep an excel file from being copied (3 replies)
  11. Solved: Look for Values in Range (6 replies)
  12. VBA code to "Save" for dialog box (0 replies)
  13. Solved: Step Backwards through range (2 replies)
  14. Macro Code Overwrites Previous Data (6 replies)
  15. Error in calling function (4 replies)
  16. Help needed with small issues in function (2 replies)
  17. Need help with macro to detect if cell value changes from current value (12 replies)
  18. Macro Help (7 replies)
  19. Pivot Table with both Compact & Classic Layouts (0 replies)
  20. Solved: Using find function (2 replies)
  21. A function to monitor changes on the data (1 replies)
  22. fuzzy search macro (3 replies)
  23. Image Viewer in VBA? (20 replies)
  24. Solved: GoTo in VBA (7 replies)
  25. Copy Picture generates Insufficient Resources error (2 replies)
  26. [SOLVED:] Replace all values in column with combobox selection (7 replies)
  27. [SOLVED:] Compare and insert missing Row Values Problem (3 replies)
  28. Solved: Image on Command Button (3 replies)
  29. Building third large table which consists of matched rows of two smaller tables (9 replies)
  30. Sleeper: Working with Oracle CLOB DataType (2 replies)
  31. Solved: Personal.xls vs xla (16 replies)
  32. Solved: Sum 'A' if there's any digit into string in 'B' (2 replies)
  33. Deleting Rows when using for each cell in loop (15 replies)
  34. Solved: Transferring the Userform Textbox Values To a Single Cell As Comment Indicator (2 replies)
  35. Right click (16 replies)
  36. Solved: VBA code to count blank cells in a dynamic range (2 replies)
  37. Insert New Rows Between Rows (2 replies)
  38. Worksheet_calculate runs based on every formula in sheet (3 replies)
  39. Solved: Build Dynamic String into Cell (2 replies)
  40. Filter by value in cell to the left. (0 replies)
  41. select last 20 cells (3 replies)
  42. thisWorkbook.Save going to TMP file (0 replies)
  43. User Defined Functions (2 replies)
  44. Excel 2007 Ribbon Problem... (5 replies)
  45. Solved: execute code on the lines with data in column "B" (6 replies)
  46. I need to create several random files (0 replies)
  47. Calendar problem (2 replies)
  48. Solved: VBA code launching problem (4 replies)
  49. Sleeper: Turning Off Error Alerts, of sorts (0 replies)
  50. Converting sheet based stopwatch to a userform (1 replies)
  51. Solved: Inserting more than one value into a single cell in an excel worksheet using VB. (10 replies)
  52. Conditional formatting (2 replies)
  53. Solved: I need help with InStr and searching a string for characters (3 replies)
  54. Solved: Macro inserting colon in time returning #value! in output column (2 replies)
  55. Solved: get a list of files from Directory order by the date modified (4 replies)
  56. paste text into chart (0 replies)
  57. data conversion (1 replies)
  58. conditional formatting with vba (2 replies)
  59. Solved: Progressbar (2 replies)
  60. Solved: How to: Function > Calculate sumof and divide (9 replies)
  61. Not work for upload file when the Window Language format - VBA (0 replies)
  62. Problem with formula (1 replies)
  63. issue reading from a .csv file (3 replies)
  64. Rename files at unzip! (15 replies)
  65. Solved: Copy worksheet to new workbook and more (5 replies)
  66. chart to be created in new sheet This macro creates chart in the worksheet same as da (4 replies)
  67. Vlookup text values (1 replies)
  68. Solved: Finding a Date in a Range (13 replies)
  69. Solved: Finding 2nd instance of a colored row seems to be much slower than it should be. (3 replies)
  70. Unable to solve using macro (4 replies)
  71. Windows 7 external file open (3 replies)
  72. code will not work when I change the name (3 replies)
  73. Need Code to Unhide Rows (5 replies)
  74. Solved: For Each and Pivot Table items? (1 replies)
  75. Solved: Adjust Macro Range To 2 Columns. (3 replies)
  76. Solved: Borders to all the used cells for all worksheets in a workbook (4 replies)
  77. String lookup to get month (0 replies)
  78. Transferring formula to vba (3 replies)
  79. Checklist automation from Outlook Senders (0 replies)
  80. macro for charting (5 replies)
  81. macro for charting (0 replies)
  82. Solved: Use VBA to create a named range (4 replies)
  83. Solved: Uploading a ComboBox from a Column in Excel (3 replies)
  84. Solved: Import XML Attribute Data To Worksheet (12 replies)
  85. Solved: Function to copy sheet to new file (10 replies)
  86. Solved: Allocations for CSV (19 replies)
  87. Complicated issue dealing with large file maintenance (1 replies)
  88. Solved: Global Search/Replace in Formulas (1 replies)
  89. Time Comparison (0 replies)
  90. Sleeper: Chart with user-defined range (1 replies)
  91. Slot Machine help in VBA (5 replies)
  92. Excel Mail Merge (3 replies)
  93. VBA code to click submit button in ie after checkbox is checked (1 replies)
  94. VBA code to use Other Programs with Excel (0 replies)
  95. Search for cells with comments and cocatatenate to Col(N) (0 replies)
  96. Why does this Previos Cell code some times error, most of the time not ? (0 replies)
  97. Solved: sort multi dimensional array (17 replies)
  98. Excel timeclock data vba help (5 replies)
  99. Excel Object Model and Embedded Word Document (2 replies)
  100. Set focus on check box value and not on caption (9 replies)
  101. VBA VLookup Function (6 replies)
  102. Need help with Hyperlink question (29 replies)
  103. Solved: Help with modifying error bars via VBA (3 replies)
  104. Help with cell formatting (2 replies)
  105. find and sort (0 replies)
  106. Formulas becoming values (3 replies)
  107. Solved: XLDs CFColorIndex and Chart sheets (13 replies)
  108. Solved: E-Mail from Address found in Worksheet (3 replies)
  109. Check the entire row and delete duplicate values (6 replies)
  110. Solved: vba ignore if statement in optiobutton (3 replies)
  111. Define String from Cell Cell Value (1 replies)
  112. Solved: Apply Data Validation to a Named Range (6 replies)
  113. VBA Command to Find Invoices designated as NotPrinted and place invoice number into c (4 replies)
  114. Copy Data from Certain Cells in Multiple Workbooks to One Master Worksheet (0 replies)
  115. VBA to stack pivot table data (2 replies)
  116. Reset Autofilter and Unselect specific numbers (0 replies)
  117. Excel 2003 Sortfields VBA runtime error 438 (3 replies)
  118. Selecting two sheets with workbook_beforeprint (0 replies)
  119. Multidimensional array problem (3 replies)
  120. Moving cells to another sheet (7 replies)
  121. Importing data into Excel based on Month (9 replies)
  122. Make highlighed cells Bold using VBA (4 replies)
  123. [SOLVED:] Export to csv (11 replies)
  124. Solved: linking with word (6 replies)
  125. VBA and vlookup (5 replies)
  126. data (0 replies)
  127. creat chart (0 replies)
  128. VBA Copy All Rows With Today's Date in a Cell (9 replies)
  129. Range("Cells(a,b),Cells(a,b)").Select is not work (2 replies)
  130. fill dates (1 replies)
  131. Help in VBA-Excel needed (4 replies)
  132. Solved: List file names and directory (1 replies)
  133. Solved: Append text to a cell with color (1 replies)
  134. select 3 columns (4 replies)
  135. filling date (1 replies)
  136. Selecting Range Names from a Table with Vlookup (6 replies)
  137. Solved: Resize a table (5 replies)
  138. SAVE EMAIL ATTACHMENT TO EXISTING WORK BOK (0 replies)
  139. Excel compare data (6 replies)
  140. Solved: highlighting matching cells (8 replies)
  141. Solved: Multi page form refreshing data (4 replies)
  142. Solved: Removing Defined Names in Worksheet (9 replies)
  143. Referencing certain cells to send emails out (6 replies)
  144. total characters in a cell (1 replies)
  145. Solved: Merge/join cells if same ID (2 replies)
  146. Split the files based on the Specific Column and update the Row Count (6 replies)
  147. Disable Arrow Keys (4 replies)
  148. Need help in Excel Macro (3 replies)
  149. Solved: VBA to do job of lookups (3 replies)
  150. Solved: Arrange Columns based on header values (11 replies)
  151. Question / Challenge - Lorenz Cipher Excel (2 replies)
  152. Automatic Create report using data from another sheets in excel (1 replies)
  153. Solved: Changing Range of sources for chart (3 replies)
  154. Excel VBA for Longtitude and Latitude Help Please!!! (2 replies)
  155. [SOLVED:] Paste & Delete Via VBA (11 replies)
  156. Solved: Formatting issues (2 replies)
  157. Solved: Use a function to access DB (5 replies)
  158. Problem Hiding Rows Based on CheckBox Event - Reaching Maximum Limit (1 replies)
  159. Solved: Dont email if no attachment exists (5 replies)
  160. Solved: Excel function: Sumproduct to match certain veriables with a date parameter (16 replies)
  161. Solved: Filling certain Cells (3 replies)
  162. Solved: Moving document to recycle bin (13 replies)
  163. Solved: CC another person on an email (3 replies)
  164. Solved: import record from text file & match with record in excel (4 replies)
  165. Extract ChildNodes' value from Website to Excel (0 replies)
  166. How to make a ComboBox select a specific value when i enter the workbook ? (5 replies)
  167. Solved: Selecting multiple cells (6 replies)
  168. Update macro application search to V2007 (1 replies)
  169. Hide and unhide rows by selecting a letter from a userform ComboBox (1 replies)
  170. Solved: Fax (2 replies)
  171. Naming the created worksheet? (1 replies)
  172. Format isn't working (2 replies)
  173. Scripting Dictionnary - key is already associated with an element of this collection (8 replies)
  174. Help with Search (1 replies)
  175. Solved: Restart macro after blank cell (10 replies)
  176. running macros (2 replies)
  177. Copy values from another workbook (5 replies)
  178. [SOLVED:] Web query help (3 replies)
  179. Please Help - Stupid Mistake (2 replies)
  180. Help with creating Excel VBA Password system (9 replies)
  181. Solved: Saving as xls (3 replies)
  182. Automatically sharing specific data to other workbooks (6 replies)
  183. Solved: Copy only part of items (2 replies)
  184. VBA / Formula approach (10 replies)
  185. Solved: .Find and activate a Visible Cell within a Filtered Range (1 replies)
  186. Excel printing continues paper printing (0 replies)
  187. Error while saving with reference to another workbook in footers (8 replies)
  188. Solved: Alert - When 3 conditions are met on the same row (5 replies)
  189. Solved: Save email in drafts (2 replies)
  190. Extract Substring, Ignore Substring for rest of txt, collect data while creating Data (2 replies)
  191. Send a fax (5 replies)
  192. Solved: Populating Combobox with Filtered Data (2 replies)
  193. Combining data with duplicate rows (0 replies)
  194. Excel & Word Mail Merge (1 replies)
  195. Solved: VBA to assign positions for outputs (5 replies)
  196. How to combine the text into one cell? (6 replies)
  197. How to add a Custom menu TAB for Seperate work book (11 replies)
  198. Urgent :How to FAST write large recordset in to a text file? (7 replies)
  199. Calculate only the given range. (3 replies)
  200. [SOLVED:] Advanced filter - vba method 'range' of object '_worksheet' failed (6 replies)
  201. Please help in auto data classification based on mapping (4 replies)
  202. staff / alternative (5 replies)
  203. Selecting: Just part of a string in a cell (1 replies)
  204. Inserting columns using VBA (1 replies)
  205. Solved: advisor name entered in one cell to auto populate their managers name in other cell (4 replies)
  206. Solved: Help to copy the formula (3 replies)
  207. Refresh button to update value of cell? (1 replies)
  208. A final push (2 replies)
  209. Solved: Speed up excel code (4 replies)
  210. compare mulitple columns and the status in another column based on the the criteria (2 replies)
  211. Solved: Copying Filtered Data (7 replies)
  212. Solved: help (5 replies)
  213. Criteria based macro (1 replies)
  214. Excel VBA Error Report (3 replies)
  215. Pivot Table Filter works in 2007, it doesn't in 2003 (0 replies)
  216. KeyPres, KeyUp, KeyDown - Debug.Print KeyCode (0 replies)
  217. Rewriting/Improving Formula (3 replies)
  218. Seeking assistance on automating some functions in Excel (3 replies)
  219. userform combox based on previous selection (23 replies)
  220. Excel 2010 and HPC Compute Cluster (0 replies)
  221. Solved: Running a sub based on the value in a cell (9 replies)
  222. Column Autochange? (18 replies)
  223. Solved: VBA Shortcut - Paste Values, Formats, Both (2 replies)
  224. Force users to classify documents before close (4 replies)
  225. Solved: linking userforms (24 replies)
  226. Invalid or Unqualified Reference (4 replies)
  227. Error 0: subscript out of order when populating an array (6 replies)
  228. VBA Excel .OCX Control (3 replies)
  229. Delete Specific Lines from Text File (10 replies)
  230. Outlokk MAcro to Maintain the text formating (0 replies)
  231. Compare two workbook and copy column content if match. (0 replies)
  232. VBA test (1 replies)
  233. Solved: Autofilter: using * in criteria for zip codes (3 replies)
  234. Skipping part of a code (13 replies)
  235. Solved: Autofilling select sells (6 replies)
  236. Solved: find number then +1 (16 replies)
  237. Macro to compare excel sheets and add missing data (0 replies)
  238. List all function, properties and classes (3 replies)
  239. Excel 2003 - Prevent Comments in protected locked cells (2 replies)
  240. Solved: Todays Date and Time (26 replies)
  241. Determining if 'End Mode' is on (4 replies)
  242. Solved: Button movement (0 replies)
  243. Trouble creating a macro for multiplying matrices (6 replies)
  244. Need Help Searching Folder/SubFolder, then Copying to different Folder (2 replies)
  245. text format cells be treated as text (1 replies)
  246. Trigger macro when user opening any excel file (3 replies)
  247. Row index and first three characters in VBA (0 replies)
  248. Collation of error. (9 replies)
  249. Macro for CheckBox (3 replies)
  250. Solved: Find cells that contain a string, extract it, then cocatenate to value in Col 15 (27 replies)