Stop relation between two sheets

[Dipwind]

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

[Bryan Hessey]

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

Hi,

Probably can, would you like to post a sample few formula for a more detailed reply, especially the 'If' formuula?

---

[Dipwind]

Sorry my late reply,

I'm using this formula:

=IF(A8=PR!$B$3,PR!$D$3,IF(A8=PR!$B$4,PR!$D$4,IF(A8=PR!$B$5,PR!$D$5,IF(A8=PR!$B$6,PR!$D$6,IF(A8=PR!$B$7,PR!$D$7,IF(A8=PR!$B$8,PR!$D$8,IF(A8=PR!$B$9,PR!$D$9,IF(A8=PR!$B$10,PR!$D$10,0))))))))

In the seven sheets from the week, I only need to put a number and part of the information comes from "Principal" but if I need to add more people on principal, I can't put more ifs in the same cell.

thanks in advance
joćo

[Bryan Hessey]

Sorry my late reply,

I'm using this formula:

=IF(A8=PR!$B$3,PR!$D$3,IF(A8=PR!$B$4,PR!$D$4,IF(A8=PR!$B$5,PR!$D$5,IF(A8=PR!$B$6,PR!$D$6,IF(A8=PR!$B$7,PR!$D$7,IF(A8=PR!$B$8,PR!$D$8,IF(A8=PR!$B$9,PR!$D$9,IF(A8=PR!$B$10,PR!$D$10,0))))))))

In the seven sheets from the week, I only need to put a number and part of the information comes from "Principal" but if I need to add more people on principal, I can't put more ifs in the same cell.

thanks in advance
joćo

HJi,

Try

=IF(ISERROR(VLOOKUP(A8,pr!$B$3:pr!$D$10,3,FALSE)),0,VLOOKUP(A8,pr!$B$3:pr!$D$10,3,FALSE))


You can then extend the range.
---

[Dipwind]

That's great, works in a perfection.

many thanks Bryan
Joćo

[Bryan Hessey]

That's great, works in a perfection.

many thanks Bryan
Joćo

Good to see, and thanks for the response.

---