Why is this not possible? I can extract a range from a closed workbook, etc. But apparently what I am asking for seems just too much for Excel to handle.
On Active Sheet Cell BF7 I have an Alpha/numeric value, which I want to use to Search Sheet2 of a closed workbook, locate the column with that value and then copy that column to Cell BE9 on the Active Sheet of the Active WorkBook.
Please do not laugh, but this is what I attempted so far without any joy:
Is there anyone of you willing to fix this for me, please. Or can it not be done.
Please Login or Register to view this content.
For security purposes we cannot consider opening the closed workbook.