Hide tabs with no entries

asked 2019-11-05 21:18:07 +0100

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!

edit retag flag offensive close merge delete

Comments

It sounds like you are not specifically looking for a way to hide tabs, but to see somewhere at a glance which supplier data is not present this week. I would probably approach this by a summary list or table, either on the final summary tab or as its own penultimate procedural review tab.

sansdomino gravatar imagesansdomino ( 2019-11-06 23:40:04 +0100 )edit