R.P.McMurphy Wrote:
I have a list of staff in sheet one, column one. how can i get excel
to
keep sheet two, column one the same, even if changes are made to sheet
one
column one?

steve

Hi Steve

Go to Sheet2 first cell where you want the data from Sheet1, type = ,
go back to Sheet1 and click in the first cell of the names column,
probably A2, and enter

Then drag down the formula


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399821