Nothing built into excel (except for the formula you showed).

But I'd be very hesitant to separate my data. I'd do my best to keep all the
data on one worksheet.

You can use Data|Filter|autofilter to get different "views" of the data.

You can use data|sort, too.

But by splitting the data (even worse automatically), it could be very difficult
to track down typing mistakes.

If you want to split the data from one worksheet into many based on a column,
then both Debra Dalgleish and Ron de Bruin may have solutions for you:

Debra'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

or

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

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



lucasjackson wrote:

New question:

I know now how to use "=sheet1!a1" to copy cells from sheet 1 to sheet 2,3
etc.

Is there is a formula that will allow me to enter data
into sheet 2, and have it copy automatically into sheet 1 and 3, or into
sheet 3 going to sheet 1 and 2? So that I can enter the data into any sheet
and have it transfer to all sheets, rather than always from sheet 1 to sheets
2 and 3.

--

Dave Peterson