Auto populate and expand table from range on another sheet

Brass Contributor

I am trying to automatically populate and automatically expand a table with data from a range in another sheet.


Each week new data is added to the master sheet from a production report, I would like the separate table to automatically fill and expand as data is added to the master sheet. 


I figured using a named range with an offset column reference could work, but not sure the table will auto expand?


Is it possible to do this? I feel like I am missing something simple.



2 Replies
In what way is the table different from the table on the master sheet?
The master sheet isn't a table, it contains data that gets added from a CSV report each week.

The table on the other sheet has helper columns such as DAY and MONTH, batch number, etc... This table is then used to populate a printable calendar.