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...