Referencing value from one excel file to another

**modest_16081982** · 08-04-2007, 01:33 PM

hi,

I have two excel files. Say FileA.xls and FileB.xls.

What I would like to do is to reference two columns (say E & F) from FileB to FileA. In short, if I change any values any value in Column E or F of FileB, it should reflect in FileA also.

How can I achieve this?

Ideally I would like to reference the entire worksheet of FileB to FileA.

Thanks

**Bryan Hessey** · 08-05-2007, 02:57 AM

Originally Posted by modest_16081982

hi,

I have two excel files. Say FileA.xls and FileB.xls.

What I would like to do is to reference two columns (say E & F) from FileB to FileA. In short, if I change any values any value in Column E or F of FileB, it should reflect in FileA also.

How can I achieve this?

Ideally I would like to reference the entire worksheet of FileB to FileA.

Thanks

Hi,

I could not imagine why you would want this . . . but . . .

You could have both Workbooks open and reference as =[FileB.xls]Sheet1!A1

You could use a VLookup on the other (closed or open) workbook.

You could install and use the MoreFunc Addin to allow you to use =[FileB.xls]Sheet1!A1 where the workbook may not be open.

In any case, if BookC references BookA whilst BookA is closed the results will be unpredictable.

hth
---

**mikerickson** · 08-05-2007, 03:04 AM

I think this will do what you want.
In the code module of fileB.xls Sheet1

Please Login or Register  to view this content.

In a normal code module:

Please Login or Register  to view this content.

Any change to Columns E and F of sheet1 of fileB.xls will be reflected in those columns of Sheet1 in FileA.xls

Calling dupSheet instead of dupRange will duplicate all of Sheet1 from fileB to fileA.

**modest_16081982** · 08-05-2007, 12:46 PM

Originally Posted by mikerickson

I think this will do what you want.
In the code module of fileB.xls Sheet1

Please Login or Register  to view this content.

In a normal code module:

Please Login or Register  to view this content.

Any change to Columns E and F of sheet1 of fileB.xls will be reflected in those columns of Sheet1 in FileA.xls

Calling dupSheet instead of dupRange will duplicate all of Sheet1 from fileB to fileA.

I tried as you suggested but I could not get it working. I am sure I am doing something wrong or didn't understood it correctly. I am attaching the two files with the code in it as you suggested. That may probably give you more idea as to what I did wrong.

I really appreciate your efforts. Thanks a lot.

Please see the attached file.