Hello,
Need help understanding why a formula referencing a table is changing. Here is the situation
There is a Table called Table1 with headers in Sheet1. In sheet2, there is a column with formula =Table1[@ShoeType]. I am trying to pull data by row from Table1 under a column called ShoeType. A Macro opens and pastes data from a separate workbook into Sheet1. Everything worked as desired for a few weeks then I noticed the formula in Sheet2 changed from =Table1[@ShoeType] to =Table1[@ShoeSize]. ShoeSize is another Column header for a different column in Table1.
Why is this happening and can I prevent it from changing?
I would like the formula to only return values by row under column titled ShoeType regardless of where the column appears in the table.
Thanks
Bookmarks