changing data across all worksheets

[Chris Bauer]

I asked this question before, sort of, but here is a different way to put
it.

I have an address list that is rather large and I want to do several
worksheets, with the first being the complete list and the rest being sorted
and hiding some rows, such as duplicate entries. I want to be able to make
changes on the first worksheet and have them automatically carry over to the
rest of the worksheets, such as when someone sells their property and the
name needs to be changed. Currently I make the changes individually but that
is getting too time consuming anymore. Does anyone have any ideas, or should
I be using a different application with a Primary Key, such as Access (which
I have but know little about, always use Excel!!!)

Thanks to anyone who helps!

 

[Debra Dalgleish]

As Dave Peterson suggested last time you posted, your workbook will be
easier to maintain if you keep all the data on one sheet, and use an
AutoFilter to view specific data.
http://www.contextures.com/xlautofilter01.html

Or, use an Advanced filter to extract data to individual sheets when
required,

http://www.contextures.com/xladvfilter01.html

 

[Chris Bauer]

That may work just fine, I have other people who will use this list and I
need to make it very simple for them, VERY simple! I will try it and see
what happens. Thanks a bunch!

 

[Chris Bauer]

Your idea works wonderful, Thanks!

As Dave Peterson suggested last time you posted, your workbook will be
easier to maintain if you keep all the data on one sheet, and use an
AutoFilter to view specific data.
http://www.contextures.com/xlautofilter01.html

Or, use an Advanced filter to extract data to individual sheets when
required,

http://www.contextures.com/xladvfilter01.html