Dear all
I need a macro which will lookup a value from four different workbooks. The workbooks are placed in a share drive. So many people will be using the macro to lookup from the workbooks.
So I will lookup for the above value in four wrok books. That is I will look up age from a workbook then height from another workbook then gender from another work book and contact no. from another work book. So kindly advise a macro that will lookup from each work books that are in share drive and the 4 work books should be shared because many will be using the macros.and more overt the workbooks should not open the lookup should be from the closed workbooks(4 workbooks)
I need a macro which will lookup a value from four different workbooks. The workbooks are placed in a share drive. So many people will be using the macro to lookup from the workbooks.
So I will lookup for the above value in four wrok books. That is I will look up age from a workbook then height from another workbook then gender from another work book and contact no. from another work book. So kindly advise a macro that will lookup from each work books that are in share drive and the 4 work books should be shared because many will be using the macros.and more overt the workbooks should not open the lookup should be from the closed workbooks(4 workbooks)
