Hi I need help with the following.
I have a spreadsheet broken into different tables in one sheet i want to create a search function in vba that will seatch the rows for singular or or duplciate values and highlight them to indicate that they are on the sheet.
can this be done.
For example I would enter and 50005049 it would then search all the fields to find matching or singular items and highlight the whole cells.
Or even a command button and txt search box.
I have a spreadsheet broken into different tables in one sheet i want to create a search function in vba that will seatch the rows for singular or or duplciate values and highlight them to indicate that they are on the sheet.
can this be done.
For example I would enter and 50005049 it would then search all the fields to find matching or singular items and highlight the whole cells.
Or even a command button and txt search box.