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. Button for every sheet one new email (0 replies)
  2. Option buttons inside frames within a userform disappear partially when scrolling (1 replies)
  3. [SOLVED:] [ASK] Excel VBA for multiple files in folder (4 replies)
  4. Filter data based on the date provided by the user (6 replies)
  5. Copying data from multiple worksheets to one summary sheet (0 replies)
  6. [SOLVED:] How to compare data in a spreadsheet and paste matched values in another sheet (6 replies)
  7. [SOLVED:] Vba code to transpose specific range of data from column A to another sheet (4 replies)
  8. [SOLVED:] Colour cell based on dropdown list (1 replies)
  9. Possible to create a link/macro to copy cell contents into an intranet page in IE? (0 replies)
  10. Userform to check 2 textboxes for duplicate & date check (2 replies)
  11. Need to transpose data from rows to columns (1 replies)
  12. Split Worksheet into separate workbooks (14 replies)
  13. Excel VBA - Hide cell values based on ComboBox selection (0 replies)
  14. If Not Like - Checking string for date format (5 replies)
  15. [SOLVED:] excel UF link to Accesd DB (3 replies)
  16. Assistance with a formula to return values based on time (3 replies)
  17. Conditional row formatting based on multiple nested IF/AND statements (1 replies)
  18. Combining Rows (4 replies)
  19. round to even calculation (4 replies)
  20. Combining All Worksheets of all Workbooks into one Workbook (2 replies)
  21. How to bold values that are less than the average? (0 replies)
  22. [SOLVED:] How do I automate color coding the highest performers on a chart? (7 replies)
  23. Creating user names & passwords to an excel workbook and restricting the view of data (1 replies)
  24. [SOLVED:] VBA msgBox executing before the previous line of code (0 replies)
  25. [SOLVED:] Consolidate a table with keeping 3 column criteria (4 replies)
  26. Run Macro when a character is entered (8 replies)
  27. [SOLVED:] VBA to match data in one file and copy data to an existing file (2 replies)
  28. [SOLVED:] UF Reflect Sheets & Future Sheets (2 replies)
  29. Sleeper: Exit/hide combobox when item in dropdownlist is chosen (1 replies)
  30. Automation help with the current code in VBA excel. (0 replies)
  31. HELP... How to copy paste tabs content to another excel in the same order of tabs (0 replies)
  32. [SOLVED:] search for the keywords and copy paste to another sheet (10 replies)
  33. Add new Row (table) (1 replies)
  34. Activate Combobox dropdown when cell selected, not when doubleclicking (3 replies)
  35. [SOLVED:] automatic variable names (2 replies)
  36. multiple comboboxes (0 replies)
  37. [SOLVED:] Excel CF help (4 replies)
  38. [SOLVED:] Import script help. (1 replies)
  39. [SOLVED:] Change value of a MS Word ActiveX Checkbox (10 replies)
  40. [SOLVED:] Problem while open file script (1 replies)
  41. Display VBA assigned values (2 replies)
  42. code sequence works manually but not as a macro? (21 replies)
  43. Macro to save book with diferent name each time ran (5 replies)
  44. VBA Code to Move row if criteria to tab within same Workbook (4 replies)
  45. Format user input from inputbox into a lap time (6 replies)
  46. [SLEEPER:] Transpose Script not copying one specific field (0 replies)
  47. Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2 (0 replies)
  48. Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2 (0 replies)
  49. Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2 (0 replies)
  50. Excel 2010 – VBA Userform - Vlookup Textbox1 and return value to textbox2 (0 replies)
  51. Writing a sub, using arrays, to join information on two worksheets using VBA (7 replies)
  52. [SOLVED:] Change SQL Query Syntax (2 replies)
  53. [SOLVED:] need help with combine files (2 replies)
  54. [SOLVED:] How to COmbine two files with this code need to modify (0 replies)
  55. [SOLVED:] problem with open file Run-time error 1004 (2 replies)
  56. VBA Copy cells paste +1 column (0 replies)
  57. [SOLVED:] Minor formatting issue: allow capturing a (.) full-stop as decimal (14 replies)
  58. [SOLVED:] need to open file if file exists then merge (0 replies)
  59. Subtotal and Label Specific Data Sets (1 replies)
  60. [SOLVED:] How to match two filenames? (0 replies)
  61. [SOLVED:] Select certain files with statement (combine files) (0 replies)
  62. [SOLVED:] Modify code a bit, (combine function) (3 replies)
  63. [SOLVED:] Creating Functions From Formula (7 replies)
  64. Copy Paste hide columns of Filtered data (0 replies)
  65. Object variable not set (2 replies)
  66. Counting files in a folder (22 replies)
  67. [SOLVED:] combine data from 2 workbooks with matching cells in different locations (19 replies)
  68. Using Record Set in loop (2 replies)
  69. Sendkeys not working - trying to copy dated data (0 replies)
  70. OCR by MODI via VBA Macro in Excel / Runtime Error -2147417848 (80010108) (7 replies)
  71. [SOLVED:] Sort current usded range (21 replies)
  72. fullscreen userform (4 replies)
  73. [SOLVED:] Timer please (24 replies)
  74. How to copy cells to same place but in another document? (2 replies)
  75. importing specific event log data into workbook (1 replies)
  76. [SOLVED:] AND and OR formula into an IF (2 replies)
  77. [SOLVED:] add/insert data validation cell to if column value to left is a number (2 replies)
  78. Function with FOR loop (3 replies)
  79. Macro to copy column from multiple files to paste to one file (9 replies)
  80. [SOLVED:] Sub-Procedure or Sub-Routine....?? (5 replies)
  81. Search No. & text list (0 replies)
  82. [SOLVED:] Ofsetting Cell by 1, 0 vba (3 replies)
  83. smart vlookup (1 replies)
  84. macro to remove numbers before first alphabet in a cell (18 replies)
  85. [SOLVED:] Emailing from Excdel only rows with data showing (2 replies)
  86. run time error 91 "object variable or with block variable not set (1 replies)
  87. using conbo boxes to populate data into text boxes (0 replies)
  88. [SOLVED:] Use one cell to create a variable number of rows on a different sheet (2 replies)
  89. [SOLVED:] Deleting all subsequent duplicates below first one in sorted list. (3 replies)
  90. [SOLVED:] Simple syntax problem (3 replies)
  91. [SOLVED:] Loop through active columns and save to file (1 replies)
  92. VBA excel access sharepoint slow connection (0 replies)
  93. [SOLVED:] Delete Blank Columns and Delete Blank Columns (2 replies)
  94. Sleeper: Storing and retreiving text from a separate workbook (1 replies)
  95. Excel VBA Code HELP - email active sheet plus 1 other (1 replies)
  96. [SOLVED:] how to loop through all used cells in just row 1 and alert? (11 replies)
  97. Data Scrape from IE (3 replies)
  98. values going below the ribbon (4 replies)
  99. Function help (2 replies)
  100. CategoryNames or SetSourceData on Excel VBA 2013 (0 replies)
  101. [SLEEPER:] Formula - show unique value based on two condition (0 replies)
  102. change the date column (1 replies)
  103. [SOLVED:] VBA help! copy and paste to database sheet (10 replies)
  104. Saving a value from a variable -- I'm missing something obvious! (9 replies)
  105. [SOLVED:] Linking several workbooks to a master workbook (12 replies)
  106. Hyperlinks for Combo from Sheet Tabs (1 replies)
  107. Reg; Excell cell count according to the cell values (1 replies)
  108. Excel table if update the row end of cell date cell should update accordingly (1 replies)
  109. How to update an excel cell/column date everytime a change is made to its row? (2 replies)
  110. Listbox using List of Hyperlinks to other sheets (2 replies)
  111. [SOLVED:] vba Linear Sort help (3 replies)
  112. [SOLVED:] Can't use Split correctly (4 replies)
  113. [SOLVED:] How to select just letters in the alert and also make a string (4 replies)
  114. Help with my code - I want to clear any formulas when pasting (1 replies)
  115. [SOLVED:] Transpose 3 Columns (variable rows numbers) to 3 Rows (4 replies)
  116. NEED VBA Macro (2 replies)
  117. doubleclick doesn't work (6 replies)
  118. [SOLVED:] Count formla for three criteria (1 replies)
  119. [SOLVED:] VlookUp not Working? (1 replies)
  120. [SOLVED:] Can you sort SpecialCells or other noncontiguous cells (17 replies)
  121. Beginner question (5 replies)
  122. Problems with nslookup function (0 replies)
  123. [SOLVED:] How to rename active workbook? (1 replies)
  124. Small Help in this Code (2 replies)
  125. VBA to Restrict certain usernames. (14 replies)
  126. [SOLVED:] VBA Function - Search Min Value by length (8 replies)
  127. [SOLVED:] VBA - Find Specific words from Column "A" and paste to column "H" (8 replies)
  128. I need a formula.. (5 replies)
  129. [SOLVED:] Remove the Index References table and continue to show the CF (3 replies)
  130. VBA - Combine two column value using Distance (1 replies)
  131. [SOLVED:] I need help for Conditional Formatting. (1 replies)
  132. [SOLVED:] Column "A", where the zero value where the column "B" must be delete in the Value (3 replies)
  133. Highlighting a specific marker in a line chart (2 replies)
  134. [SOLVED:] VB Code for EXCEL 2010 - PLEASE HELP!! (3 replies)
  135. [SOLVED:] Deleting rows where value in column B starts with specific letter (5 replies)
  136. [SOLVED:] COUNTIF(AND... Mulitple criteria (4 replies)
  137. Glossary of terms using excel vba (8 replies)
  138. Automate Vlookup in Excel spreadsheet (3 replies)
  139. Copying value from multiple workbook to one after every 60 mins (1 replies)
  140. [SOLVED:] Selecting the next sheet and copying the previous (5 replies)
  141. ADDIN doesn't show when opening existing spreadsheet (2 replies)
  142. [SOLVED:] Vba code in excel to move doc files from one folder to another. (4 replies)
  143. [SOLVED:] how to see the first cell in a row also copy to a new sheet (2 replies)
  144. Newbie Help with VBA I think (25 replies)
  145. Autosort vba problem (1 replies)
  146. [SOLVED:] Excel cells into publisher help (2 replies)
  147. Help with Userform (1 replies)
  148. [SOLVED:] Copying specific cells to a new sheets also give sheetname (7 replies)
  149. Drawing sample in Excel (2 replies)
  150. Code Efficiency (6 replies)
  151. [SOLVED:] Missing apostrophe (6 replies)
  152. Find a word in a cell and delete the rows which doesn't have the word (4 replies)
  153. [SOLVED:] Export column script (1 replies)
  154. Date Prior to Actual Date (1 replies)
  155. [SOLVED:] VBA Cell Formatting Copy (3 replies)
  156. Ranking using data from 2 colums (4 replies)
  157. Textbox and the standard module (1 replies)
  158. [SOLVED:] VBA code chages - pick two cell instead of 1 (2 replies)
  159. [SOLVED:] Modify code to search multi columns and return data (4 replies)
  160. Assistance With Simplifying getElementsByName Coding (1 replies)
  161. Vba open workbook and paste from another workbook (1 replies)
  162. Copy text in a column till last row based on adjacent column (1 replies)
  163. Vba open workbook and paste from another workbook (23 replies)
  164. [SOLVED:] Open a folder in Windows Explorer (2 replies)
  165. Running a .bat file from VBA (4 replies)
  166. How to populate the other cells, as soon as values are selected from combobox? (0 replies)
  167. [SOLVED:] Options List for Inputbox (4 replies)
  168. [SOLVED:] Normal Distribution - how to calculate E(X|X>Y) (1 replies)
  169. how to use conditional formatting in gantt chart (0 replies)
  170. Copy Multiple TextBoxes to Clipboard (14 replies)
  171. Saving a file with previous day date in specific location (4 replies)
  172. ADODB & Jet Engine VS Pure VBA - Performance (3 replies)
  173. [SOLVED:] Linear interpolation using VBA for empty cells in a row (9 replies)
  174. Help to create repeat macro until blank cell found (8 replies)
  175. [SOLVED:] Conditional formating if the cell is empty. (2 replies)
  176. [SOLVED:] Import from Access to Excel, auto select .mdb file from same folder path as Excel (6 replies)
  177. [SOLVED:] Have a Label/Command Button Run a Spin Button (cross posted) (6 replies)
  178. [SOLVED:] Help to modify VBA Code (8 replies)
  179. [SOLVED:] Selecting and sorting variable range (4 replies)
  180. Copying a cell, from one workbook and pasting in a another workbook... (5 replies)
  181. [SOLVED:] Parent vs Worksheet (3 replies)
  182. VBA DATE STAMP MODIFY (2 replies)
  183. [SOLVED:] need help in code enhancement (4 replies)
  184. VBA: Delete duplicate productid when it finds 3 different criterias (5 replies)
  185. Sort from A4 to lastrow (3 replies)
  186. [SOLVED:] Add items from column range A1:-> into a Combobox (2 replies)
  187. few datavalidated cells not working after after adding combobox. for INDIRECT formula (20 replies)
  188. Project VBA diplay Error94 (3 replies)
  189. [SOLVED:] Want to use a different icon for an excel file (2 replies)
  190. Need a little help with my (working) code regarding putting headers into comments (5 replies)
  191. [SOLVED:] Help (11 replies)
  192. Excel2013 Macro- Run-time error '438': Object doesn't support this property or method (2 replies)
  193. [SOLVED:] VBA Macro (16 replies)
  194. [SOLVED:] VBA to Insert Blank Row (4 replies)
  195. [SOLVED:] Print to last row, multipule columns. (3 replies)
  196. olObject (1 replies)
  197. VBA Code - Set up Button (Form Control) (3 replies)
  198. [SOLVED:] Change value of a MS Word ActiveX Checkbox (13 replies)
  199. Copy Matching Data to Email (0 replies)
  200. SEARCH FOR DUPLICATE VALUES ACROSS NUMEROUS WORKSHEETS (2 replies)
  201. Need help to write a code (3 replies)
  202. Launching Excel from MS-Access / Detecting Excel to prevent multiple instances (4 replies)
  203. [SOLVED:] How capture City and State values from one cell (with a delimeter character) (2 replies)
  204. [SOLVED:] Save E-mail Attachments (2 replies)
  205. [SOLVED:] Copy data from a file based on comparison between two different workbooks (33 replies)
  206. [SOLVED:] VBA - automation error the object invoked has disconnected (5 replies)
  207. Need help on how to get previous matching row data!! (0 replies)
  208. Listing the files from a compressed zipped folders (1 replies)
  209. VBA For Each Loop just prompting one input (6 replies)
  210. newly created sheet - assign module (2 replies)
  211. VBA: Delete dublicate rows based on 3 different columns (0 replies)
  212. [SOLVED:] Automatic Friday Week Ending Dates (2 replies)
  213. [SOLVED:] How do I add axis labels to bar chart bars? (1 replies)
  214. [SOLVED:] Using Hyperlink from Excel cell in an Email (6 replies)
  215. is there a way to add to a list object? (2 replies)
  216. Help with date format (3 replies)
  217. Time exceptions within excel (1 replies)
  218. [SOLVED:] Run-time error 424: Object required (10 replies)
  219. Display values in User Form (0 replies)
  220. Help creating a macro for color blind user? (4 replies)
  221. Filter 2 columns between 2 dates (0 replies)
  222. [SOLVED:] Complicated Reverse-order lookups (7 replies)
  223. Inserting a new row and copy the data. (1 replies)
  224. How to display the output in a same worksheet? (3 replies)
  225. Comparing 2 Lists and displaying all in New, Removed, Same (0 replies)
  226. [SOLVED:] Sending automatic emails (1 replies)
  227. SPLITING A COLUMN OF DATA CLASSIFIED BY 2 VARIABLES INTO A 2 VARIABLE MATRIX (4 replies)
  228. Looping IF (2 replies)
  229. VBA to obtain another workbook's worksheets into a drop down list (0 replies)
  230. [SOLVED:] How to paste a cell as special values from another sheet? (2 replies)
  231. VBA - Extract 3rd Column value from Listbox (4 replies)
  232. [SOLVED:] Is there a way to autofill macros? (3 replies)
  233. VBA PivotTables "Unable to get the PivotItems of the PivotField Class" (2 replies)
  234. [SOLVED:] How can I auto filter out "0:00" in excel 2010? (8 replies)
  235. Sharing a Workbook with VBA (1 replies)
  236. [SOLVED:] Concatenate a formatted number (2 replies)
  237. Help with Datepicker in Excel Form (1 replies)
  238. how to make a range of names into a variable (3 replies)
  239. [SOLVED:] problem with closing WB when copying data from on WB to another (1 replies)
  240. [SOLVED:] Copy data from one workbook into another with named rangs (1 replies)
  241. VB calculations not working (0 replies)
  242. Advanced Filtering of Large Spreadsheets (1 replies)
  243. Run-time error '9' Subscript out of range. (4 replies)
  244. Active X controls (2 replies)
  245. Add multiple filtered row data to ListBox (3 replies)
  246. [SOLVED:] Can't Get Find Method to Work (1 replies)
  247. [SOLVED:] Simple VBA calculation (15 replies)
  248. [SOLVED:] VBA to copy specific cells to specific columns in different workbook (5 replies)
  249. [SOLVED:] Modifying an existing time formula (10 replies)
  250. [SOLVED:] Team ranking not working (4 replies)