Linking multiple Excel Files

BMWTex

New Member
Joined
Apr 29, 2017
Messages
1
I have several excel files that will need to be linked. First I will have a File coming from Quickbooks that will have updated inventory on it. Second file is my template file in Excel for that particular vendor that will have inventory, description, etc. Third the upload file for Square which is linked to all columns in the second file.

My question is, how do I link the ever changing first file to the 2nd file. I'm not sure when I save the first file - if I should save with same name - and then I can just link the inventory column to the second file. Or if I can completely do away with the linking of the 2nd file (since I only will need one column once all the other columns are in Square already).

This maybe confusing so please write and I will clarify. Just not quite sure how to do this.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Forum statistics

Threads
1,223,958
Messages
6,175,633
Members
452,661
Latest member
Nonhle

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
Back
Top