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.
|