linking between worksheets, possible?

[Chris Bauer]

I have a large list of property owner data that we need to look through
regularly and I would like to copy the list on different worksheets and sort
it by different parameters, such as by TMP #, by Last Name, by Street
Address, etc. What I don't want to do is have to change each worksheet
whenever a property changes hands. Is there anyway to link between the pages
so that changing one will change the others automatically? Thanks for the
help!

 

[ryanb.]

If you use one sheet as your primary data sheet, then using vlookup or
index/match will do what you need it to do (assuming each property has a
unique field). You can also link directly to specific cells or name cells
or ranges, but I feel what you are looking for can be done by using excel's
vlookup function (if your data is organized correctly) or index/match. It
would help if you posted 3 or 4 sample rows of data and then explained
exactly how you would like to sort the data on the additional sheets.

ryanb.

ex.
on data sheet:

A2= 965 1st Ave
B2= Chicago
C2= IL
D2= 60001

on sort by city sheet (sort by column B)
A1=Property
B1=City
C1=State
D1=Zip

A2= 965 1st Ave (type this in)
B2= vlookup(A2,'data sheet'!$A$2:$D$500,2,false)
C2= vlookup(A2,'data sheet'!$A$2:$D$500,3,false)
D4= vlookup(A2,'data sheet'!$A$2:$D$500,4,false)

 

[Chris Bauer]

My data is organized like this:

A1= Municipality code
B1= Map region code
C1= Parcel number
D1= Sub-parcel number 1
E1= Sub-parcel number 2
F1= Last name
G1= First Name
H1= Corporation owned code
I1= Street address number
J1= Street name
K1= City
L1= State
M1= Zip code
and it continues with property specifics through column W

I want to sort by Last name and Street address on the additional worksheets.
On some of the sorted worksheets, I will be hiding or deleting unneeded
columns. Basically, I will only be changing F1, G1, and maybe I1-M1 if the
new owner resides somewhere else. The rows would have to remain intact but
obviously be sortable. I think this can be done in Access, but I am very
unfamiliar with Access. Anyway, thanks for the help!!!!!!!!!!!!

 

[Dave Peterson]

I wouldn't separate my data into different worksheets.

Maybe you could
select your range
apply data|filter|autofilter

Then you could use those dropdowns to show just the data you're interested in.