Copy cell values across separate sheets
 

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

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

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.


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

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

"claytorm" wrote in
message ...

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.


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