I have data in my Macro which is one workbook in form of order numbers. I want to copy all order numbers from macro and pest it into another workbook by using vlookup.
my second workbook has different name every time so i need to open that file and pest all order numbers according Invoice number. All invoice numbers are available in one column of workbook. I have tried with Application.GetOpenFilename () but i am not able to assign worksheet of second workbook with this function.