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. Text File Import w/ Variable File Name (1 replies)
  2. SFTP Error (9 replies)
  3. VBA Code De-bugging in 2010 excel (7 replies)
  4. [SLEEPER:] Filter pivot tables with one pivot table with multiple value selection (3 replies)
  5. Help with a search and copy funktion (3 replies)
  6. [SOLVED:] Beginner: Application.Caller for a shape (2 replies)
  7. [SOLVED:] I need help merging workbooks (1 worksheet in each) into a summary workbook. (10 replies)
  8. RegEx Newbie (3 replies)
  9. [SOLVED:] Importing share price data (open, high, low, close & volume) from website (5 replies)
  10. return a value into a vlookup cell (1 replies)
  11. [SOLVED:] Searching multiple columns and returns the values in excel vba (7 replies)
  12. Getting data from web (3 replies)
  13. [SOLVED:] Help to duplicate a range on one tab to another multiple times based on a cell value (4 replies)
  14. Carry text formatting between chart titles (1 replies)
  15. [SOLVED:] formulas business days (automatic list) (2 replies)
  16. [SOLVED:] FileSearch VBA error - please help! (13 replies)
  17. Hyperlinks in a body of a Task (2 replies)
  18. [SOLVED:] Return data not duplicated via formula? (7 replies)
  19. Calculate Average Handling Time, without a timer?? (10 replies)
  20. 2007 Menu Issue (1 replies)
  21. Need Help with Error Message (1 replies)
  22. Semi-Generic Bar charts (2 replies)
  23. Help big project due (6 replies)
  24. help with VBA to classify and highlight row based on value of cell (4 replies)
  25. help with VBA to classify and highlight row based on value of cell (1 replies)
  26. help with VBA to classify and highlight row based on value of cell (11 replies)
  27. Replace Cell Ref in Formula with Value (1 replies)
  28. [SOLVED:] Start Command Button from different sheet (2 replies)
  29. calculate 2 datetime and returning to days and hours (3 replies)
  30. Consolidation of 5 worksheets into a single master sheet (2 replies)
  31. VBA to N-DS (0 replies)
  32. Set Tab Order (4 replies)
  33. VBA code to list all folder names in excel (7 replies)
  34. Excel to Outlook help (1 replies)
  35. VBA code to identify folder based on folder name given in a excel sheet (2 replies)
  36. VBE I/O Errors, Out of Memory, and crashing of Excel due to duplicate VB code (3 replies)
  37. [SOLVED:] VBA MACRO CODE FOR GROUPING THE DATA BASED ON 2 HOURS TIME... (2 replies)
  38. VBA errors (9 replies)
  39. VBA code to sum cells based on text in a cell in the same row but different column (7 replies)
  40. [SOLVED:] Having problem with autofilter vba (10 replies)
  41. [SOLVED:] Countifs syntax (beginner question) (1 replies)
  42. [SOLVED:] How to show percentages from multiple cells in the caption for one.. userform button (2 replies)
  43. Use IF or a VBA to check multiple fields and display specific text in a cell? (1 replies)
  44. [SOLVED:] Reading text files without .txt extensions (3 replies)
  45. [SOLVED:] Turn first and last names around and remove middle initial (11 replies)
  46. [SOLVED:] Conditional formating using relative references (3 replies)
  47. Selected Sheet Range copy One after One! (2 replies)
  48. Excel Macro VBA capture dynamic column (3 replies)
  49. [SOLVED:] Countifs syntax and use, beginner question (4 replies)
  50. Get Word VBA macro variables passed back to parent Excel macro that called it (2 replies)
  51. [SOLVED:] Using Functions in VBA to bring a value to a variable without using the worksheet (10 replies)
  52. Code to identify the start of an event and then report that time - multiple columns (40 replies)
  53. VBA code to add a line immediately before a footer. (2 replies)
  54. [SOLVED:] If a cell contains #N/A then copy paste end of row (3 replies)
  55. ListView at runtime (3 replies)
  56. [SOLVED:] VBA MACRO CODE FOR getting sheet names at once in multiple sheets (6 replies)
  57. Change graph source data by vba (1 replies)
  58. Excel VBA to open a website and search for specific words in search box (22 replies)
  59. Find data from other workbook-Copy All column on row (2 replies)
  60. Working with dates, ranges, and arrays (5 replies)
  61. OLEObjects Inside UserForm (10 replies)
  62. [SOLVED:] Can't find out my mistake using a variable (3 replies)
  63. Excel form to save data in Access (4 replies)
  64. [SOLVED:] Excel data to Word with images (16 replies)
  65. Opening CSV files disables / uninstalls add-ins (7 replies)
  66. VBA code for extracting three specific number patterns (8 replies)
  67. Remove duplicates on three criteria (22 replies)
  68. Moving highlight scroll bar (8 replies)
  69. [SOLVED:] Help with For..Next Loop (4 replies)
  70. Hide rows based on results of a drop down box on another sheet. (4 replies)
  71. Excel Macro Code Crashing (10 replies)
  72. [SOLVED:] Some explanation requested on converting string to double. (3 replies)
  73. Automatic graph generation macro (5 replies)
  74. Copy/Paste Recolored Picture with VBA (1 replies)
  75. [SOLVED:] Suddenly can't do anything in VBA ?? "Access is denied" ?? (8 replies)
  76. Update workbook (5 replies)
  77. Extract Specific Text From Middle of a String (4 replies)
  78. [SOLVED:] Chage default program to open a filetype? (16 replies)
  79. [SOLVED:] Counting conditional format colours, column by column (5 replies)
  80. [SOLVED:] How to Extract Row reference from chart series (2 replies)
  81. [SOLVED:] VBA code for tracking tracking updates in a column (2 replies)
  82. [SOLVED:] Inspecting dates of a Policy period (14 replies)
  83. Convert PDF data to Excel (5 replies)
  84. [SOLVED:] Find, copy & paste (14 replies)
  85. Adapt Colorpicker to limit selection to a few chosen colours (2 replies)
  86. Game in excell that I found. Where is the code that makes this game work (3 replies)
  87. [SOLVED:] Calculator buttons repeat very slowly (3 replies)
  88. [SOLVED:] Macro not working for partial date format conversion (3 replies)
  89. Need help with inspecting elements from website (3 replies)
  90. Are these multiple range objects or multiple names (8 replies)
  91. Lookup multiple values and compare different scenarios to get a specific result (4 replies)
  92. Need help with four basic VBA functions (10 replies)
  93. Unhide Entire Rows based on numeric value in cell (1 replies)
  94. Code duration inconsistent (4 replies)
  95. [SOLVED:] Wildcards with Replace in VBA (2 replies)
  96. [SOLVED:] Counting specific figures based on pivot table data (17 replies)
  97. [SOLVED:] Ratio being force formatted into Time (2 replies)
  98. [SOLVED:] Small Delay when showing Form (9 replies)
  99. Input date into input box on website not working correctly (3 replies)
  100. Login into intenet website not recognizing password via VBA code from excel (1 replies)
  101. PowerPoint crashes while copypasting diagrams from Excel (0 replies)
  102. [SOLVED:] Headings in formulas (4 replies)
  103. file exists or not (15 replies)
  104. Latest file name in the folder path (1 replies)
  105. [SLEEPER:] Issues getting text into a text box on a website form (15 replies)
  106. [SOLVED:] How to use the AddComment method of the range object (4 replies)
  107. Export / Print all Charts in Workbook to PDF (3 replies)
  108. Possible to have a macro "Rewrite" another macro? (3 replies)
  109. [SOLVED:] What does it mean to click on a cell? (6 replies)
  110. macro to find modified date of file (1 replies)
  111. Need Macro to Copy and Ignore Duplicate (3 replies)
  112. [SOLVED:] Is this efficient? (4 replies)
  113. Excel functions (10 replies)
  114. 2013 Slicer Events (2 replies)
  115. [SOLVED:] Close workbook without save prompt? (3 replies)
  116. Copy cells from an open workbook to a closed workbook (1 replies)
  117. Help with code (3 replies)
  118. Macro for inserting new rows conditionally. (7 replies)
  119. Import Sharepoint list into Excel (0 replies)
  120. Setting a timeout for Excel workbook (10 replies)
  121. [SOLVED:] Lookup up formula (4 replies)
  122. Check If Files In A Folder Are Open Without Knowing Name/File Type (6 replies)
  123. Replace All fires WS_Change for every cell (27 replies)
  124. [SOLVED:] Calling custom class method through variable (6 replies)
  125. [SOLVED:] Formula Q: referencing first column number that meets specific criteria (6 replies)
  126. Sleeper: Create VBA Function from VBA Macro - Inverse of Matrix in Excel VBA (7 replies)
  127. To obtain the coordinates (2 replies)
  128. IE.navigate not working on VPN (2 replies)
  129. Copy and Paste if Value changes (7 replies)
  130. [SOLVED:] Rank/ Sequence of Repetition (1 replies)
  131. Problem with ProgressBar (15 replies)
  132. count numbers that are in two sets of numbers (3 replies)
  133. VBA / Excel / Formula / Examples (1 replies)
  134. Annual Time Sheet (including flexi/TOIL) - Enter Negative Time/hours (6 replies)
  135. Utilizing Stored procedure parameters in VBA (20 replies)
  136. VBA Help Needed with Dynamic Sum Formula (14 replies)
  137. [SOLVED:] FileSearch Macro error (11 replies)
  138. [SOLVED:] Excel Crashes when Saving workbook (14 replies)
  139. [SOLVED:] VBA MsgBox Width in WIN7 (9 replies)
  140. [SOLVED:] Delete duplicate rows Excel 2003 (3 replies)
  141. VBA Help please (Novice) (7 replies)
  142. [SOLVED:] De-Duplication & Merge with multiple criteria (4 replies)
  143. Help jump Columns (3 replies)
  144. One rate sheet - multiple customers/multiple rates based on the one sheet (1 replies)
  145. Finding duplicates and replacing. (3 replies)
  146. Complex Filtering & Copying With VBA (Need Help) (3 replies)
  147. EXCEL/Quickbooks HELP!!! (7 replies)
  148. [SOLVED:] Find and Match Formula (15 replies)
  149. Delete Powerpoint slide which contains zero values (3 replies)
  150. [SOLVED:] Userform doesn't open unless Excel is the active application (3 replies)
  151. [SOLVED:] Help with a msgbox :) (4 replies)
  152. Adding Item to Reference Library (5 replies)
  153. [SOLVED:] Calculate sub shift hours (22 replies)
  154. [SOLVED:] Help With Worksheet Change event (3 replies)
  155. [SOLVED:] Correct Row/Column Numbers with INDEX and MATCH (4 replies)
  156. [SOLVED:] Find every instance of a word, then find previous instance of another word (14 replies)
  157. [SOLVED:] Clearing contents of all worksheets in a excel workbook (3 replies)
  158. [SOLVED:] Help me improve some old code (13 replies)
  159. Help with VBA Events - some work and some don't (34 replies)
  160. Automatically Inserting Rows with Date, Each Worksheet (1 replies)
  161. [SOLVED:] Runtime Error 1004 on 2nd run (9 replies)
  162. [SOLVED:] Problem deleting a legendEntry (5 replies)
  163. [SLEEPER:] Help Require in VBA (16 replies)
  164. creating Parameters in Excel using VBA (13 replies)
  165. [SOLVED:] Code works in Macro, but not in Function (7 replies)
  166. Update workbook data from another workbook (2 replies)
  167. [SOLVED:] Worksheet not updating with data from VBA (4 replies)
  168. Searching information in different bases (7 replies)
  169. VBA Code - Novice Here, Sorry! (7 replies)
  170. [SOLVED:] Remove Text (2 replies)
  171. trouble selecting sheet (1 replies)
  172. Merge Single Worksheets from Different Files into One Workbook AND Replace Formulas (2 replies)
  173. Excel 2003, worksheet_change to insert current date when a cell is colored yellow (3 replies)
  174. Merged mulitple sheets of existing workbook into one sheet (1 replies)
  175. [SOLVED:] Need Help Removing quotes and double quotes from my Excel Spreadsheet (11 replies)
  176. multiple word files tables to excel vba (5 replies)
  177. remove an item from a combobox. (21 replies)
  178. I Can't change <SELECT> html tag using VBA (6 replies)
  179. [SLEEPER:] Rounding Goal Seek result (2 replies)
  180. Userform submitting a date in format "mmm-yy", but a small problem arises. (6 replies)
  181. [SOLVED:] When does a Chart object become a ChartObject object (8 replies)
  182. VBA combo boxes (6 replies)
  183. [SOLVED:] Trying to add variables into Worksheet statements and can't get the right syntax (6 replies)
  184. Runtime error copying value from one worksheet to another in same workbook (4 replies)
  185. Iterate values through calculation using VBA and record results (16 replies)
  186. [SOLVED:] Iterate values through cell using VBA and record result (3 replies)
  187. Issues getting data in PowerPivot from Access (3 replies)
  188. [SOLVED:] Download file, how do I know when the file is downloaded? (13 replies)
  189. How to send email from excel using VBA with Cell Range (Including Images) as Email Bo (3 replies)
  190. [SOLVED:] Writing and Reading the Same Set of Ranges (3 replies)
  191. Autofilter based on content in cells (6 replies)
  192. [SLEEPER:] Run-time error when using OraOLEDB.Oracle Provider (0 replies)
  193. [SOLVED:] ListView Run-time erro "13"; Type mismatch (9 replies)
  194. [SOLVED:] Put data from userform into specific place. (6 replies)
  195. [SOLVED:] Print a changing range based on date values (6 replies)
  196. How modal forms work (4 replies)
  197. Slow Import from Web (5 replies)
  198. [SOLVED:] Userform for Entering Data in Excel VBA (7 replies)
  199. Lookup column value and find value (7 replies)
  200. VBA Userform (for Entering Data) (3 replies)
  201. Automating the use of translation.babylon.com (5 replies)
  202. How to Avoid Formatting Cells When Protected? (7 replies)
  203. Multiple Column Listbox (with headers) = the bain of my existence (5 replies)
  204. How to add row into another worksheet based on multiple cell values? (10 replies)
  205. Printing an Selected Sheets (2 replies)
  206. Excel VBA to Unhide rows with a specific value in a Range (5 replies)
  207. How to compare text in 2 cells and highlight incorrect text (3 replies)
  208. [SOLVED:] Directly Copy A Range from One Sheet to Another (2 replies)
  209. [SOLVED:] macro button for copying excel data into multiple word docs (8 replies)
  210. [SOLVED:] Increase number every nth year (2 replies)
  211. [SOLVED:] Trying to find the next empty cell in a range Using With and Set method - Help (7 replies)
  212. Array for ActiveX Controls (7 replies)
  213. [SOLVED:] Case Senerio and Offset That Creates A Data Validation Box (4 replies)
  214. Compiling and Exporting Information (2 replies)
  215. automation error (3 replies)
  216. [SOLVED:] Hiding Cols With VBA (3 replies)
  217. [SOLVED:] Acceptable to use Goto (27 replies)
  218. [SOLVED:] Creating an Array from a Table with only one row in it (15 replies)
  219. Optimize a VBA loop (3 replies)
  220. [SLEEPER:] Change Decimal Separator (10 replies)
  221. String length mismatch (3 replies)
  222. [SOLVED:] Adding New Chart Series with Loop (3 replies)
  223. [SOLVED:] Date range (6 replies)
  224. Format search results in a Multicolumn Listbox With Headings (3 replies)
  225. [SOLVED:] Automatic Generate random unique time From 8 AM till 21 PM in range (8 replies)
  226. [SOLVED:] Kill Files that Begin With Something (7 replies)
  227. Sales Returns for FIFO (8 replies)
  228. Question regarding loops sum and average (2 replies)
  229. [SOLVED:] Increment Column Selection with InputBox (12 replies)
  230. Mathematical Excel Optimisation Challenge (production of units) (5 replies)
  231. [SOLVED:] VBA Scientific Format. Can I reduce a digit? (6 replies)
  232. [SLEEPER:] Runtime error 445, need help (3 replies)
  233. Excel record aggregation with VBA macro (2 replies)
  234. New to VBA Coding (3 replies)
  235. Merging Word Documents From VBA (4 replies)
  236. Trouble setting pivot page filter using VBA (3 replies)
  237. VBA Auto generate numbering (4 replies)
  238. [SOLVED:] Subscript out of Range (5 replies)
  239. SaveasUI - Save as .xls not XLSM (2 replies)
  240. Hidden worksheet codes not working (6 replies)
  241. Help in VBA (3 replies)
  242. [SOLVED:] Changing formatting by writing all cells to an array (25 replies)
  243. Importing data from Header and table in Word to Excel. (6 replies)
  244. Check whether numbers are sequential? (1 replies)
  245. [SOLVED:] Allow only choose 4 colors (2 replies)
  246. [SOLVED:] Parse Text And Read Into Cells (12 replies)
  247. [SOLVED:] Error: Overflow (8 replies)
  248. [SOLVED:] VBA Auto SAVE - need help! (5 replies)
  249. Loop through subfolders (1 replies)
  250. [SOLVED:] fill months following (3 replies)