I have two spreasheets that have a common column what I want to do is be able
to click on a cell in the common column in the first spreadsheet so that it
will bring up the 2nd spreasheet but with the corresponding value that I
clicked on from the first spreadsheet. for eg. I would click on the value in
A2 and this would then search the corresponding column in the 2nd spreadsheet
for the matching value. Is this possible?