I would be really grateful for any help regarding the following Calc problem:
I have created a rather large workbook with over 30 different tabs representing individual suppliers (my boss asked specifically that I do not create a pivot table for this file). The file is calculating suppliers’ offers on a weekly basis. Individual offers are being entered in their respective sheets and a final sheet calculates the average price of each individual product.
The problem: not all suppliers submit an offer each and every week, sometimes we get an offer from supplier 1, 5, 8 and 10, the next week by completely different suppliers. I can find the calculated average price on the last sheet but I often need to see exactly which suppliers have sent offers. I usually find myself clicking through all 30+ sheets unnecessarily.
QUESTION:
Is there a way to automatically hide those sheets that don’t contain value OR alternatively dynamically highlight those tabs (for example by changing the tab-color) that do?
I have tried various macro solutions but wasn’t able to solve the problem.
Thank you!