Try this:

1. Edit Move or Copy Sheets
2. Make sure the box "Create a Copy" is checked.
3. Select where you want to copy it
4. Press OK

It should create an exact copy of the sheet which you can then edit to
remove any unwanted information. After that you will need to make the
necessary links between MASTER and copy sheets. Please, get back to me
if you need more help.

Note:
Always experiment in a backup copy before doing it in your actual
data.

Regards
Juan Carlos


--
cscorp
------------------------------------------------------------------------
cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015
View this thread: http://www.excelforum.com/showthread...hreadid=376830