I have sales data that is 12 columns across in one spreadsheet. I would like
to autocopy this data into other spreadsheets based on the sales reps name so
that each rep will have his own spreadsheet. Is there a formula that I can
use in the blank spreadsheets that will copy the data from the main
spreadsheet?

Thanks.
--
Bob