Hello to all, newbie here.
I just want to ask if excel can dynamically/automatically adjust the number of rows of a table based on the countif data i collected from other sheet?
By default I have 5 rows (and 10 columns) on my Table with all the necessary formulas in each row. Everyday, we are expecting more than 100 entries in the table so I want the table to auto adjust based on the actual count.
Any help/ideas will be appreciated. tia
Bookmarks