You might find what you want at Debra Dalgleish's site:

http://www.contextures.com/excelfiles.html
Look for:
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



"Who B. Askin" wrote:

Hi

I have an Excel sheet with customers data and I want to copy each row
to the corresponding sheet according to the value of the "customer"
column, so that all rows for customer 1 would be copied to "customer
1" sheet, all for customer 2 would be copied to "customer 2" sheet,
etc.

I considered making links and using filters, but the data sheet will
grow every day and I don't want to go making links for the new rows.

I want to write a script to do it automatically, either the links
creation or just the row copying.

Could you show me a little example of code of how to do this?

Thank you very much!

Oscar.

--

Dave Peterson