Hi,
Pls see attached the sample file. (sample file is 3 sheets only, but the actual is more then 30 sheets)
Range I18 - I39 is "description"
Range D18 - D39 is "Item No."
Cell I48 is Remark
If Range "Descrirption" contains "IPS" or "IP" or "IP*"then the item no & "Plating for ....." will auto entry in Cell.I48
Any help will be highly appreciated !