Forum Discussion
after Sort assigned NAME column & row didn't move with data
using COL A thru E. I assign a NAME (EU_Holidays) to Cols D & E rows 52 to 68 (='Holidays Tables'!$D$52:$E$68). I assign two more NAMES (NA & AP) using other Rows. I sort Col A-F to get the holid...
Name keeps reference on cell range, not on values within it. For the Name it doesn't matter which values are within the range and how they are sorted. You may create few separate Tables instead and use reference on such Tables columns.