changing data across all worksheets

  • Thread starter Thread starter Chris Bauer
  • Start date Start date
C

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!
 
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!
 
Back
Top