Keep your data in one worksheet.

Then use data|filter|autofilter to see the states that you want.

But if you really, really must. Keep the data in one worksheet and refresh the
states worksheets whenever you need (not while doing input--just run the macro
when you're ready).

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

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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm



KurtB wrote:

I have a long list of people by location, Fname, Lname, age:
Ohio, Tom, Smith, 12
Indiana, John, Johnson, 5
Ohio, Erica, Thompson, 40
Arizona, James, Simpson, 24

The list is currently in excel and I am frequently adding people to
the list and would like to keep the master list while being able to
see each location on a separate tab. So I want an Ohio tab, an Indiana
tab, and a Arizona tab.

Is there an equation or other way so I only have to add this
information to the master tab and can automatically see it reflected
in the state tab. I am trying to avoid doing double entry workand
using Access. Each state tab has a slightly different format so using
the filter won't work and I also need the master list.

Thanks in advance for the solution.

--

Dave Peterson