Share via

Pulling Information from multiple Excel docs to a master excel doc all in Onedrive

Anonymous
2025-02-13T04:02:21+00:00

Hi,

I know this has been asked probably a million times but wanted to see if there has been any changes with 365 to the work flow.

Scenario

I have multiple territory sales pipelines in Excel all in my OneDrive, I also have a Master Pipeline Excel in my OneDrive. What is the simplest way to exact data from the territory sales pipelines to populate my Master Pipeline all in OneDrive, ideally all automated from the Master

Thanks in advance

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2025-02-13T06:06:54+00:00

    If you are using OneDrive for Business. You can use get data from sharepoint folder. Then combine them using Power Query.

    Power Query SharePoint folder connector - Power Query | Microsoft Learn

    Was this answer helpful?

    0 comments No comments