item search

Hi,
I have this application where i want to create a search function,in "KOL WMS" and "WB WMS" sheet,where if I give an item code which matches with Kol data and wb data,then it
will give the details in row 17 of kol wms or wb wms

the password for opening macro is :9D5MLB

I think you're going to need to explain your requirements a little more.

What steps does this search function need to follow? What does the output look like for a given search item? Are all searches the same or is there more data for some items than others?

Regards

well,if I give an item code in column H15,and if it matches any of the rows in sheet "Kol Data"
it will pick the details from the row say column C5 - F5 and paste it in KOL WMS sheet in column c17 - g17,and the same for WB sheet

Bump no response