Jun 19 2007, 08:16 AM
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
Jun 19 2007, 08:21 AM
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.
Jun 19 2007, 12:20 PM
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