Forum Discussion
Auto populate and expand table from range on another sheet
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.
TIA
- 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.
