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. Change to Month Sheet name (12 replies)
  2. Find number of lines ? (5 replies)
  3. Loop through chart and Highlight chart labels based on value (1 replies)
  4. Solved: Number Format from access field into excel (3 replies)
  5. Pivot Table data source (8 replies)
  6. Solved: IsFileOpen and WorkbookIsOpen giving differing results (3 replies)
  7. Help Needed, E-mailing reports (1 replies)
  8. Number of sorts allowed in XL2007 (2 replies)
  9. Solved: need help to create a "database" in excell (18 replies)
  10. [SOLVED:] Solved: Autocomplete cells (5 replies)
  11. Solved: MsgBox code to check for Existence of and Opened Files (2 replies)
  12. Get sub group data based on main group (4 replies)
  13. Solved: FSO Function to get Datelastmodified, DateLastAccessed (8 replies)
  14. Solved: How to find the most common numbers? (6 replies)
  15. Enter image based on cell value (9 replies)
  16. Solved: VBA Date Formatting with links (2 replies)
  17. Solved: Cut entire rows to sheet on condition (6 replies)
  18. [SOLVED:] Sum dynamic number of worksheets into one (2 replies)
  19. Solved: Countif formula to be used on a dynamic range to be used on a data table (11 replies)
  20. Solved: Automation error (5 replies)
  21. Solved: Userforms created with macro (5 replies)
  22. Solved: Printing a *.gif file from a command button depending a cell value (5 replies)
  23. Selecting a group of cells using the Range.offset syntax (9 replies)
  24. Solved: Highlight ROW based on cell value (4 replies)
  25. Solved: SOLVED -- Update cells same sheet based on data changes (3 replies)
  26. Using VB 08 to combine excel files (2 replies)
  27. Determining how a ComboBox was changed ... (1 replies)
  28. Solved: Copying data onto next empty row, under certain criteria (11 replies)
  29. Macro to copy, then paste to visible cells (3 replies)
  30. Solved: Delete any spaces in cell (3 replies)
  31. Sleeper: Copy rows from worksheet 1 to worksheet 2 (9 replies)
  32. Is it possible to loop a macro constantly? (21 replies)
  33. Solved: Copy specific cell based on date condition paste to specific cell (2 replies)
  34. Solved: Exclude rows (2 replies)
  35. Solved: checkBox-- Handle Value (1 replies)
  36. Solved: Copying between sheets (5 replies)
  37. Replace Combobox with Listbox ... (2 replies)
  38. Solved: add headers to print then set page setup settings back. (1 replies)
  39. Delete Empty Sheets (8 replies)
  40. Sorting a range of cells (7 replies)
  41. conditional formatting help (3 replies)
  42. Solved: Loop Until Blank or situation (7 replies)
  43. Multi Users in Excel (22 replies)
  44. Solved: Excel Macro Not Setting a Cell's Value (5 replies)
  45. Solved: VBA for Cell Link to network folder document. (10 replies)
  46. Solved: Major issue blank cells (2 replies)
  47. Solved: Function with multiple exit points (3 replies)
  48. Copy adjacent cells and paste in non adjacent columns (9 replies)
  49. Solved: Stumped - formulas required (3 replies)
  50. Solved: Charting with labels (2 replies)
  51. Change Drive Letter of Removable Storage (9 replies)
  52. Solved: Add to existing IF formula (7 replies)
  53. Solved: Problem with formats (4 replies)
  54. help with print, clear and save maros (3 replies)
  55. Temporarily widen column (2 replies)
  56. From Excel Find Replace in Word 2 (1 replies)
  57. [SOLVED:] Search value and insert row under value (38 replies)
  58. Summary sheet update keeping set columns in place (0 replies)
  59. [SOLVED:] Finding the hour prior to original hour (2 replies)
  60. Solved: add leading zeros with a specified length of characters (9 replies)
  61. How can I make CopyPicture show the selected cell (2 replies)
  62. Solved: Minimum Positive value finder using VBA (3 replies)
  63. Transpose Question (4 replies)
  64. Solved: Copy a range from the fourth sheet on (2 replies)
  65. Solved: Best way to go about? (2 replies)
  66. Solved: Get FileNames From Folder Not Using PathName (8 replies)
  67. Solved: Delete Sheet list (7 replies)
  68. Solved: Filter & Transfer (2 replies)
  69. copy values that aren't zero (18 replies)
  70. Downloading data from webpage into Excel (2 replies)
  71. Does visual basic express work with excel? (10 replies)
  72. Enter, Tab and Up/Down Arrows Stop Working (5 replies)
  73. Solved: Append matched row data from source wsheet back to corresponding row (2 replies)
  74. Solved: Open vba file (5 replies)
  75. Solved: Dynamically hide unused rows (2 replies)
  76. Solved: VBA code for "or" + "and" functions (4 replies)
  77. export worksheet problem (1 replies)
  78. Regex in Excel 2007 (4 replies)
  79. Solved: delete open workbook (2 replies)
  80. Solved: Digital clock within worksheet needed (3 replies)
  81. Generating an incremented workbook file & save as variable (1 replies)
  82. Identify the numbers that make up the average (1 replies)
  83. Solved: Sinple question regarding calculating a due date... (4 replies)
  84. Solved: lookup the 4th characters in a cell (3 replies)
  85. Solved: Inserting Rows after a count (5 replies)
  86. Solved: Sort Data and color code (3 replies)
  87. Solved: Emailing CC. recipients (4 replies)
  88. Solved: Move rows to new sheet based on condition (10 replies)
  89. Solved: Highlight cell from link (3 replies)
  90. Solved: Changing the settings of a combobox (2 replies)
  91. ActiveChart.SeriesCollection(x) Referance (1 replies)
  92. Solved: more if condition in one formula (10 replies)
  93. Solved: Remove Empty Cells from Range, Copy and Paste (5 replies)
  94. export selected worksheet into dbf format (1 replies)
  95. Search for keyword within a keyword search (0 replies)
  96. Code help with Aggregating Statements (1 replies)
  97. Solved: add column values (2 replies)
  98. TextAlign for specific columns in a ListBox (2 replies)
  99. Rand Select Unique Values (0 replies)
  100. Selecting a Range of Dates with a Specific Month (1 replies)
  101. Format Chart Data Lablel based on Target Value/Goal (1 replies)
  102. Solved: Changing column values to negative and in descending order (2 replies)
  103. Solved: Dynamic field parser/importer (15 replies)
  104. Activate an 'Add in' in a macro (1 replies)
  105. Solved: Highlight Numbers (1 replies)
  106. Solved: extend range of cells (5 replies)
  107. Solved: Clear Contents in all worksheets in workbook (3 replies)
  108. Solved: Search for possible combinations of values (9 replies)
  109. RefEdit issue (4 replies)
  110. Solved: Simple way of moving all files in a folder (2 replies)
  111. Retrieve data from Outlook (2 replies)
  112. Solved: Excel 2007 Add-ins (4 replies)
  113. Solved: Userform textbox - random numbers (Excel '97) (2 replies)
  114. Loop through auto generated filter by variable (Help needed!) (1 replies)
  115. Solved: Adjusting the last digit of a number with macro (2 replies)
  116. [SOLVED:] UDT initialization (3 replies)
  117. Listbox Header (4 replies)
  118. Double lookup (2 replies)
  119. Solved: Nesting in a Private Sub Worksheet_Change (2 replies)
  120. Switch the active Window ... (4 replies)
  121. Comment box style help (1 replies)
  122. Protected Cells (6 replies)
  123. Solved: Open a workbook from a path stored in a variable (2 replies)
  124. Clear All Command Button in User Form (4 replies)
  125. Multiple IF else formula not working. (2 replies)
  126. Find similar part # (2 replies)
  127. Solved: Server moved, macro failed (9 replies)
  128. In Cell Drop Down List (4 replies)
  129. Solved: Calculating weighted average using macro (5 replies)
  130. Selecting rows in viewable filters (2 replies)
  131. Very Basic Loop Question? (4 replies)
  132. Solved: option button help (4 replies)
  133. How to change cell data in excel by reading data from another file (0 replies)
  134. Show userform while macro runs (4 replies)
  135. Hide Protect/Unprotect Sheet (3 replies)
  136. Solved: File Count in Directory (9 replies)
  137. Can you tell if a cell has Data Valdidation Circle? (0 replies)
  138. Pulling Data into Excel from IE Javascript table? (10 replies)
  139. Fixing worksheet in place (2 replies)
  140. Solved: Break up total months into years and month (2 replies)
  141. Protect only selected cells (3 replies)
  142. Insert Hyperlink in Cell using Text Box (2 replies)
  143. Solved: comment used to track changes (18 replies)
  144. Switching between Excel instances (2 replies)
  145. VBA code to search & open file in FTP directory (28 replies)
  146. Solved: Find Greater Than (7 replies)
  147. Using Sumif in a Macro (3 replies)
  148. Error handling declaring public variables (1 replies)
  149. Solved: Generating a Pivot thru VBA (Summary) (2 replies)
  150. Load colours from another sheet (4 replies)
  151. Array Type Mismatch (6 replies)
  152. Can I send a CDO message via a Proxy Server ? (0 replies)
  153. Solved: Todays Date Name in VBA (3 replies)
  154. Changing a checkbox value (2 replies)
  155. How to clone a class? (8 replies)
  156. Pivot table using 4 other excel books for data (0 replies)
  157. VBA Macro Creates Scatter Plot in 2003, Adds Lines in 2007??? (0 replies)
  158. 2nd criteria filter-search in lisform (3 replies)
  159. [SOLVED:] Print multiple sheets to virtual printer as one print job (3 replies)
  160. Range Position and link to ranges (3 replies)
  161. Search for empty column / paste values only? (3 replies)
  162. Blank line at end of file (12 replies)
  163. vlookup / match / concatenate?? (4 replies)
  164. Calculated field on pivot (1 replies)
  165. textbox default value (2 replies)
  166. [SLEEPER:] comparing text (1 replies)
  167. Run time error 1004 - Application defined or object defined error. (4 replies)
  168. Solved: Formula with { & } at both ends (13 replies)
  169. Error: Too Many Different Cell Formats (1 replies)
  170. CODE HELP (1 replies)
  171. using inputbox data (2 replies)
  172. Solved: Formula gone wrong (4 replies)
  173. VBA code for Shared workbooks (0 replies)
  174. Solved: Find the numbers out of sequence (3 replies)
  175. Solved: Display user name using msg box function (3 replies)
  176. checkbox size (4 replies)
  177. Copying a worksheet content to 19 other WSs in the same WB (2 replies)
  178. Solved: Copying cell content if target cell is blank (4 replies)
  179. Solved: Problem writing formula (1 replies)
  180. Solved: personal.xls (2 replies)
  181. Writing to specific row using matching criteria from user form (0 replies)
  182. Pass String to Word macro (6 replies)
  183. Solved: Reset Button duplicates combobox list (2 replies)
  184. Solved: Formula for Date Ranges (5 replies)
  185. Solved: Updated data should export to Create Task in MS-Outlook (19 replies)
  186. Excel 2003 SP3 (Excel11) problem (0 replies)
  187. Pivot table trouble (4 replies)
  188. Solved: Path to macro (31 replies)
  189. split a variable (8 replies)
  190. Not able to copy a VBA array with formulas into an Excel range (1 replies)
  191. Solved: Updating Cell Info (2 replies)
  192. [SOLVED:] How to split a PDF into pages using VBA (12 replies)
  193. Solved: WEEKNUM - Excel 2003 (9 replies)
  194. find if cell value changed (4 replies)
  195. Conditionally Populate Value in Rows Using List/ComboBox (0 replies)
  196. How to know if multiple cells were selected (5 replies)
  197. VBA script to verify that file size is increasing (9 replies)
  198. search first value in range (9 replies)
  199. Solved: RANDBETWEEN FUNCTION (3 replies)
  200. active cell formula typing (4 replies)
  201. Mail the current workbook to different recipients on condition (2 replies)
  202. Help needed Macro Runs after userform is closed (3 replies)
  203. Solved: Further Help with Code (8 replies)
  204. Help with disabling Macros in another workbook (1 replies)
  205. VBA Macro Conditional letter generation (11 replies)
  206. stupid F8 in excel 2003 (0 replies)
  207. [SLEEPER:] Integrate Excel with AD. (0 replies)
  208. Help with the error (10 replies)
  209. Solved: Subscript out of range (Error 9) VBA Code works on one computer but not the other. (4 replies)
  210. Solved: VBA pastes in wrong range (2 replies)
  211. [SOLVED:] Excel and Bloomberg (6 replies)
  212. Solved: UserForm Import Form (0 replies)
  213. [SOLVED:] My "do while" loop doesn't complete (3 replies)
  214. Solved: If statements (3 replies)
  215. Categorizing data (6 replies)
  216. Solved: Form Question (4 replies)
  217. how to hide excel toolbars from macro enabled file (2 replies)
  218. Search form in excel (4 replies)
  219. Solved: Close workbook and quit XL (4 replies)
  220. Solved: Search for an Excel field (3 replies)
  221. [SLEEPER:] Pull .xls from google docs via vba (2 replies)
  222. Delete rows except user defined criteria (2 replies)
  223. grouping tasks (13 replies)
  224. Solved: Only use CommandButton Once (6 replies)
  225. Report creation (5 replies)
  226. Combining two VBA processes (3 replies)
  227. Solved: Copy range help (4 replies)
  228. solved: Excel VBA Removing duplicates (2 replies)
  229. Solved: How to stop an 'on_change' subroutine running if I make a change via another subrouti (2 replies)
  230. Solved: Offset Function Question (4 replies)
  231. from excel formula to vba ... (6 replies)
  232. Solved: Cell contains certain text, delete row? (8 replies)
  233. NEED HELP IN LINEAR PROGRAMMING PLZZZZ (1 replies)
  234. Filtering an ADODB recordset (1 replies)
  235. put clipboard as variable (10 replies)
  236. Solved: Deleting Autoshapes with vba (3 replies)
  237. Excel VBA Row Generation if Value Exists (8 replies)
  238. Solved: How to make spreadsheet tabs invisible but not hidden (5 replies)
  239. Solved: A quick Sendkey question (1 replies)
  240. Test what formula is in a cell and change it Excel 2007 (4 replies)
  241. SearchFind = Nothing in Union &/or Intersect (2 replies)
  242. Create range of only duplicates from another range (23 replies)
  243. Solved: Enable command button if in group of option button one option is selected (5 replies)
  244. Solved: Close Sheet after Copy (4 replies)
  245. Solved: Copy Sheets to a New workbook (4 replies)
  246. Pass form Object to Function (5 replies)
  247. Copy Active sheet to new workbook. (23 replies)
  248. macro help (8 replies)
  249. Intersect with multiple ranges (6 replies)
  250. Line Graph (3 replies)