Hi all
I currently have a worksheet named "Database" with multiple fields of data on it, spread across columns "A" to "BG". Id like to be able to have a "searchbox" which when you type a value in to it will search for that SPECIFIC value in two of the columns in the worksheet and then only show that row.
One of the column is "A" and has a basic number (which is used as an order identifier) ie: 1, 2, 3 etc... the other column "B" has the date in a "dd/mm/yyyy" format. So I'd either be typing a number or a date.
Id like to be able to search for either of these and it only display the relevant row.
Is this possible?
I currently have a worksheet named "Database" with multiple fields of data on it, spread across columns "A" to "BG". Id like to be able to have a "searchbox" which when you type a value in to it will search for that SPECIFIC value in two of the columns in the worksheet and then only show that row.
One of the column is "A" and has a basic number (which is used as an order identifier) ie: 1, 2, 3 etc... the other column "B" has the date in a "dd/mm/yyyy" format. So I'd either be typing a number or a date.
Id like to be able to search for either of these and it only display the relevant row.
Is this possible?