Copy cell values across separate sheets

C

claytorm

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.
 
B

Bill Kuunders

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
 
C

claytorm

Bill,
Thanks for the reply. It's not really what I'm after - I probably
didn't make it clear. Each row in the main sheet corresponds to a
different sheet in the workbook. So if Col A in the main sheet read:

ABC
ASR
CFT

Sheet 1 would contain ABC in A1, Sheet 2 ASR in A1 etc.

Bertie.
 
B

Bill Kuunders

Hope you don't have too many cells on the main sheet.
in sheet2 enter in A1........=sheet1!A2
in sheet 3 enter in A1.......=sheet1!A3

Or you can use the mouse.
start in the destination cell.......enter = and go to the main sheet
....click onto cell A2 or A3 etc
Regards
Bill K
 
Top