i = 0
for each cell in selection
i = i + 1
cell.copy Worksheets(i).Range("C3")
Next

--
Regards,
Tom Ogilvy


"Hru48" wrote in
message ...

Okdookie, I have a list of names on my first sheet (list) and several
sheets after it (1,2,3,etc). How do I get the first value in the list
to copy into sheet 1, the second value to copy into sheet two and the
third value down to go into the thrid etc..?

Say into cell C3.

Any Ideas welcome

Cheers

Hayley


--
Hru48
------------------------------------------------------------------------
Hru48's Profile:
http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=471404