View Single Post
  #5   Report Post  
Tom
 
Posts: n/a
Default

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