Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-29-2022, 11:07 AM
mmccollum mmccollum is offline How to connect multiple excel files through eConnect Windows 10 How to connect multiple excel files through eConnect Office 2010
Novice
How to connect multiple excel files through eConnect
 
Join Date: Aug 2022
Posts: 4
mmccollum is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 08-29-2022, 02:04 PM
mmccollum mmccollum is offline How to connect multiple excel files through eConnect Windows 10 How to connect multiple excel files through eConnect Office 2010
Novice
How to connect multiple excel files through eConnect
 
Join Date: Aug 2022
Posts: 4
mmccollum is on a distinguished road
Default ????

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.
Reply With Quote
  #3  
Old 08-30-2022, 11:19 PM
Guessed's Avatar
Guessed Guessed is offline How to connect multiple excel files through eConnect Windows 10 How to connect multiple excel files through eConnect Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Have you watched any youtube video tutorials on Excel's Power Query?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #4  
Old 08-31-2022, 07:13 AM
mmccollum mmccollum is offline How to connect multiple excel files through eConnect Windows 10 How to connect multiple excel files through eConnect Office 2010
Novice
How to connect multiple excel files through eConnect
 
Join Date: Aug 2022
Posts: 4
mmccollum is on a distinguished road
Default

no, not that specifically. I'll try that, thank you!
Reply With Quote
Reply

Thread Tools
Display Modes


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
How to connect multiple excel files through eConnect searching for text in multiple excel files roytom Excel 2 07-30-2012 01:57 PM
How to connect multiple excel files through eConnect convert multiple csv files to multiple excel files mit Excel 1 06-14-2011 10:15 AM
How to connect multiple excel files through eConnect Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft