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)
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
