copy and paste text to entire workbook

R

Rico

Can anyone tell me how to copy cells on one sheet and
then paste to the entire workbook without going to each
sheet to paste?
 
D

Dave Peterson

Copy your range.
Group the sheets in the new workbook and paste to all the grouped sheets.

You can click on the first and ctrl-click on subsequent to group some.

You can rightclick on a worksheet tab and "select all sheets", too.

Make sure you ungroup when you're done. Any change to a grouped sheet will be
on each of the grouped sheets.

(Just rightclick on a grouped worksheet tab and select ungroup sheets)
 
Top