So unless you clear the old values, when you re-run the code it will only append to what is already there.More details about yur workbook are needed to go any further. (DO NOT choose "Class Module") Copy the entire code from "Sub Make Summary Table()" to "End Sub" and paste this into the code window. If you want, you can create a button from the Forms toolbar and assign this macro to the button.You can use the Worksheet Function property in Excel VBA to access Excel functions. For example, place a command button on your worksheet and add the following code line: When you click the command button on the worksheet, Excel VBA calculates the average of the values in cell A1 and cell A2 and places the result into cell A3. You can manually recalculate the workbook by pressing F9. In most situations, you will set calculation to automatic again at the end of your code. To insert the formula itself into cell A3, use the following code line: Sometimes you may find it useful to disable screen updating (to avoid flickering) while executing code. You can instruct Excel VBA not to display alerts while executing code. For example, place a command button on your worksheet and add the following code line: When you click the command button on the worksheet, Excel VBA closes your Excel file and asks you to save the changes you made. To instruct Excel VBA not to display this alert while executing code, update the code as follows. As a result, Excel recalculates the workbook automatically each time a value affecting a formula changes.I am wanting to make a table that shows values from multiple sheets.
I have to open each one and copy the data into a single workbook. example: DIST_91124_GROWTH_PRODUCT XXX _07072006The 07072006 is the week ending date and will change. Is there a way to automate this process, it takes me about 4 hours to do it manually. Are there any other files in that directory that aren't part of equation? All the files have to be copied into the same workbook each below the previous copy.The DEL95HTMLempty Cells is designed to clean up the mess that Excel 95 creates when pasting from a web page into Excel.My experience with pasting Excel 95 was that instead of continuing a row across it also frequently jumped down a row besides for what should have been on the same row.Thankyou, I'll try to figure out how to use that code. It doesn't run when I use your code and all I copy is a blank sheet.What code do I need to insert to ensure the macro runs on startup?