Again, your help is highly appreciated.
I have to develop a tool in Excel (VBA). I have three different worksheets. The first two are information about products, sorted by product number.
In the third one, there should be a tool, which needs to calculate with information from the first worksheet.
So, I am trying to achieve a scenario where I put in the product number in the third worksheet, and Excel automatically searches the first sheet for the product number and copys the according relevant information. Then it should be pasted in the tool (third worksheet) in the right cells. Is something like that possible?? And if yes, how??
Please help :-)
Thank you so much!!!