skeeeter56
New Member
- Joined
- Nov 26, 2016
- Messages
- 42
- Office Version
- 2019
- Platform
- Windows
Hi all not sure if this is even possible, but I have a Sharepoint List of all staff Details. I created a query from this into Excel, this all works correctly updates if something has changed in the Sharepoint list.
What I need to be able to do is have sheets that present this data in different ways.
For example some staff work nightshift same day need to be able to have separate list of each.
I currently have 4 different query's, which has created 4 sheets. One of these sheets has the complete data form the Sharepoint list, the others I have filtered in power query.
Is this the best way to do it, or can I get the data from the sheet that has the complete data.
So that would only have connection/query as opposed to 4 that I currently have.
If someone can offer there wisdom in the best way to go.
What I need to be able to do is have sheets that present this data in different ways.
For example some staff work nightshift same day need to be able to have separate list of each.
I currently have 4 different query's, which has created 4 sheets. One of these sheets has the complete data form the Sharepoint list, the others I have filtered in power query.
Is this the best way to do it, or can I get the data from the sheet that has the complete data.
So that would only have connection/query as opposed to 4 that I currently have.
If someone can offer there wisdom in the best way to go.