I am trying to update one of my worksheet using VBA Code, by look up value from sheet 1 in column A, search the same value in sheet 2 column A (there will be duplicates), and return the value from column A and the associate value in sheet 2 column B to sheet 1 from column F to column AJ+ (depend how many storage in sheet 2 column B, could be 50+ storages)

Sheet 2 is somewhat look like this:

following is the Sheet 1 and the result data (yellow highlighted)

A simple working VBA code would be highly appreciated.

Thanks.

BoyBoy