#1
|
|||
|
|||
How to connect multiple excel files through eConnect
The company I work for has multiple locations and each one of these uses their own spreadsheet(s) for PO's that I access from the corporate office. In order to avoid having to go into each spreadsheet for each club individually, I'm trying to connect them all to my spreadsheet where I can do a 3 way match for AP. So far I've tried everything I can find via google search and youtube videos and have come up empty, so I'm hoping the bright minds helping people out in the forums can help me too. Thank you. |
#2
|
|||
|
|||
????
Is this just not possible? Everyone seems to be stumped on this, but I have a hard time believing it's not possible to do this.
|
#3
|
||||
|
||||
Have you watched any youtube video tutorials on Excel's Power Query?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#4
|
|||
|
|||
no, not that specifically. I'll try that, thank you!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merging multiple CSV files into a new EXCEL workbook | Alex99 | Excel Programming | 2 | 10-30-2017 03:34 PM |
Unable to open multiple excel files | aceinfocomservice | Excel | 1 | 09-07-2017 04:05 AM |
searching for text in multiple excel files | roytom | Excel | 2 | 07-30-2012 01:57 PM |
convert multiple csv files to multiple excel files | mit | Excel | 1 | 06-14-2011 10:15 AM |
Opening multiple Excel files within the same Excel window. | lost9471 | Excel | 2 | 05-01-2010 01:57 PM |