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