linking between worksheets, possible?

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

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