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. Can you use variable to change caption on command button (1 replies)
  2. Capturing headings of frequent data (0 replies)
  3. Pasting a worksheet to another worsheet in another workbook (0 replies)
  4. VBA userforms, control is command button is visible (7 replies)
  5. Display special values in Column B (2 replies)
  6. txt list function excluding zero (1 replies)
  7. Solved: calculating a %, based on the bg color of a cell (3 replies)
  8. [SOLVED:] Countname function (3 replies)
  9. [SOLVED:] Vlookup Sum help (2 replies)
  10. Calculating Days and Inactivating the columns (5 replies)
  11. Solved: move data in Excel (2 replies)
  12. Solved: Update worksheet data through userform (4 replies)
  13. If statement for Cells.Find (5 replies)
  14. Dynamic Sheets (9 replies)
  15. Solved: function to calculate average (4 replies)
  16. Button loses connection to macro when I "Save As". (5 replies)
  17. save as csv file codepage problem (7 replies)
  18. [SOLVED:] How to see when was a workbook last time opened (2 replies)
  19. Reading .txt Files (7 replies)
  20. My macro stops half way through because of a dialog box (4 replies)
  21. Macro for refresh (0 replies)
  22. countdown timer (2 replies)
  23. Solved: Find Replace Macro for Selection (2 replies)
  24. Loop Conditional Statement through 2 columns and Copy/Paste from corresponding column (1 replies)
  25. Solved: Calling a sub procedure using variables from another sub procedure (10 replies)
  26. Solved: Special Cells - Count (8 replies)
  27. Synchrinizing excel file (15 replies)
  28. Solved: VBA to hide unrequired sheets? (3 replies)
  29. Solved: Prevent users from entering "Essential Position" in more than one worksheet (3 replies)
  30. Solved: Populate Combobox with spreadsheet col (7 replies)
  31. Solved: Multiple option buttons on user form (8 replies)
  32. update master worksheet from multiple workbooks (0 replies)
  33. Solved: Summing tasks for a Month period (2 replies)
  34. how to add columns from other excel files (3 replies)
  35. Solved: Excel VBA Groupwise (File names) (4 replies)
  36. Custom data transfer based on criteria (2 replies)
  37. Solved: Custom toolbar for use in all instances of Excel (3 replies)
  38. Select Unique values from a coulmn (1 replies)
  39. Solved: Where did the 07 known issues thrd go? (7 replies)
  40. How to remove protection password using Macro (3 replies)
  41. How to inser Row using VB (5 replies)
  42. [SOLVED:] Solved: Help with random sampling code (2 replies)
  43. Forget Password (3 replies)
  44. VBA combo-box printing pdfs (2 replies)
  45. VBA Error Subscript Out of Range (6 replies)
  46. Select last active cell, offset (-50, 0) copy (2 replies)
  47. ZIP the files using VBA (4 replies)
  48. Solved: Advanced Filter with empty cells (8 replies)
  49. Solved: Worksheet Function Compile Error (1 replies)
  50. Vb Error Prompt (7 replies)
  51. cell reference from one sheet to another (8 replies)
  52. Solved: Delete sheet greyed out (1 replies)
  53. Can't name a command button with code (0 replies)
  54. Solved: Fill the blank cell (3 replies)
  55. Formulas to measuer four two criterias (9 replies)
  56. File Access (3 replies)
  57. Problem pasting a Picture into an image control (0 replies)
  58. inserting rows (6 replies)
  59. Right Click Menu of Sheet tab (4 replies)
  60. save function not working properly (2 replies)
  61. Solved: Unmerge cells & Auto-fills (6 replies)
  62. [SOLVED:] Copy/Move Worksheet (1 replies)
  63. Modify Variables in One Workbook from another Workbook? (1 replies)
  64. How to create in excel a form with a menu? (19 replies)
  65. Solved: clear clipboard before closing excel (2 replies)
  66. [SOLVED:] Last Saved Information (4 replies)
  67. Solved: Problem in append data to next column (2 replies)
  68. Solved: getting values from files with changing names (9 replies)
  69. Can i use arrays here? (3 replies)
  70. Solved: Workbook Save Flag (4 replies)
  71. Merging two sheets (14 replies)
  72. How to add only 1 worksheet from an Add-in (5 replies)
  73. Get email address of the user log from excel vba (2 replies)
  74. populate list/combobox without duplicates (3 replies)
  75. Solved: Charts automation using vba, works with Excel 2007 but error with 2003. (4 replies)
  76. How to exit print preview mode? (3 replies)
  77. MULTIPLE CONDITIONAL FORMAT WITH FORMULA IN PIVOT TABLE (0 replies)
  78. macro to perform selective addition (0 replies)
  79. Check Version & Download Latest (4 replies)
  80. Sequence two or more loops - VBA code (2 replies)
  81. Filter the specific data and find the difference (8 replies)
  82. Solved: Complete excel sheet on command (4 replies)
  83. Solved: Filtering Columns (7 replies)
  84. How to avoid displaying a warning box on save? (5 replies)
  85. Solved: Using Comments to Document Formula (2 replies)
  86. How to format cells in one row (2 replies)
  87. Problems creating large numbers of sheets (7 replies)
  88. Solved: import and split a text file into worksheets by year (6 replies)
  89. Fill down formula with data pivot change (0 replies)
  90. tracking changes (3 replies)
  91. need help in excel sort (6 replies)
  92. Solved: Max Values - Formula solution (2 replies)
  93. Changing named range in loop (3 replies)
  94. Hide Checkboxes based on last column (4 replies)
  95. FTP an Excel File (3 replies)
  96. Using name ranges with sumproduct? (6 replies)
  97. Solved: Max Value and the date it occurred? (13 replies)
  98. Solved: validate Combo boxes (2 replies)
  99. Solved: Point And Figure Chart (10 replies)
  100. Solved: Parsing a field (4 replies)
  101. Aligning a chart to cells code (3 replies)
  102. Solved: Filter by Date Selection? (8 replies)
  103. copy contents of csv files (6 replies)
  104. Solved: Function Required for Mega Formula (9 replies)
  105. Paste the content from Excel to UserForm -> TextBox (4 replies)
  106. Userform Spinbutton to advance row and refresh (1 replies)
  107. Using Excel 07 for complex web queries? (10 replies)
  108. [SLEEPER:] Merge / Combine Multiple workbooks (3 replies)
  109. Solved: calculate percentages using sumproduct? (8 replies)
  110. Solved: Reference another Excel workbook without Activating it (3 replies)
  111. Solved: Set Value of Merged And Centered Cells (2 replies)
  112. Solved: SUMPRODUCT across multiple sheets (2 replies)
  113. Inserting Carriage returns in Message Boxes (2 replies)
  114. Solved: Calculate "Current Month Average" (9 replies)
  115. Solved: Outlook Email Blast from Excel (1 replies)
  116. My Excel Crashes on Close (1 replies)
  117. Solved: How do you modules to calculate? (3 replies)
  118. Solved: Test if rows are hidden (2 replies)
  119. Critical Thinking Challenge (3 replies)
  120. Copy and paste count by last row (2 replies)
  121. Solved: Setting a Range as a Class Property (2 replies)
  122. How to convert dates in my Sub (5 replies)
  123. Using Excel to look at charts (4 replies)
  124. Solved: Conditional Format to a Linked Cell (4 replies)
  125. SaveAs with embedded Word document - OLEObjects (4 replies)
  126. Solved: Check my code please to find next blank row (2 replies)
  127. Solved: Ranking Data in List (2 replies)
  128. Solved: maximum function with #na value (4 replies)
  129. Solved: Sending Long to Clipboard or any other way to get it to Word from Excel? (2 replies)
  130. Solved: Importing space delimited text files (6 replies)
  131. Solved: Help for FY problem (5 replies)
  132. Using two Userforms. (4 replies)
  133. Solved: IF THEN COMMAND (8 replies)
  134. Copy Paste Values (7 replies)
  135. VB copy & paste help .......pleased (1 replies)
  136. How to detect a digital certificate (0 replies)
  137. Limit data field in PIVOT TABLE (2 replies)
  138. Solved: Match help (2 replies)
  139. Running Macro on Muliple Files (4 replies)
  140. How do I preserve the user's Clipboard while he's accessing my form? (3 replies)
  141. Can complete VBA code be exported to a different WKBK (3 replies)
  142. Selecting Column Until End of Another Array (7 replies)
  143. Solved: copy and paste macro - simple, right? (12 replies)
  144. convert to pdf to excel using vba (8 replies)
  145. How to call sub(which is personal.xls) in activeworksheet. (3 replies)
  146. VBA Find from EXCEL replace to WORDS HELP !!!! (4 replies)
  147. Multiple copies of Active Worksheet (2 replies)
  148. Solved: Read only password (1 replies)
  149. Excel save file (4 replies)
  150. Solved: How do I identify the type of graphic object that is currently selected? (4 replies)
  151. Solved: conditional population of cell (1 replies)
  152. Solved: Format cell when condition fulfilled (4 replies)
  153. Solved: Pulling Data from several sheets to one - Macro (1 replies)
  154. Form Close help (15 replies)
  155. need to automate date of last data entry (4 replies)
  156. Passing Parameter to Excel for SQL Report (5 replies)
  157. Search for repeated characters (8 replies)
  158. Solved: Send button value as arguement to macro (2 replies)
  159. Solved: Values to Text (2 replies)
  160. VBA multiple ranges (8 replies)
  161. Merge & compare excel formula (4 replies)
  162. How can I create an Object and send by email? (3 replies)
  163. Solved: Search for text as part of a cell (2 replies)
  164. Solved: How to export an excel chart as a jpeg (4 replies)
  165. Solved: How to get AVERAGE of range into a cell (3 replies)
  166. Solved: Formatting cells with times (3 replies)
  167. Solved: hyperlink question (1 replies)
  168. Solved: If statement - Cell starts with Number (2 replies)
  169. Automatically Generate Reports from Excel Template (2 replies)
  170. Solved: Min of 4 Nos,returning >0 values (3 replies)
  171. Solved: countif with multiple criteria (3 replies)
  172. Solved: Data Export (6 replies)
  173. Solved: Excel to Outlook - late binding? (2 replies)
  174. Copy formula down the column (4 replies)
  175. Solved: Hi-Lite a cell based on value in another cell (4 replies)
  176. Import mutiple files from a folder to excel files (1 replies)
  177. Solved: Counting number of times a code has been executed (6 replies)
  178. Solved: Count cells with 3 requirements (3 replies)
  179. Amend VBA Code to include extra worksheet(s) (1 replies)
  180. Solved: Date Formatting help (4 replies)
  181. Solved: Saving File - Automated File Naming (16 replies)
  182. Add different password(S) to worksheet(s) from workbook (0 replies)
  183. Automatically insert rows at varied intervals (8 replies)
  184. Solved: Finding Min & Max values by week, month and year (2 replies)
  185. Sleeper: Disabling of cutcopypaste for a few cells in a worksheet (8 replies)
  186. Solved: Making a Range non-editable (6 replies)
  187. Last Updated Alert (1 replies)
  188. Solved: sum only certain columns (1 replies)
  189. File download without knowing the full url / redirect (2 replies)
  190. Changing the font in the fluent ribbon (1 replies)
  191. Call MS Access function in module via Excel (2 replies)
  192. Prevent Calculation Running While Saving (4 replies)
  193. [SOLVED:] Using vlookup if the lookup value is not in the first column (2 replies)
  194. Macro to search active cell value and look for it in word docs saved in a folder (0 replies)
  195. Solved: Adding worksheet to blank workbook (4 replies)
  196. Solved: Transpose column A to rows (4 replies)
  197. Solved: Scale graph absolutely (6 replies)
  198. Consolidate data (2 replies)
  199. Solved: Merge Excel file through validation (15 replies)
  200. Opening/getting data from different excel file (7 replies)
  201. Autofilter/Delete Duplicates/Find Changes (13 replies)
  202. Solved: Auto Load Form when Excel Launches (8 replies)
  203. Solved: Hundreds of links on Multiple Sheets (5 replies)
  204. Solved: Data Management In Excel - Theory/Design (3 replies)
  205. Solved: Any way to retrieve deleted file (2 replies)
  206. Cumulative % in Pivot (13 replies)
  207. Solved: Undo a Hyperlink (4 replies)
  208. Record varying length of text in cells (1 replies)
  209. Solved: Add New sheet every day (1 replies)
  210. Solved: Source and location function (2 replies)
  211. Solved: Calculating average based on some criterion (2 replies)
  212. payroll weekly time excel formula (5 replies)
  213. Solved: Adding A "ScreenTip" or Pop-Up Message When A User Hovers Their Mouse Over An Image?? (4 replies)
  214. Function with circular reference - VBA (12 replies)
  215. Solved: how to avoid LITTLE GREEN TRIANGLE error (3 replies)
  216. Solved: VBA Code . Max of 4 nos and min of 4 nos (7 replies)
  217. Solved: How to do arithmetic on addresses (2 replies)
  218. Solved: Namespace (2 replies)
  219. Size chart to Word cell (1 replies)
  220. creating a folder then giving a user ID modify permissions to it (0 replies)
  221. Solved: Find Multiple Entries - Change Cell Value (13 replies)
  222. Email from excel (5 replies)
  223. Solved: password lock a worksheet using a userform (1 replies)
  224. Solved: How to merge Empty cells in a selection (2 replies)
  225. Excel search files (7 replies)
  226. Solved: Autofill a column with text (8 replies)
  227. Solved: How to Link two sets of ranges (5 replies)
  228. Solved: Delete the Row based on criteria (2 replies)
  229. how run a sumif column name is true (3 replies)
  230. Solved: MS Query on open workbook (1 replies)
  231. Solved: min of 2 nos, if positive (4 replies)
  232. Help with autocomplete in textBoxes (6 replies)
  233. Solved: Deleting Rows (2 replies)
  234. How To Count The Number Of Records Selected By AutoFilter (7 replies)
  235. Solved: Delete Sheets in Add-in (1 replies)
  236. Solved: How to copy a dynamic range (4 replies)
  237. Solved: Error when I attempt to filter worksheet (6 replies)
  238. Solved: Application-defined or object-defined error - Len(c.Offset(0,-1).value) (3 replies)
  239. Font Color Cell (1 replies)
  240. Solved: Really basic stuff (6 replies)
  241. Solved: send active worksheet to outlook mail recipient as an attachment (1 replies)
  242. Solved: Show the next months Lists (2 replies)
  243. Solved: connect with access (4 replies)
  244. VBA Check Cells - Easy but help! (0 replies)
  245. Solved: UDF Inserting Unwanted Quotation Marks (5 replies)
  246. Solved: Filter unique values and count their frequency (7 replies)
  247. Autofill Rows with formula (17 replies)
  248. Insert tabs in to an excel worksheet (7 replies)
  249. Set Focus On Excel Instead Of Powerpoint (1 replies)
  250. Solved: paste to last empty row and beyond (2 replies)