Hi! Sorry, I don't completely realize the undertaking. make sure you explain your specific challenge or deliver extra details to be familiar with what you need.
You can not make named ranges in Excel for the online, https://anniexjmh156772.pointblog.net/the-5-second-trick-for-excel-online-69529312