ExcelBanter - Linking Excel Files

Are you saying you want workbook A to be edited and workbook B to receive
results? Or, do want it set up where one can edit either workbook and have
the other capture the results?

For the first, you can just have both workbooks open, then in workbook B
type = and click the cell in workbook A you want it update with.

If B, if you want both to be the same exact file, just right click on the
file and make a shortcut.

If you want them to be two aboslutely different workbooks, you can check
with the programming section because that's not a worksheet function.

"sdavis" wrote:

How to link two or more excel files? I want to make changes in one file and
have the changes updated on the other file.