Copying Values Between Worksheet

Hi there

I am working between two sheets. Sheet One is filled by employees and the other populates values entered in the rows.

Sheet 1: I have written a data validation code to update the suppliers from sheet 2(Which works)
Issue: Take for eg if there are two suppliers in the drop down, You chose one and populate the value, it should autopopulate the remaining suppliers with the same value.

Tried alot but in vain.

Please assist

Tx in advance

Pl attach a sample file with expected results.

Hi

Your query is not clear seems. I couldn't understand. Please explain your query in a simple excel sheet showing expected results.