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. Solved: input box loop (6 replies)
  2. Advanced Find & Replace (2 replies)
  3. [SOLVED:] Finding complicated average (5 replies)
  4. [SOLVED:] Automatic addition of comments to entire column (3 replies)
  5. Solved: Add to comment? (4 replies)
  6. Write to Output File w/out Overwriting Everytime? (7 replies)
  7. Solved: Find Empty Column Range (3 replies)
  8. Recording web application using a macro? (1 replies)
  9. Solved: RANK (??) (2 replies)
  10. Solved: Find value and count occurances of text (4 replies)
  11. Solved: use GetOpenFilename with only few files displayed (10 replies)
  12. Solved: Script to add values in new sheet without blank rows (8 replies)
  13. VBA Compare Excel Files Macro (8 replies)
  14. VBA to disable close (14 replies)
  15. ActiveSheet.Paste Error (2 replies)
  16. convert Exif photo data to excel (2 replies)
  17. Solved: Auto-repeating input error (1 replies)
  18. Incremental Change in Values of Data Table (3 replies)
  19. Solved: Change caption of a button on spreadsheet without selecting it (4 replies)
  20. Solved: Prompt comment? (1 replies)
  21. Chart source data depends on the sheets choosen on the Combo box (1 replies)
  22. Displaying text with freeze panes (1 replies)
  23. Clearing and resetting CTRL+END (1 replies)
  24. Solved: When replacing a sheet, how to fix refs? (3 replies)
  25. Print PDF file (4 replies)
  26. Solved: Reduce size of current region (2 replies)
  27. Solved: Add opened file into a summary workbook (2 replies)
  28. Solved: Invintory Project. (7 replies)
  29. Solved: Low inventory alert (10 replies)
  30. Solved: Custom Prompt box w/ multiple buttons (5 replies)
  31. Truncating cell data to fit in cell (2 replies)
  32. Vlookup the price in latest date (4 replies)
  33. Solved: add to existing value by matching (11 replies)
  34. [SOLVED:] Why do create a temporary variable and then set the value to a function? (1 replies)
  35. Solved: Excel equivalent to MS Word's DOCVARIABLE? (2 replies)
  36. Solved: VBA lookup to insert value into cell. (7 replies)
  37. Solved: Loop through user specified folder (3 replies)
  38. Solved: Find is not matching expected values (3 replies)
  39. Chart Colouring Macros (4 replies)
  40. Solved: Make chart where source data range is variable (2 replies)
  41. filter - hide active cell content (11 replies)
  42. Solved: Create a marco that will autofill a formula but the range is variable (2 replies)
  43. Solved: clear cells without form appearing (8 replies)
  44. Dynamic graph (0 replies)
  45. Buttons to Start and Stop Macro (2 replies)
  46. Solved: VBA code to periodically copy data (3 replies)
  47. Vlookup (6 replies)
  48. Selecting more than cell VBA (7 replies)
  49. Solved: Explanation of Advanced Filter (5 replies)
  50. Using FieldInfo with variable array content (6 replies)
  51. Solved: Limit input to textbox (9 replies)
  52. Solved: MS Excel: Password Problem (11 replies)
  53. Solved: How to open all files in folder using input box (7 replies)
  54. Sorting then send (6 replies)
  55. Solved: Assign Macro to Runtime-Generated Textbox Event (4 replies)
  56. Strange combobox problem (2 replies)
  57. Query-Style Custom Function needs speed boost! (4 replies)
  58. Macros help (1 replies)
  59. Solved: Deleting data within a named range (xl '97) (7 replies)
  60. Solved: Copy selected cells in all worksheets and paste into another worksheet (6 replies)
  61. [SOLVED:] Excel VBA Open / Save As (14 replies)
  62. Solved: IF Formula problems (3 replies)
  63. Solved: sumproduct formula error (14 replies)
  64. Excel Vba for Macros... (2 replies)
  65. Code to Filter, Copy, Paste and Save Data (3 replies)
  66. Loop fifty files into one file (3 replies)
  67. Solved: User Form syntax (2 replies)
  68. VBA to open Excel & Enable Macro (4 replies)
  69. Solved: Deleteing unused word bookmarks (3 replies)
  70. Sorting Collections (7 replies)
  71. Solved: Copy string to clipboard in VBA (3 replies)
  72. Pivot Chart and Table Problem (2 replies)
  73. Excel Formula Help (1 replies)
  74. Solved: Conditional Formatting a worksheet based on value in a cell in another worksheet (3 replies)
  75. Count of rows excluding a set of values in the another sheet (12 replies)
  76. Change Array Arguments to read horizontal instead of vertical (5 replies)
  77. Copying data from DB in a Sheet (1 replies)
  78. How to exclude hidden pivot field items in count (3 replies)
  79. Excel VBA recognizing the variable as Date wrong (3 replies)
  80. Delete the duplicate value/cell in selected range (5 replies)
  81. Need Help developing an Algorithm to Decode MathML (XML) (6 replies)
  82. Solved: how to reference previous cell value (2 replies)
  83. Solved: Webbrowser page depending on listbox value (2 replies)
  84. Continual Import of Excel data into Sharepoint list (1 replies)
  85. [SOLVED:] Sorting a column alphabetically, however a blank row between names must be retained. (8 replies)
  86. Load Excel Userform from Powerpoint Button (6 replies)
  87. AutoCorrelation and Partial AutoCorrelation series Generation (5 replies)
  88. Solved: Need Help with the Logic of my Program (9 replies)
  89. Inventory control (11 replies)
  90. Solved: Iserror in VBA setup (4 replies)
  91. Macro to copy paste data (3 replies)
  92. Nested Collections (8 replies)
  93. Solved: Adding 2 worksheets to an existing workbook (11 replies)
  94. Solved: Macro need to direct a cell value to the corresponding named worksheet. (2 replies)
  95. Hyperlink Problem when print Excel to PDF (2 replies)
  96. Keyboard shortcuts (5 replies)
  97. Solved: VBA - form/workbook problem (3 replies)
  98. VBA - Need Help for a SQL Query (1 replies)
  99. Solved: MsgBox if birthdate is <1 year ago? (25 replies)
  100. Solved: Looping: Copy two worksheets to new workbook (9 replies)
  101. Code to insert info needs tweaking (10 replies)
  102. Macro letting the user decide where to save the file (and decide the filename) (1 replies)
  103. Solved: Save document with new filename, close it and re-open original file (2 replies)
  104. 2007 title bar (2 replies)
  105. Changing Cell Value Code (3 replies)
  106. Solved: Save a document with today's date in a macro (9 replies)
  107. Reformat Data with Macro (4 replies)
  108. Sleeper: Excel UDF Error - Connecting to SPSS (1 replies)
  109. Solved: VBA to Save a workbook with an incrementing Version Number (9 replies)
  110. Solved: Update a Word TOC from Excel VBA (1 replies)
  111. Solved: Hide rows (13 replies)
  112. Help Opening Embedded Word File (9 replies)
  113. Solved: Message while running macros (5 replies)
  114. long data type in ADO recordset (1 replies)
  115. A really annoying Loop, Help please! (8 replies)
  116. Solved: How to validate data in a userform prior to the data being transferred to a worksheet (2 replies)
  117. Solved: Excel/Access - SQL statement - WHERE/AND (Office '97) (3 replies)
  118. How to Get the Name of Executing Macro (1 replies)
  119. Solved: find same value in two different lists and copy rows in new sheet (7 replies)
  120. Solved: find same value in two different lists and copy cells in new sheet (18 replies)
  121. Solved: 50% Excel, 50%Outlook, 100% fail (17 replies)
  122. Solved: Dependent in Invoicing (13 replies)
  123. Solved: Addin Command Bar Not Loading (1 replies)
  124. Solved: sort dates (5 replies)
  125. Updating duplicate worksheet (23 replies)
  126. Userform Problems (7 replies)
  127. Solved: Code not summing properly (5 replies)
  128. dynamically merging cells in different rows based on the position on the worksheet (9 replies)
  129. Solved: UserForm, Passing Variable (Excel '97) (2 replies)
  130. Solved: IF Statement Help (2 replies)
  131. Solved: Search column a for value select and past rows to next sheet (2 replies)
  132. Solved: Random Numbers Repeating (2 replies)
  133. Force an opening workbook to open in an alternate instance of Excel (0 replies)
  134. Enable copy and paste (2 replies)
  135. export/update from excel workbook to access database file (1 replies)
  136. Solved: Join an array and join a Range (3 replies)
  137. [SOLVED:] Auto calculate active worksheet (4 replies)
  138. Excel Data to Word Labels (1 replies)
  139. Insert-Delete Rows with Formulas Error (0 replies)
  140. Solved: AutoFill Active Cell (13 replies)
  141. [SOLVED:] VBA Hiding Unused Cells (11 replies)
  142. Solved: VBA to Delete rows using IsError (8 replies)
  143. VBA Advanced Filter (4 replies)
  144. To open Another Excel in a different Window using code (2 replies)
  145. Solved: Excel formula needed for if or countif or both (3 replies)
  146. assign values next to the last used cell (7 replies)
  147. Creating a userform to perform a search function (5 replies)
  148. Cells Index (6 replies)
  149. Need VBA help - coming up with runtime error when remote users run a macro (1 replies)
  150. Solved: Recordset Seek method issues (0 replies)
  151. Solved: Select case statement problem (8 replies)
  152. Solved: Userform & enabling textboxes (8 replies)
  153. Average with vba (7 replies)
  154. Switch to a specific open application (6 replies)
  155. Change multiple worksheet names based on cell values. (9 replies)
  156. Solved: Macros to be disabled on the workbook (4 replies)
  157. Solved: Sort worksheets using a Range as the Sort Order (7 replies)
  158. Solved: Change Code Modules and Userforms (4 replies)
  159. The last date of use (3 replies)
  160. [SOLVED:] Insert/Delete Row Code Issue (2 replies)
  161. Adding zeros to numbers entered (6 replies)
  162. disable menu items (10 replies)
  163. new to vba (10 replies)
  164. Cells.find works but found info is not copied (8 replies)
  165. CountIF statement (6 replies)
  166. Solved: Extract Data from multi worksheets (5 replies)
  167. Shapes as a Toggle Button? (5 replies)
  168. Moving Forms (4 replies)
  169. Selecting a picture (1 replies)
  170. Solved: VBA to create Charts for several sheets with different data lengths (4 replies)
  171. how to use an input box to create a formula (3 replies)
  172. How to copy from Column A2 to the last populated Column. (1 replies)
  173. Solved: Before Save Prompt Userform (8 replies)
  174. Solved: Counting rows? (4 replies)
  175. Excel - Data Validation Lists (2 replies)
  176. Solved: How to auto populate data from Worksheet (2 replies)
  177. AutoSum an unknown range (4 replies)
  178. Solved: Required to copy and paste a formula to a column range (2 replies)
  179. show source of value (8 replies)
  180. Save an excel file got from a '.do' script automatically (0 replies)
  181. Evaluate() to return column number (8 replies)
  182. Solved: Turn txtbox on an off (3 replies)
  183. Solved: VBA: Copy Worksheets to new Workbook & Rename Tabs from Vlookup (2 replies)
  184. Solved: Lookin for values between workbooks and get the details (2 replies)
  185. Solved: Toggle:Hide/Unhide Issue with calling a module (10 replies)
  186. Solved: Write a vba variable out to a sheet (5 replies)
  187. Need to get web page elements and info (0 replies)
  188. Problem with loop & variable values (8 replies)
  189. Excel to Internet Explorer Google Search (1 replies)
  190. Solved: Message Box in Macros with variables (4 replies)
  191. DSUM Formula (1 replies)
  192. Find cells with like values & automatically sum them (1 replies)
  193. retrieve names from external file (9 replies)
  194. Solved: Macro in a Toggle Button (2 replies)
  195. Solved: Adding Time with 30 minutes interval (12 replies)
  196. Solved: Can I use VBA or DataVal with symbols? (7 replies)
  197. Using a repeating bottom row as a footer (1 replies)
  198. Solved: Conditional Formatting on Spreadsheet (7 replies)
  199. Solved: Average Difference with Date:Time Format (10 replies)
  200. Solved: Method 'Range' of object '_Worksheet' failed when that worksheet is not active. (4 replies)
  201. Solved: Determine name of caller procedure (5 replies)
  202. Add range of rows at the last row (2 replies)
  203. Solved: Save As Pop up issue (5 replies)
  204. Solved: How to add a text column to a dynamic range using a macro (3 replies)
  205. run code after finishing web query load (1 replies)
  206. Creating strongly typed array - Is this possible?? (3 replies)
  207. End Loop after submitBtnClick (3 replies)
  208. VBA for excel (2 replies)
  209. Solved: 2 codes with ambigous names, HELP (11 replies)
  210. Challenge: Triangle Area Select tool (72 replies)
  211. Solved: Presence of a Chart Sheet causes VBA to erro (4 replies)
  212. Data Validation (6 replies)
  213. [SOLVED:] Go to next row 1st column when cell selected (12 replies)
  214. Need to compare 2 very large worksheets (6 replies)
  215. Solved: Time Sheet Help!! (9 replies)
  216. Search box within data entry form (17 replies)
  217. VBA Copy and Paste HELP (5 replies)
  218. Display an array from one field. (5 replies)
  219. Data Validation and Formatting Question (10 replies)
  220. changing sheet name and issues that go along with this... (15 replies)
  221. Retrieving pixel counts in Excel sheet charts (3 replies)
  222. Data Import MAcro (1 replies)
  223. Possible Vlookup, or Index/Match or... (2 replies)
  224. Group and ungroup certain rows in a protected sheets (6 replies)
  225. Solved: Count click events then add value to label (3 replies)
  226. Run Code after Automatic Refresh (1 replies)
  227. Solved: Sort without selecting the Sheet (9 replies)
  228. Data Validation (2 replies)
  229. Solved: DateAdd Function (4 replies)
  230. Solved: hyperlinks() syntax (1 replies)
  231. combo box -no edit (1 replies)
  232. Solved: Accumulate the values (4 replies)
  233. Solved: Fill empty cell with previous value if condition is met (11 replies)
  234. sum of different cells in 20 different workbook-sheets (2 replies)
  235. Print Macro using validated list (2 replies)
  236. Solved: Add to end of cell (2 replies)
  237. Solved: customize sort (7 replies)
  238. [SOLVED:] Move to end of data in Column in different worksheet (8 replies)
  239. Solved: Lookup values in varying locations? (8 replies)
  240. Solved: Extract hyperlink from cell and place in cell to right (18 replies)
  241. Solved: pull excel workbook into excel template (9 replies)
  242. Solved: Place Date stamp on Chart (2 replies)
  243. Check Box Formula (2 replies)
  244. Solved: case to line 1 locks up (9 replies)
  245. Formatting numbers within formulas (2 replies)
  246. Solved: Can't loop through worksheets (4 replies)
  247. Solved: Find column with a value and replace it with another column (5 replies)
  248. Executing an external application with Excel (1 replies)
  249. Manipulating Data for Graph creation (3 replies)
  250. Solved: Odd behaviour of UserForms (1 replies)