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

--

Regards,
Nigel




"Chris" wrote in message
...
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 a

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 ***