Forum Discussion
Pulling Data From ~300 Individual Sheets Onto a Master Sheet
Any all all help is appreciated! I’m operating out of a company SharePoint, as multiple people need to be able to access these sheets. I want to have a Master sheet, that tracks information from ~...
Each individual site portfolio has a ton of information, much more than what I want displayed on the Master sheet. With how much information in on each site portfolio, the data I want to pull is “all over the place”. Any advice on how to consolidate dispersed data into a single row using power query would be excellent.
That sounds to me that your site portfolios are not structured. So, the first step is to get a structure.
Using VBA:
VBA does not work in the browser.
The problem is the data points only update when I “Open in Desktop”. If I edit a data point in a site portfolio while in Sharepoint, nothing gets updated on the Master.
When you "open in desktop" you are still accessing the file from Sharepoint,
The difference is the environment. One runs in Windows, one runs in a browser.
From the MS support site:
Note: Excel for the web the HYPERLINK function is valid for web addresses (URLs) only.