In the cell where you want this formula, type an equal sign, with the mouse
select the source sheet,
click in the first cell (A2) and press enter key
now grab the lower right corner of the cell where you put the formula and
when it changes to a thin cross and left click the mouse and drag down (copy
down)

--
Regards,

Peo Sjoblom

(No private emails please)


"r.p.mcmurphy" wrote in message
...
Is that type '='

or type'=,'?

remember....im a newbie!

steve

"Paul Sheppard"
wrote in
message news:Paul.Sheppard.1uh3yb_1125230704.4134@excelfor um-nospam.com...

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