hey everyone,
i doubt this is possible
but is there way to to have sheet 1 AE3 influence sheet2 P4:Y4 and clear out anything listed under Low risk Breach.
i was thinking that if sheet1 AE3 turn green, is it possible to clear sheet2 P4:Y4 of any data
back story: Basically data in Sheet 1 are the amount of times that individual breach happened through 25 audits, and Sheet 2 is just counting the number of breaches them selves. so 1 breach could have occurred in 25 audits for that company (E.g. in 'Sheet2' - technical error 7 ( is one breach company A received), but in 'Sheet1' - technical error 7 occurred 25 times in company A
so bascially if there is 3 or less in Sheet1 AE3, i would like everything in sheet 2 P3:Y3 (low risk area) to clear data and recalculate Sheet2 Z3 (total) based on left over data.
example attached
ive also added a dummy solution if anyone is confused- hard for me to explain without showing what is suppose to happen
thankyou again
-
Bookmarks