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 that number, save the number directly below it and the row name where it is and then paste it into specific cells in 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 $2$ values as shown on the image attached. I have a starting code but i need help tweaking it to make it do what i mentioned. Thanks in advance!!