Context at the bottom.
I am hoping you are able to assist me with an issue I am struggling to resolve. I have data collected in multiple separate SharePoint lists (identical structure) which can change dynamically which is causing me issues in consolidating all the data in to one table within Excel.
I have been asked to solve this as simply as possible within Excel and ideally this will work in Excel Online too. I’m not sure it is even possible but if it is I think someone here will know.
Context: I have data which is collected in a SharePoint list but I need to segregate it so that certain people cannot see certain data. This cannot be achieved through views (too easy to get around) or permissions on the individual items (too high admin). Therefore I now have multiple identical SharePoint lists which pull through into tables. However I need just one data set.
I am hoping you are able to assist me with an issue I am struggling to resolve. I have data collected in multiple separate SharePoint lists (identical structure) which can change dynamically which is causing me issues in consolidating all the data in to one table within Excel.
I have been asked to solve this as simply as possible within Excel and ideally this will work in Excel Online too. I’m not sure it is even possible but if it is I think someone here will know.
Context: I have data which is collected in a SharePoint list but I need to segregate it so that certain people cannot see certain data. This cannot be achieved through views (too easy to get around) or permissions on the individual items (too high admin). Therefore I now have multiple identical SharePoint lists which pull through into tables. However I need just one data set.
