hey guys sorry i am new here, i have a sheet with two sets of data on it, 1. the name of a product and 2. the weight of the product
i want to then change the weight automatically on a different sheet if a certain product is selected
if anyone can help this would be highly appreciated
not sure to use excel or vba as there are over 100 products to do this with
EG. Flintsteel 25kg
Flintpro 15kg
and so on