how to correlate two worksheets???

musman · #1 (**permalink**) 11-02-07, 09:59

Hey all,

I have an excel file. and there are so many worksheets in it. but there are two worksheets that are interelated.

1)Location

2)Building

and i may have multiple buildings in one Location.

Is there any way I can combine both of these, While not making them as a single worksheet.

any Formula i may be able to use in 2nd worksheet(Building) to refer some corresponding 1st(Location) data value?

shades · #2 (**permalink**) 11-02-07, 10:12

Howdy, can you post a simple example, a few rows/columns with what you have, and what you need.

musman · #3 (**permalink**) 11-02-07, 10:32

Yes sure

Worksheet 1(location)

Location1 Add 0 Columbia
Location2 Add 1 Charlotte
Location3 Add 3 Charleston

Worksheet2(Building)

*CountyName *CountryCode

xyz 1245

Now if thats building for Location1. How could i add the building for location2...
and I am not supposed to create a single column extra. As these worksheets are system generated with predefined columns..