I am currenlty doing a little project for my wifes workplace. It is for a stock search utility. They have given me the spreadsheet with all the stock items.
The layout for the sheet is COLUMN A contains the Site of where the stock is..(42 rows) COLUMN B has the names of who manages the Site... (also 42 rows).. and the stock is from Column C2:DD43
I have devised a basic user form with 1 input text box ("txtItem") a search button ("cmdFind") and 2 other textboxes to display the results, ("txtSite" & "txtManage") which displays the results. I just cant seem to find the right syntax on how to search the 'DATA' in C2:DD43 and get the results someone. I have looked at various videos and other posts but they dont really explain the way I need to do it.
So basically if I type in SOCKS it will return where the stock is, (ColumnA) and who manages it (Column B)!
any help appreciated!