copy data in one sheet to multiple sheets in same workbook
 

I want to copy the data and format in sheet1 to sheet2-20 in the same workbook.
I didn't find it in the help or in the online help.
Thanks

Highlight the whole of Sheet1 by right clicking the empty box at the top
left next to Column A and Row1, select 'Copy'
Open Sheet2, hold down Shift and then click Sheet20,
Right click the same empty box and hit 'Paste'
Note that the sheet tabs need to be in numerical order to do this in this
way, or at least, Sheet1 needs to be first or last,
Regards,
Alan.
"BrianMultiLanguage" wrote in
message ...
I want to copy the data and format in sheet1 to sheet2-20 in the same
workbook.
I didn't find it in the help or in the online help.
Thanks

Right click on the sheet name and select "move or copy", click the
checkbox for "copy". Then select "move to end" in the box. For the
second round, hold the CTRL key and select both sheets and do the same
thing, then you have 4 sheets. Then 8, 16, and grab 4 more at the end.
You can do this in less than a minute for all sheets :-)


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=390685

Oops...may have read your question too fast.

To copy 1 sheet to many, copy what you want, then hold CTRL and click
on the destination sheets and paste your data. Be sure to click on a
non-selected sheet when your done or any subsequent changes you make on
a highlighted sheet will be made to all sheets you have highlighted.

Hope it helps...


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=390685

Brian,

Select the area you want to copy on sheet1 and hit ctrl c, then
highlight sheets 2-20 by selecting sheet 2 then holding down your shift
key and selecting sheet 20. Go back to sheet 2 and paste your data.
It will paste it onto all the highlighted sheets. Make sure that afer
you paste the data, you select a aheet that is not highlighted to
ungroup your sheets. Otherwise any changes you make on one will be
made on all of them.

Tom

BrianMultiLanguage wrote:
I want to copy the data and format in sheet1 to sheet2-20 in the same workbook.
I didn't find it in the help or in the online help.
Thanks