Good Day Everyone!
I am literally new to excel please be easy on me.
I have a data sheet containing 12 columns and I wanted to filter the datas in the easiest possible way so I created a macro for it that searches data and displays to a different sheet. The problem is I can only search for datas that is in the first column (Item Code) and I wanted to search from every column and display it to my designated sheet.
I'm also having problems with creating a data entry form that restricts duplicate values by row.
Kindly check the file. Thank you so much to anyone that can help.
[ATTACH]n1220587[/ATTACH]