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
Bookmarks