Search in all sheets and copy the information from another workbook

Spiru

Board Regular
Joined
May 10, 2016
Messages
68
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

1661871379926.png



Any suggestions would be appreciated
 

Attachments

  • 1661871248729.png
    1661871248729.png
    6.5 KB · Views: 1

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Forum statistics

Threads
1,181,638
Messages
5,931,154
Members
436,778
Latest member
TCarr1958

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top