Thanks, i'm trying that out right now.

I don't know if there is a simpler way of doing things or even if this
is possible at all but is there a way of creating a sheet for
individuals in which each person has a code or id. The surname, first
name and salary are all linked to this id.

On a separate worksheet, i would like to create a system whereby i
would enter the unique code and the relevant surname, first name and
salary would all automatically appear in the subsequent vertical
columns.

Am i being over ambitious and does a feature even exist without major
work having to be done?

Thanks


--
El Shish
------------------------------------------------------------------------
El Shish's Profile: http://www.excelforum.com/member.php...o&userid=37710
View this thread: http://www.excelforum.com/showthread...hreadid=573007