Combining Names ranges

Skybluekid

Well-known Member
Joined
Apr 17, 2012
Messages
837
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
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Skybluekid

Well-known Member
Joined
Apr 17, 2012
Messages
837
Thank you for the Reply Zot. That would be an option, can it be done using Non VBA?
 

Zot

Well-known Member
Joined
Nov 26, 2020
Messages
2,004
Office Version
  1. 2016
Platform
  1. Windows
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,825
Messages
5,766,659
Members
425,367
Latest member
Boboka

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top