Large amt of data needing to be split onto diff tabs

Sure, this can be done fairly easily. Why dont you upload a sample file with some dummy data?

To Attach a File:

1. Click on Go Advanced.
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button

You put the code in the code window. When you save your excel file, the code will get saved. Alternatively, you can click on the floppy disk icon in the code window itself.

For this particular report, you do not need to copy the code over again. You can just use it directly.

Your statement brings me to this question - if you have run this macro once and want to run it again on the same report with more data, do you want the contents of the tabs to be deleted and fresh data input? Or should the data be input at the base of the existing data in each tab?

If you want to use this macro for other reports, you might have to change a few things depending on the report. If the layout of the other reports is the same as the existing report, you can go ahead and use it.

once I create the following weeks report and open with Excel, I will need to run the macro again. I don't know if this macro can be in Excel, available for the next run of the same report. What I did to get around this is open the report that was already run with this macro as well as the newer report. If they are both open, I can run a macro from all open docs which will run the macro into the new report.

Yes you can do it.

As long as this line

Please Login or Register  to view this content.

does not have a workbook name before it ..for e.g

Please Login or Register  to view this content.

, then you can use it with any workbook. It will always run on the data in the 1st sheet. You can change that to whatever you want to customize it like

Please Login or Register  to view this content.

You can also have this macro in an independent macro file which you can use to save all your macros.

how can I save it in an independant file. If I create a new file, how can I run the macro without having to open the last file with it?