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. Copy master sheet into multiple workworks from remote location (7 replies)
  2. how to loop between two dates which moves every hour. (3 replies)
  3. Solved: Deleting "0%" from Pie Charts (5 replies)
  4. [SLEEPER:] Delete all macros/all VBA and save as xls/xlsx (6 replies)
  5. how to find the last specified cell row in VBA (3 replies)
  6. Solved: Protect cells on sheet to last row without protecting sheet (1 replies)
  7. Excel VBA Form Help (2 replies)
  8. Solved: Finding the file name (13 replies)
  9. Rounding off numbers. (3 replies)
  10. EXCEL VBA code for assigning auto id (0 replies)
  11. Solved: Commandbutton.onAction (11 replies)
  12. Hyperlinking multiple cells based on another cell's contents (12 replies)
  13. Any 'gotchas' here? (3 replies)
  14. VBA Code Help (3 replies)
  15. Solved: Change file path name (6 replies)
  16. Solved: Help with Array (2 replies)
  17. Solved: VBA help required (2 replies)
  18. How to move from one sheet to otherby condition? (11 replies)
  19. how to search,compare and copy between sheets? (1 replies)
  20. Excel to search outlook global address list. (1 replies)
  21. Weekday function error (1 replies)
  22. Solved: Mail problem (6 replies)
  23. Solved: Automated pivot table will not handle large data. (3 replies)
  24. Solved: COPY CHARACTER FROM A CELL (10 replies)
  25. Solved: Best method for passing a variable from one code to another code (11 replies)
  26. How to read own filename (6 replies)
  27. Solved: Update multiple sheet (4 replies)
  28. ADODB update stops working with a tired database (1 replies)
  29. Copy pivot data in every sheets and save as to a new file (0 replies)
  30. or formula (1 replies)
  31. Replace a sheet in all the files in a folder (2 replies)
  32. Solved: Find Position and Count instances of a character in a string (2 replies)
  33. Help to Minimize VBA to be based in list range (2 replies)
  34. Solved: Transfer Results of Conditional Formatting in one cell to another (3 replies)
  35. Webquery (1 replies)
  36. Run VBA Code of diffrent sheet Automaticly (7 replies)
  37. Solved: Cut and Paste Value to matching Column (6 replies)
  38. Dynamic Range Help (17 replies)
  39. IE submit - nearly working (1 replies)
  40. Can I increase the speed up without change the code? (6 replies)
  41. number error (4 replies)
  42. Mailing with Excell vbscript help (10 replies)
  43. Solved: Progress bar till the macro is done (4 replies)
  44. Creating Summary from 2 files (1 replies)
  45. Defining dynamic ranges to work across multiple workbooks (9 replies)
  46. Replace all comments (2 replies)
  47. Populating Combobox (10 replies)
  48. Dynamic range that change variables (16 replies)
  49. Save as with Variable file location (4 replies)
  50. Insert Worksheet (2 replies)
  51. Store and modify column letter in a variable (3 replies)
  52. Change Excel Link Using VBA (4 replies)
  53. Not sure where to put this - VB login form (1 replies)
  54. VBA project not allowing existing excel sessions to open. (1 replies)
  55. Solved: Copy to another sheet problem . (4 replies)
  56. Using Pivot Tables in Excel to show Qualifications over time (3 replies)
  57. Excel to Word table edit - is it possible using VBA? (3 replies)
  58. problem when downloading xlsx file. (2 replies)
  59. vba to automatically update data and graphs (2 replies)
  60. VBA to Save and close Multiple Notepads (0 replies)
  61. Compare rows with first row and copy the matching records in another sheet. (7 replies)
  62. Compile error in hidden module (11 replies)
  63. Custom Document Properties help (1 replies)
  64. How to update files info [File listed in range with full path] (2 replies)
  65. Date within date range (19 replies)
  66. export file as *.xlsb with open password protect (1 replies)
  67. Appending to Workbook Name (12 replies)
  68. Solved: Converting Numbers (2 replies)
  69. User Form to Update data in Another workbook (1 replies)
  70. Solved: Pass Multiple Values from A Textbox (6 replies)
  71. Garbage data is copying to other sheets column? (4 replies)
  72. restore external links to excel pivottables (8 replies)
  73. average based on criteria (7 replies)
  74. Solved: Send an outlook email by reading from cell values (7 replies)
  75. Uninstall Excel Utilities (8 replies)
  76. [SLEEPER:] Excel Hide/Unhide Sheets based on cell value (5 replies)
  77. Solved: Color coding rows by market value (3 replies)
  78. Solved: Looking up matching cells (5 replies)
  79. [SOLVED:] Count unique values based on multiple criteria (8 replies)
  80. Can't Get macro to run in Excel 2010 (1 replies)
  81. paste range in powerpoint (1 replies)
  82. Sleeper: Variable Range Issue (4 replies)
  83. Trouble making a dropdown work (1 replies)
  84. Solved: back to sheet (2 replies)
  85. Solved: More than 7 Nested IF's (8 replies)
  86. Navigate to Sheet name from cell Value (6 replies)
  87. Solved: Help required : syntax correction (3 replies)
  88. How to create macro which will move data from one worksheet to other worksheet? (1 replies)
  89. Solved: Find text in a column then move the row to left (4 replies)
  90. How to auto populate an excel spreadsheet with data from another spreadsheet? (20 replies)
  91. Solved: XL 2003/Win XP - VBA File Browser -How may I free up Folder access after running code (1 replies)
  92. Concatenate multiple cells to each cell (5 replies)
  93. Is it possible to copy values from a worksheet to another worksheet using vba? (9 replies)
  94. Raise event to unknown object. (3 replies)
  95. Solved: Mergin two bits of code to format cell (2 replies)
  96. Consolidate Files From Mutiple Sub Folders into One Folder (1 replies)
  97. Access restriction (4 replies)
  98. formula error (2 replies)
  99. Adding a new line (2 replies)
  100. Excel data to Word Email Merge (1 replies)
  101. Display Pivot Table values in a userform (7 replies)
  102. split as per Map sheet (2 replies)
  103. Solved: Auto Size / Center View Screen (2 replies)
  104. Protect Cell and Range (3 replies)
  105. Reduce code and return empty if empty (6 replies)
  106. IF Range Select not working (6 replies)
  107. Just a Thank You ! (0 replies)
  108. Trouble with Vlookup in VBA (1 replies)
  109. VBA Code Help (6 replies)
  110. Advice on storage data into array (7 replies)
  111. Solved: Password Protecting - Command Buttons (4 replies)
  112. Can't Add Command Button (4 replies)
  113. User name pulled from Windows (3 replies)
  114. Help to convert formula into VBa code. (8 replies)
  115. Solved: Text to Columns with an extra bit (7 replies)
  116. Can anyone make this more efficient? (2 replies)
  117. [howto] Fetch data from txtfile and segregate it into corresponding field. (11 replies)
  118. VBA sort rows based on 1 of 2 values in a Field (1 replies)
  119. check box (1 replies)
  120. Solved: Unable to close excel (2 replies)
  121. Solved: search text in a worksheet then copy the whole column to master sheet (4 replies)
  122. backing up your macros? (3 replies)
  123. Solved: problem with column (7 replies)
  124. Autofill down based on two conditions (2 replies)
  125. Changing numberformat (2 replies)
  126. Solved: VBA not working (4 replies)
  127. Catenate Help (3 replies)
  128. Solved: Paste to latest empty cell (3 replies)
  129. insert missing columns (2 replies)
  130. Vlookup on a sheet with merged cells (1 replies)
  131. Paste columns, rows or cells (1 replies)
  132. Solved: check column and delete (9 replies)
  133. interactive chart (34 replies)
  134. Solved: Find the rows count in in a column where cell value >0 (4 replies)
  135. Above 65536 Data to be paste (2 replies)
  136. How to do the loop for find text in a particular column ? (1 replies)
  137. Solved: Add MS- and delete the 3 of first number (2 replies)
  138. Code doesn't work unless worksheet is active (2 replies)
  139. XY Scatter Plot from Pivot (3 replies)
  140. Adding a new criteria to a filter (3 replies)
  141. Is it possible to automatically removes spaces, commas, and delimiters using VBA? (2 replies)
  142. Filtered range - need to row numbers :/ (7 replies)
  143. Assign a value of a variable to a specific cell (2 replies)
  144. enter formulain cell through VBA (2 replies)
  145. Combine Multiple Worksheets Into 1 New Sheet (2 replies)
  146. (Un)Hide columns based on a list (3 replies)
  147. Solved: License information... not found (6 replies)
  148. Hi experts, how to import csv files into ms Excel using visual basic. (2 replies)
  149. Macro to copy the filter data from excel file and copy to other excel file? (6 replies)
  150. PDF tow Excel (7 replies)
  151. TFS Connection using Excel VBA (0 replies)
  152. Excel VBA Macro event Workbook_BeforeSave (0 replies)
  153. Securing a sheet with VBA in excel (7 replies)
  154. Solved: Application.Max problem (5 replies)
  155. Absolute beginner in need of help (14 replies)
  156. Solved: Fill Down Formula (2 replies)
  157. Solved: Filter Records before sending to userform (6 replies)
  158. Solved: SumUp Filtered Row (14 replies)
  159. Solved: Listbox - List values with one decimal place (4 replies)
  160. Copy Data to latest row of other sheet (1 replies)
  161. Return Value into userform. (4 replies)
  162. Solved: Update drop down view list (7 replies)
  163. Solved: updating data regularly between 2 workbooks (7 replies)
  164. Date entry validation (2 replies)
  165. How to save the excel as pdf? (5 replies)
  166. Solved: How to combine the rows? (1 replies)
  167. How to combine the rows? (2 replies)
  168. Import *.bas in same directory (3 replies)
  169. Solved: Data Query (8 replies)
  170. Excel Macro - click after login to a website (0 replies)
  171. Solved: add - when merge data on cell of column (7 replies)
  172. Search Cell for unique number from range (2 replies)
  173. Solved: Delete just 2 column (4 replies)
  174. Solved: Delete duplicate data in a Column (11 replies)
  175. Change value of the cell below based on criteria (1 replies)
  176. beta MOS exam (0 replies)
  177. [SOLVED:] Delete duplicate data useing VBA in Excel (6 replies)
  178. Deleting headers from the top of a file, then save (4 replies)
  179. Shortcut (2 replies)
  180. Solved: Create new tab based on list (6 replies)
  181. Solved: copy list from one sheet to another sheet (2 replies)
  182. Solved: Delete Sheet gone from tabs right click menu... (2 replies)
  183. [SOLVED:] Loop in for used many columns (1 replies)
  184. macro-copy pictures from comments in a column then paste to another column (5 replies)
  185. Conditional date copying (4 replies)
  186. What is the error? (3 replies)
  187. Open to specific Directory (9 replies)
  188. Addressing a ListObject Table dynamically (8 replies)
  189. Determine last used cell of a column and put formula 3 rows beneath it (2 replies)
  190. Search for all instances of a string then hide all other rows (6 replies)
  191. OpenAsTextStrem - only want a certain range (11 replies)
  192. Solved: Combined loop and find method between 2 sheets is too slow. (14 replies)
  193. Skip line loop (3 replies)
  194. Add thick box boarder around data after name change (0 replies)
  195. xl2003 and Win7 (1 replies)
  196. delete rows between 2 named ranges in excel 2003 (1 replies)
  197. Copy all date of column to another cell of another column (2 replies)
  198. VBA Code to move files from local folder to web folder (0 replies)
  199. [SLEEPER:] Hide the Zero's in a new Window (2 replies)
  200. Delete if value is 0 (19 replies)
  201. Pricing Tool (8 replies)
  202. Force data entry in cell b1 if data exists in cell a1 (1 replies)
  203. Help required - alter VBA code (7 replies)
  204. 3D Lookup - using sumproduct / offset functions? (1 replies)
  205. Solved: Need to sum column totals for month. - My Code seems to be rounding cell values. (3 replies)
  206. Non Excel Application Status (1 replies)
  207. Macro to delete entire Row on Sheet 1 if values found on Sheet 2 matches (14 replies)
  208. Solved: Help Required - Checking formats of cells (2 replies)
  209. Solved: Passing Value back to userform (2 replies)
  210. Pivot table Items (1 replies)
  211. Copy details from the uploaded input file and paste in destination file (0 replies)
  212. GetValue work with UNC? (5 replies)
  213. Open each excel file and then close it. (1 replies)
  214. Differentiate between sources of results on cells (3 replies)
  215. FUNCTION to return values from a closed workbook (10 replies)
  216. Hidden Workbook - Now Cant Get Back! (2 replies)
  217. Print result in different worksheet with different number of rows (3 replies)
  218. Conditional Format question (10 replies)
  219. Color Row (2 replies)
  220. Using StringIndexOf to return two values (5 replies)
  221. Programmatically updating VBA macros in old spreadsheets (4 replies)
  222. Solved: Chart Series only use last 4 rows (2 replies)
  223. Solved: Merging a specific worksheet from multiple workbooks into one (21 replies)
  224. write the name of all excel file in a folder in an excel file (1 replies)
  225. Populate UF Listbox then send to Spreadsheet (4 replies)
  226. [SLEEPER:] Condition copy based on list from different sheet (12 replies)
  227. [SOLVED:] Restore Cell colores from saved information (5 replies)
  228. Solved: Unhide last row in auto filtered data (3 replies)
  229. Import CSV file data and export it in sql file (1 replies)
  230. deleting hidden rows or columns that have no data in a specified cell. (2 replies)
  231. Solved: Sum of sales in a Week (3 replies)
  232. DTPicker has gone AWOL ??? (4 replies)
  233. Solved: Formatting Text /Numbers in a Textbox of a Userform (3 replies)
  234. unload userform if greater than certain row (2 replies)
  235. how to store comments in a string? (3 replies)
  236. Assigning Autofilter values to a variable (4 replies)
  237. Solved: Illusive Macro (26 replies)
  238. Cell Identification (9 replies)
  239. Display text on cell selection (7 replies)
  240. Compare the columns in two files and results in a separate column (2 replies)
  241. Email with Glitches (2 replies)
  242. Solved: Correct File Selected (2 replies)
  243. Solved: New to VBA - How do I open WORD? (3 replies)
  244. User form "X" button to call Exit button (2 replies)
  245. Help with a simple Macro (3 replies)
  246. Solved: Playing Embedded Wav File (4 replies)
  247. Solved: Need the Root Directory of Thisworkbook (3 replies)
  248. save/paste column (3 replies)
  249. Solved: events problems (2 replies)
  250. Routine cycling data after automatic database sorting (25 replies)