Hi Everyone,
I'm trying to update a file (File1) with the information that I have in another workbook (File2), but File2 has 10 sheets and I would like to use a formula or a macro that searches in all these sheets.
E.g. I need to bring the data in column J starting cell J4, in column K starting cell K4, etc after the name in column A and the numbers that are highlighted with yellow in row 2, from File 2. The data in File2 looks the same as File 1, the only difference is that the numbers in row 2 are scatered in 10 sheets.
File1
Any suggestions would be appreciated
I'm trying to update a file (File1) with the information that I have in another workbook (File2), but File2 has 10 sheets and I would like to use a formula or a macro that searches in all these sheets.
E.g. I need to bring the data in column J starting cell J4, in column K starting cell K4, etc after the name in column A and the numbers that are highlighted with yellow in row 2, from File 2. The data in File2 looks the same as File 1, the only difference is that the numbers in row 2 are scatered in 10 sheets.
File1
Any suggestions would be appreciated