VBA: Loop through column , identify last row of specific name category then offset c & p

Hi All,

Looking for some guidance/Help . I am looking for a macro that can run through a column , find the last cell with the specific name i.e "Gold , Silver , Bronze" then when it finds the related cell it offsets from the cell to 3 columns along copies the number then pastes it onto the other sheet "Data" in its related highlighted location .

I have included a copy of a mock workbook of what I am looking for.

Thanks in advance

How about

Please Login or Register  to view this content.

But on the Data sheet you have a space after "Silver "