I$\text{'}$m trying to write a VBA sub that checks the value of a certain cell in a column, if there's a number there then i need it to save it and the row name where it is and then paste it into another table in a different sheet.The picture here is a simplified version of what i have. On sheet $2$ i$\text{'}$d have a drop down list where the user picks the material they want. In this example they chose "iron".Then what I want the sub to do is match the material name from all the columns on sheet $1,$ look down the matched column, check if there's a number $($not a $--)$ then paste back on sheet $2$ the name chemicals $($there might be more than one$)$ used and values $($the amount used$).$