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

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?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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

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 wrote:

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?

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

--

Dave Peterson

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

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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

You're welcome.

Debra did nice work.

srfrost wrote:

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

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

--

Dave Peterson