Hi everybody,
I already got a lot of help with my excel files here, it’s a great forum!
I´m totally new at VBA, please keep that in mind
I have 4 tables (one for every quarter) that fetch information from a main table. Due to a probability-function (50%,70% or 85%) that I use, the tables could have 50 or only 5 rows. For example:
The main table has 50 projects in Q1 that have at least 50% probability of becoming an order. The Table for Q1 therefore needs at least 50 rows.
If I choose only to see the projects that have 85% probability of becoming an order I might see only 5projects in Q1. That means 45 rows could be shown empty, which would look a bit silly
Is it possible to have flexible tables depending on how many rows the table need in that moment (how many projects I choose to see)?
I added a file that might help to explain my situation a bit more.
Thanks a lot!
Best Regards,
Telgus
Bookmarks