J
jerry2004
i have an order log with order number and related data in one file
these sheets are many... ie many excel sheets.
then i have an other file with the order number and related data.
want to pick up data from different columns in the excel sheets (fro
these range of excel sheets) and transfer them to the main sheet wit
the order number as lookup key.
i am not able to enter range of excel sheets in second parmeter, i
data to search it is giving invalid .
how to enter range of excel sheets for this
these sheets are many... ie many excel sheets.
then i have an other file with the order number and related data.
want to pick up data from different columns in the excel sheets (fro
these range of excel sheets) and transfer them to the main sheet wit
the order number as lookup key.
i am not able to enter range of excel sheets in second parmeter, i
data to search it is giving invalid .
how to enter range of excel sheets for this