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. Consolidate Files From Mutiple Sub Folders into One Folder (1 replies)
  2. Access restriction (4 replies)
  3. formula error (2 replies)
  4. Adding a new line (2 replies)
  5. Excel data to Word Email Merge (1 replies)
  6. Display Pivot Table values in a userform (7 replies)
  7. split as per Map sheet (2 replies)
  8. Solved: Auto Size / Center View Screen (2 replies)
  9. Protect Cell and Range (3 replies)
  10. Reduce code and return empty if empty (6 replies)
  11. IF Range Select not working (6 replies)
  12. Just a Thank You ! (0 replies)
  13. Trouble with Vlookup in VBA (1 replies)
  14. VBA Code Help (6 replies)
  15. Advice on storage data into array (7 replies)
  16. Solved: Password Protecting - Command Buttons (4 replies)
  17. Can't Add Command Button (4 replies)
  18. User name pulled from Windows (3 replies)
  19. Help to convert formula into VBa code. (8 replies)
  20. Solved: Text to Columns with an extra bit (7 replies)
  21. Can anyone make this more efficient? (2 replies)
  22. [howto] Fetch data from txtfile and segregate it into corresponding field. (11 replies)
  23. VBA sort rows based on 1 of 2 values in a Field (1 replies)
  24. check box (1 replies)
  25. Solved: Unable to close excel (2 replies)
  26. Solved: search text in a worksheet then copy the whole column to master sheet (4 replies)
  27. backing up your macros? (3 replies)
  28. Solved: problem with column (7 replies)
  29. Autofill down based on two conditions (2 replies)
  30. Changing numberformat (2 replies)
  31. Solved: VBA not working (4 replies)
  32. Catenate Help (3 replies)
  33. Solved: Paste to latest empty cell (3 replies)
  34. insert missing columns (2 replies)
  35. Vlookup on a sheet with merged cells (1 replies)
  36. Paste columns, rows or cells (1 replies)
  37. Solved: check column and delete (9 replies)
  38. interactive chart (34 replies)
  39. Solved: Find the rows count in in a column where cell value >0 (4 replies)
  40. Above 65536 Data to be paste (2 replies)
  41. How to do the loop for find text in a particular column ? (1 replies)
  42. Solved: Add MS- and delete the 3 of first number (2 replies)
  43. Code doesn't work unless worksheet is active (2 replies)
  44. XY Scatter Plot from Pivot (3 replies)
  45. Adding a new criteria to a filter (3 replies)
  46. Is it possible to automatically removes spaces, commas, and delimiters using VBA? (2 replies)
  47. Filtered range - need to row numbers :/ (7 replies)
  48. Assign a value of a variable to a specific cell (2 replies)
  49. enter formulain cell through VBA (2 replies)
  50. Combine Multiple Worksheets Into 1 New Sheet (2 replies)
  51. (Un)Hide columns based on a list (3 replies)
  52. Solved: License information... not found (6 replies)
  53. Hi experts, how to import csv files into ms Excel using visual basic. (2 replies)
  54. Macro to copy the filter data from excel file and copy to other excel file? (6 replies)
  55. PDF tow Excel (7 replies)
  56. TFS Connection using Excel VBA (0 replies)
  57. Excel VBA Macro event Workbook_BeforeSave (0 replies)
  58. Securing a sheet with VBA in excel (7 replies)
  59. Solved: Application.Max problem (5 replies)
  60. Absolute beginner in need of help (14 replies)
  61. Solved: Fill Down Formula (2 replies)
  62. Solved: Filter Records before sending to userform (6 replies)
  63. Solved: SumUp Filtered Row (14 replies)
  64. Solved: Listbox - List values with one decimal place (4 replies)
  65. Copy Data to latest row of other sheet (1 replies)
  66. Return Value into userform. (4 replies)
  67. Solved: Update drop down view list (7 replies)
  68. Solved: updating data regularly between 2 workbooks (7 replies)
  69. Date entry validation (2 replies)
  70. How to save the excel as pdf? (5 replies)
  71. Solved: How to combine the rows? (1 replies)
  72. How to combine the rows? (2 replies)
  73. Import *.bas in same directory (3 replies)
  74. Solved: Data Query (8 replies)
  75. Excel Macro - click after login to a website (0 replies)
  76. Solved: add - when merge data on cell of column (7 replies)
  77. Search Cell for unique number from range (2 replies)
  78. Solved: Delete just 2 column (4 replies)
  79. Solved: Delete duplicate data in a Column (11 replies)
  80. Change value of the cell below based on criteria (1 replies)
  81. beta MOS exam (0 replies)
  82. Solved: Delete duplicate data useing VBA in Excel (6 replies)
  83. Deleting headers from the top of a file, then save (4 replies)
  84. Shortcut (2 replies)
  85. Solved: Create new tab based on list (6 replies)
  86. Solved: copy list from one sheet to another sheet (2 replies)
  87. Solved: Delete Sheet gone from tabs right click menu... (2 replies)
  88. [SOLVED:] Loop in for used many columns (1 replies)
  89. macro-copy pictures from comments in a column then paste to another column (5 replies)
  90. Conditional date copying (4 replies)
  91. What is the error? (3 replies)
  92. Open to specific Directory (9 replies)
  93. Addressing a ListObject Table dynamically (8 replies)
  94. Determine last used cell of a column and put formula 3 rows beneath it (2 replies)
  95. Search for all instances of a string then hide all other rows (6 replies)
  96. OpenAsTextStrem - only want a certain range (11 replies)
  97. Solved: Combined loop and find method between 2 sheets is too slow. (14 replies)
  98. Skip line loop (3 replies)
  99. Add thick box boarder around data after name change (0 replies)
  100. xl2003 and Win7 (1 replies)
  101. delete rows between 2 named ranges in excel 2003 (1 replies)
  102. Copy all date of column to another cell of another column (2 replies)
  103. VBA Code to move files from local folder to web folder (0 replies)
  104. Hide the Zero's in a new Window (2 replies)
  105. Delete if value is 0 (19 replies)
  106. Pricing Tool (8 replies)
  107. Force data entry in cell b1 if data exists in cell a1 (1 replies)
  108. Help required - alter VBA code (7 replies)
  109. 3D Lookup - using sumproduct / offset functions? (1 replies)
  110. Solved: Need to sum column totals for month. - My Code seems to be rounding cell values. (3 replies)
  111. Non Excel Application Status (1 replies)
  112. Macro to delete entire Row on Sheet 1 if values found on Sheet 2 matches (14 replies)
  113. Solved: Help Required - Checking formats of cells (2 replies)
  114. Solved: Passing Value back to userform (2 replies)
  115. Pivot table Items (1 replies)
  116. Copy details from the uploaded input file and paste in destination file (0 replies)
  117. GetValue work with UNC? (5 replies)
  118. Open each excel file and then close it. (1 replies)
  119. Differentiate between sources of results on cells (3 replies)
  120. FUNCTION to return values from a closed workbook (10 replies)
  121. Hidden Workbook - Now Cant Get Back! (2 replies)
  122. Print result in different worksheet with different number of rows (3 replies)
  123. Conditional Format question (10 replies)
  124. Color Row (2 replies)
  125. Using StringIndexOf to return two values (5 replies)
  126. Programmatically updating VBA macros in old spreadsheets (4 replies)
  127. Solved: Chart Series only use last 4 rows (2 replies)
  128. Solved: Merging a specific worksheet from multiple workbooks into one (21 replies)
  129. write the name of all excel file in a folder in an excel file (1 replies)
  130. Populate UF Listbox then send to Spreadsheet (4 replies)
  131. [SLEEPER:] Condition copy based on list from different sheet (12 replies)
  132. [SOLVED:] Restore Cell colores from saved information (5 replies)
  133. Solved: Unhide last row in auto filtered data (3 replies)
  134. Import CSV file data and export it in sql file (1 replies)
  135. deleting hidden rows or columns that have no data in a specified cell. (2 replies)
  136. Solved: Sum of sales in a Week (3 replies)
  137. DTPicker has gone AWOL ??? (4 replies)
  138. Solved: Formatting Text /Numbers in a Textbox of a Userform (3 replies)
  139. unload userform if greater than certain row (2 replies)
  140. how to store comments in a string? (3 replies)
  141. Assigning Autofilter values to a variable (4 replies)
  142. Solved: Illusive Macro (26 replies)
  143. Cell Identification (9 replies)
  144. Display text on cell selection (7 replies)
  145. Compare the columns in two files and results in a separate column (2 replies)
  146. Email with Glitches (2 replies)
  147. Solved: Correct File Selected (2 replies)
  148. Solved: New to VBA - How do I open WORD? (3 replies)
  149. User form "X" button to call Exit button (2 replies)
  150. Help with a simple Macro (3 replies)
  151. Solved: Playing Embedded Wav File (4 replies)
  152. Solved: Need the Root Directory of Thisworkbook (3 replies)
  153. save/paste column (3 replies)
  154. Solved: events problems (2 replies)
  155. Routine cycling data after automatic database sorting (25 replies)
  156. Solved: empty cells not allowed (6 replies)
  157. Help required: segregation of data (4 replies)
  158. Vlookup using VBA (3 replies)
  159. Removing vbcrlf with a macro (1 replies)
  160. VBA code to change font for email (2 replies)
  161. how to pick last -1 value of the column (1 replies)
  162. Solved: Named Ranges (2 replies)
  163. Select and activate ComboBox entry by macro code (3 replies)
  164. count no. of matching data in two excel (4 replies)
  165. VBA code giving error on some system (12 replies)
  166. Excel Vba Code (1 replies)
  167. Delete duplicate merged rows. (8 replies)
  168. reference named range (2 replies)
  169. VBA Excel Copy cells within one sheet (3 replies)
  170. Copy one excel file into another one row at a time (13 replies)
  171. Rectification of VBA script (5 replies)
  172. Solved: macro to import data from text file to excel worksheet (5 replies)
  173. macro problem please help (1 replies)
  174. vlookup (1 replies)
  175. [SLEEPER:] Run time error #13 while macro runs (2 replies)
  176. Get page count of pdf files (11 replies)
  177. Solved: Delete only today comment? (5 replies)
  178. SaveAs on 2 Cell Based (Path) (2 replies)
  179. Solved: Naming inserted pictures (3 replies)
  180. Solved: PrintArea and Pagebreak woes (8 replies)
  181. Import closed workbook - there are lots of methods but which is best? (15 replies)
  182. Create email with filtered data (5 replies)
  183. Problem programming routine for conditional copy/paste (3 replies)
  184. Manipulating Excel cell comments in VBA and with DB Data (2 replies)
  185. Solved: Help Required - Audit Trials using VBA (5 replies)
  186. Tab Order (2 replies)
  187. Solved: Inserting a Specific Date (2 replies)
  188. List ALL Formulas & Conditional Formatting in a WorkBook (10 replies)
  189. Macro to import/export data (10 replies)
  190. Solved: Copy Worksheets Based on "View" (14 replies)
  191. Sort columns based on named range (8 replies)
  192. Sleeper: Conditional VBA solution for moving data as per diffrenet cell value (4 replies)
  193. Solved: Returning a value into a textbox without Decimal Places Shown (4 replies)
  194. Count no. of item copied. (2 replies)
  195. Solved: How to have function run on both tabs (3 replies)
  196. =today(),now() (1 replies)
  197. Recquired Conditional VBA solution for moving data as per diffrenet cell value (1 replies)
  198. Macro Menu (7 replies)
  199. Inside ListBox Sorting Problem.. (2 replies)
  200. Restrict two macro run at same time (3 replies)
  201. filter, select and mail search results (0 replies)
  202. lookup or match (4 replies)
  203. Solved: Action code 2 only in cells (4 replies)
  204. Multiple Sheet Consolidator into one MasterSheet (6 replies)
  205. Need help with VBA code for hiding across multiple ranges (5 replies)
  206. Solved: VBA code for removing blank cells in a list (17 replies)
  207. Solved: Syntax Rectification Required (17 replies)
  208. "Freeze" some rows with highlighting (2 replies)
  209. Top 20 (2 replies)
  210. [SOLVED:] Regular Expression Replace (13 replies)
  211. Solved: Text to Columns or something similar (2 replies)
  212. Help Me!!! (1 replies)
  213. Userform Dynamic TextBoxes/Labels/Checkboxes and SQL Insert (1 replies)
  214. Add new items to list (5 replies)
  215. Initialize Multiple Textboxes (16 replies)
  216. Solved: Need to extract a few items from 250 XML Files in a Tree View, to a Spread Sheet (4 replies)
  217. Solved: IsNull Function Not Functioning (4 replies)
  218. Solved: Reference a Range in a different Worksheet (10 replies)
  219. Solved: Simpliest Way to Reconcile Checkbook (8 replies)
  220. Delete blank row after words and print in pdf (1 replies)
  221. Variable question (5 replies)
  222. Delete the last row that was filled (0 replies)
  223. Solved: Populate Combo box with shortened list (4 replies)
  224. Solved: Creation of Pivot Tables has errors ): (2 replies)
  225. Solved: Dynamic Drop Down List Freezing (4 replies)
  226. Solved: sumproduct question 2 (4 replies)
  227. Solved: Instructions Following a Called Script (5 replies)
  228. Solved: VB to keep all border (6 replies)
  229. Solved: Painting cells meeting conditions VBA (2 replies)
  230. error code, run time error '424 (4 replies)
  231. Solved: Exclude Sheet names from list (5 replies)
  232. Solved: sumproduct question (2 replies)
  233. Automating IE to get data from a website (5 replies)
  234. password protection difference (5 replies)
  235. Delete all hyperlinks and the associated sheets (6 replies)
  236. Hyperlink to folder (2 replies)
  237. running some macros automatically (7 replies)
  238. Solved: Hyperlink to folder (5 replies)
  239. Solved: unable to get the transpose property (2 replies)
  240. Worksheet_Change and RTD Link (4 replies)
  241. Summary (4 replies)
  242. highlight activecell in combo box (2 replies)
  243. Multiple Row Totals Based On Pivot Table (0 replies)
  244. Move data from world to excel (5 replies)
  245. Mark cell as complete (15 replies)
  246. index match example (0 replies)
  247. Return Value from Dialog (6 replies)
  248. append text file (1 replies)
  249. Solved: Phantom Pictures/Images (4 replies)
  250. Link Excel cell text to autocad text by VBA (0 replies)