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

Or:

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


Kennedy wrote:

Wondering what the best way is to move data from one sheet to several other
sheets, based on the value that is in the first column.
Working with several rows/columns of data. Each row contains several pieces
of data, with the first column being the important piece in determining where
the data goes. Sample below:
A B C D E
1 Ford Fusion Red 4 Door Manual
2 Toyota Camry Black 4 Door Auto
2 Ford Mustang Grey Conv Auto
4 Honda Accord Blue 4 Door Auto
5 Chrysler Sebring Red Conv Manual
6 Honda Civic White 2 Door Auto
7 Toyota Avalon Red 4 Door Auto

I have individual tabs for each car, so one for Chrysler, Ford, Toyota,
Honda. Need to find a way to move the data from the consolidated sheet to the
individual sheets. With all of Chrysler's data onthe Chrysler tab, Ford on
the Ford tab, etc...
Thanks for any assistance, novice at this.

--

Dave Peterson