First post here gos. I am looking to transfer information from one colomn in one workbook to another cell range i choose in another workbook. But the information from the first workbook needs to be seached through.
i.e. i need all instances of Oranges to be found and transferred to the other workbook within a cell range of my choice and so on.
Can this be done. I have been trying Vlookup and several other formulas to no avail.
Hope some one can help