Ok, I have my first sheet named 'List' with a list of names on in in
cell c3 downwards. The workbook also contains several other sheets
after the first one with a template on each and an empty cell ('C3') on
each.

How can I copy a value from the top of my list on my sheet named 'list'
onto each sheet which follows it and moving down the list at the same
time.

so the list would read: tom smith
bob brown
steve simmons

and sheet one after the list sheet would end up with 'tom smith' in
cell ('c3') and the next sheet along would end up with bob brown in
cell ('c3') etc..

I know I can use a For Each method here but I need a wee bit more help
in phrasing it.

Cheers

H


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