Clear fields for some tabs, keep some fields for other tabs
Situation:
Multiple sheets having certain relation to each other. To illustrate: sheet 1,2,3 are related, sheet 4 is unrelated, sheet 5 and 6 are related with each other and to top it off, sheet 7 is partially related to 1,2,3.
Goal:
When moving to another related tab fields should stay selected. When moving to an unrelated tab fields should be cleared. When moving to a partially related tab 5 fields (of the 100+) should be kept selected. I saw this thread: