Hi,

There is any way to stop, the relation between a sheet to other sheet?

I have a sheet "principal" where I have data that can be until 150 different names. In the same workbook I have more seven sheets representing the week days, all the seven sheets are related with "principal" but I only can use 8 "IF's". Normally on the third day I need to change the principal to fill automatically the week day's sheets.

In the end I generate a report, with wrong data, because when I change the "principal", the day one and day two, is also changed.

Can I say to a sheet "with a function or formula", to stop relate with principal, something like "complete and close"????

thanks in advance
Joćo