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.


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


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