I need to create a macro that will:
- take the master sheet and break out the data into a sheet for each supplier
- when the other tabs are generated, the generation date and the header are listed as they are on the example
- automatically to landscape and scale to 11x8.5" print size
Not sure if I am asking too much or if I would need to run mulitple macros. I can't seem to get some of the other examples listed in the forum to work for me just to seperate the data into individual sheets (because I'm very new to macros!). Learned a lot here so far today though!
I appreciate any help in advance!OldStockReportSample.xlsx
Bookmarks