sort data by name in first column and copy to individual worksheets by name

[srfrost]

Does anyone have code handy to sort data into various categories by the
type of data specified in column 1 and then copy the respective data
into predefined worksheets with the same category names?

 

[Dave Peterson]

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

 

[srfrost]

I'm impressed; exactly what I was looking for. Thanks, Steve

 

[Dave Peterson]

You're welcome.

Debra did nice work.

I'm impressed; exactly what I was looking for. Thanks, Steve