Hi,
This seems fairly easy, but I haven't had much luck with searching for the answer on the web.
I have an Excel 2010 table in Sheet 1 (FYI, table has headers with 11 columns). In Sheet 2, I would like to continually reference a particular column (Column 1) and its rows from the table in Sheet 1. I would like the table in Sheet 2 to it to expand/contract rows automatically as I add/remove rows from the table in Sheet 1.
I was able to do this using a structured reference, set as an array formula. However, I'd like to avoid having to "worry" about whether or not my array selection is always bigger than the rows in the table in Sheet 1. Also, this can potentially returns a lot of #N/A's, as the array formula will return this for any blank rows in the table in Sheet 1. The #N/A's get in the way of other data sorting I'll be doing later.
Is there a cleaner way to have the table in Sheet 2 automatically update from the main table in Sheet 1, without an array formula?
Thank you, -Rich
This seems fairly easy, but I haven't had much luck with searching for the answer on the web.
I have an Excel 2010 table in Sheet 1 (FYI, table has headers with 11 columns). In Sheet 2, I would like to continually reference a particular column (Column 1) and its rows from the table in Sheet 1. I would like the table in Sheet 2 to it to expand/contract rows automatically as I add/remove rows from the table in Sheet 1.
I was able to do this using a structured reference, set as an array formula. However, I'd like to avoid having to "worry" about whether or not my array selection is always bigger than the rows in the table in Sheet 1. Also, this can potentially returns a lot of #N/A's, as the array formula will return this for any blank rows in the table in Sheet 1. The #N/A's get in the way of other data sorting I'll be doing later.
Is there a cleaner way to have the table in Sheet 2 automatically update from the main table in Sheet 1, without an array formula?
Thank you, -Rich
