Skip to Content
0
Former Member
Jun 20, 2007 at 01:23 AM

How to automate the creation of this workbook?

8 Views

Hi

I generate the same report for 3 departments at the end of each day and would like to place them in a workbook as 3 worksheets and a fourth worksheet (tab) as the total of the three tabs.

How best can I automate this process so that the formatting (colors, etc) will remain the same.

Please provide detail steps if possible.

Thanks