Hi Guys,
i want to have named range Table1_Headers = [Var_Column1, Var_Column2...] - all headers from Table1.
Var_Column is variable for specific column within table.
I want to have reference to this specific column but when user will change the name of header- still i should have reference to data in Var_Column1.
Example:
Var_Column1 = Data for [Name] column (table column name)
User changed [Name] to [Surname].
Var_Column1 = Data for [Surname] column
And second issue - what if user will change order of column.
If in the Excel there is some kind of tag which i can add to column or cell?
Best,
Jacek
Bookmarks