Combining Names ranges

[Skybluekid]

Hi All,

I have a workbook which holds data for 8 regions, each on a separate tab. This workbook is on a sharepoint site, the file can be worked on by multiple people, and they are all on 365. I have been asked to create a master sheet which will hold all the data from each of the 8 sheets. Normally, I would have table on each sheet, then combine the tables in Power Query to create the master sheet. As far I am aware, this does not work on a sharepoint document(??). Is there a method to combine names ranges into a single range?

Thanks in Advance

 

[Zot]

Will this works?

Refer to Multiple Ranges

Office VBA reference topic

docs.microsoft.com

 

[Skybluekid]

Thank you for the Reply Zot. That would be an option, can it be done using Non VBA?

 

[Zot]

Do you mean to create a single name for combinations of all named ranges? Then
1) Open Name Manager (Ctrl+F3)
2) Click New to give new name
3) In Refers to: just type =Name1, Name2, Name3, etc (Name1, Name2, Nme3, etc are named ranges)

You now have a single name to refer to all those named ranges.

 

[Skybluekid]

Thank you, Zot. I was not aware you could do that!