Telephone and Floor Plan help please

[Chris]

Hello, I am trying to link telephone contact details on one worksheet
(Named: Contact Details) to Desk Positions on another worksheet (Named:
Floor Plan) in the same Excel 2003 workbook.

The worksheet (Named: Contact Details) is a simple list with column
headings in row 1. The column headings are:

Column A: Title
Column B: First Name
Column C: Last Name
Column D: Full Name (using concatenation of B and C)
Column E: Phone (Work)
Column F: Location (work)
Column G: Position
Column H: Sub Section
Column I: Directorate

I am trying to link in the following order: (Position, Title, Full Name
and Phone) to worksheet (Named: Floor Plan).

For example: in worksheet (Named: Floor Plan), there is a desk at cell:
H2.

Cell H3 ='Contact Details'!G127 ---(Position)
Cell H3 ='Contact Details'!A127 ---(Title)
Cell H3 ='Contact Details'!D127 ---(Full Name)
Cell H3 ='Contact Details'!E127 ---(Phone)

When I either add, delete or sort the worksheet (Named: Contact
Details), then the Position, Title, Full Name and Phone details change
in the worksheet (Named: Floor Plan).

I tried to use both absolute and relative cell references, but this did
not help.

Is there a way in which I can link both the worksheets (as described
above) and still be able to add, delete or sort worksheet (Named:
Contact Details)?

Any assistance in this matter would be greatly appreciated.

Kind regards,

Chris.



*** Sent via Developersdex http://www.developersdex.com ***

 

[Nigel]

Establish a key in both workbooks (the data that links both entries) and use
VLOOKUP to map the data

 

[Chris]

Hi Nigel, thanks for your reply - much appreciated. You suggested that
"Establish a key in both workbooks (the data that links both entries)
and use VLOOKUP to map the data" .

Please note that there is only one workbook and contained within it are
two worksheets. Worksheet (Named: Contact Details) and worksheet
(Named: Floor Plan).

I tried to "Google" establishing a key in both worksheets, but could not
find any information.

Could you please advise how i can do this?

Also, could you please advise on how I can use VLOOKUP to map the data?

Any assistance is greatly appreciated.

Kind regards,

Chris.



*** Sent via Developersdex http://www.developersdex.com ***