Autocopying data from one sheet into other sheets

[Bob]

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.

 

[Dave Peterson]

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Bob]

Dave,
Thanks for the info. This is exactly what I need.

Bob