Macro to create reporting

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

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets - Part 1

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.

=================

Based on your sample sheet, you only need to edit this:

Please Login or Register  to view this content.

Now the sheets that are created are normal layout. I simply used the macro recorder to record myself formatting a page the way you wanted, then added that code to the section that creates a new page when needed.

Please Login or Register  to view this content.

Those are the only edits needed, the rest of the code will work as given.