Hi All,

I have a master spreadsheet, which lists part numbers

I then have around 100 separate spreadsheets, with which I want to pull the info from

When I open one of the 100 spreadsheets, the part number will always be listed in cell G36

What I need is some vba that will look at G36, and find that part number in column A of the master spreadsheet, once found I need to copy cell G28 and paste it in column B of the master spreadsheet, beside the relevant part number

and copy cell G35 into Column C of the master spreadsheet , beside the relevant part number

right now I am doing this manually, but I know there has to be a faster way

I have used some VBA before but never between 2 different spreadsheets

Thanks in advance for any replies

Regards,