BrettOlbrys1
Board Regular
- Joined
- May 1, 2018
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
I have my file which contains lots of sheets, but only one DATA sheet drives everything.
That one DATA sheet is external data that I manually import into my DATA tab, which then drives the rest of the sheets. That one import file sits on a SharePoint site (which gets updated daily), and I was wondering if there was a way for me to click a button within my Excel file that would grab the file, read the data, and then import it to my data sheet? Basically, I want to automate the process...is this possible and if so, how do I do that?
That one DATA sheet is external data that I manually import into my DATA tab, which then drives the rest of the sheets. That one import file sits on a SharePoint site (which gets updated daily), and I was wondering if there was a way for me to click a button within my Excel file that would grab the file, read the data, and then import it to my data sheet? Basically, I want to automate the process...is this possible and if so, how do I do that?