Sep 21 2023 03:11 PM - edited Sep 21 2023 03:12 PM
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
Sep 22 2023 02:17 AM
Sep 22 2023 12:20 PM