How to Automate Import of Data?

BrettOlbrys1

New Member
Joined
May 1, 2018
Messages
43
Office Version
  1. 365
Platform
  1. 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?
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Misca

Well-known Member
Joined
Aug 12, 2009
Messages
1,724
I believe Power Query is just what you're after. You only have to "teach" the query once and after that it repeats the steps every time you want it to. And best of all: No macros needed.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,578
Messages
5,770,955
Members
425,653
Latest member
UNSING

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top