I am trying to create a workbook for a weekly customer report.
The problem I have is that I have 9 customers but within these 9 customers require tabs for week ending dates. Is this possible to do it from the one workbook or will I have to create several workbooks for the dif customers then some how create a drop down menu that will open each of the customers workbooks.

Does anyone have any idea how I would go about this and the easiest way of doing it

Thanks in advance

Well, I would do it like this, all records that occurred in a certain week, regardless of customer, would be in the same worksheet. I would then develop a macro that used the Advanced Filter command to copy those I wanted for the report to another location, print those out, and continue with the next batch of records.

I would do that but im not sure on 100% sure on VBA or macro so i think i would strugle a little on that one