Essentially you need to use VLOOKUP for the store score where you have Plant
and Store Number.

Depending upon your preferences you can write a Macro which copies the
master file and then adds VOOKUP to the third column or keep a template where
you paste the first two rows from the master and have the VLOOKUP in the
third column.
"Mike" wrote:

Can someone tell me the best way to list data that comes from two seperate
files?

Example: I have two files
1) A Plant & Store master excel file (list all store numbers and the plant)
2) Another excel file that list store numbers and a store score.

Would like to create a third file/report that shows the plant, store number,
and score (and ensure the master file poplulates the report plant & store
number). This report would be updated from the original two files (they get
saved quarterly so want this report updated automatically).

Thanks for any suggestions.