Moving data from one sheet to another

[Kennedy]

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.

 

[a4d0]

Kennedy,

I would recommend inserting a blank row above all of the data. Type in the
following column descriptions, or make up your own,
A B C D E
Make Model Color Doors Drive

Highlight those column descriptions and then select the auto-filter option.
It's on the far right on the "Home" tab if you are using Excel 2007 or Data
menu > Filter > Auto-filter if you are using Excel 2003. This will put
little drop-down arrows in the columns next to each column description.

Then, just click on the drop-down for the "Make", select, say, "Ford". This
will display only the "Ford" data. then you can highlight or select the
filtered range. After the range is selected, press the "F5" key or navigate
to Edit menu > GoTo. This will bring up the GoTo pop-up. Click on the button
that reads "Special"; click on the radio button that reads "Visibly Cells
Only"; then click "OK." At this point you can click CTRL + C to copy the
cells and paste them onto the "Ford" tab.

Only the "Ford" cells will be copied because using auto-filter on the first
column for Ford and using special to select only the visible cells allowed
you to grab only the records displayed on the screen, in this case the
"Ford" rows.

Hope that helps,

Ryan

 

[Dave Peterson]

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