tieing copies together

D

dkb43

I set up a master file on an Excel Spreadsheet. Within one workbook I make
copies of the master, but need to do several variations of that master. Is
there a way, when I make the copy, to keep the worksheets tied together, so
that when I make a change on the master spreadsheet that same change will
also take affect on the copies of the master?
Currently, I am having to make the change to each copy of the master.
 
P

Pete_UK

You can group all sheets together (right-click on a sheet tab then
select from the dialogue box), and when you do this then a change to
one sheet will be reflected in all the other grouped sheets. Be sure
to ungroup the sheets afterwards, though (right-click a sheet tab
again).

Hope this helps.

Pete
 

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.

Ask a Question

Top