one: copy the cells
two: group the sheets you want to paste to by holding control button and
clicking
onto the sheet tabs
three: paste into one of the grouped sheets
four: ungroup the sheets by right clicking onto one of them and selecting
ungroup sheets.

Greetings from New Zealand
Bill K
"claytorm" wrote in
message ...

Hi

I currently have a Main sheet with a list of cell values in Col A e.g
ABC, ADF, AVD etc. I want to copy these to cell A1 in sequential sheets
in the workbook. Any ideas?

Thanks,

Bertie.


--
claytorm
------------------------------------------------------------------------
claytorm's Profile:
http://www.excelforum.com/member.php...o&userid=11610
View this thread: http://www.excelforum.com/showthread...hreadid=382352