Currently, I have a spreadsheet that displays about 35k rows of information which is updated with a brand new sheet about every two months by an outside agency.
I have added a search function and two other buttons to help individuals search the sheet and when a match is made the row is then highlighted yellow using this function (conditional formatting):
=AND($B$2<>"",OR(ISNUMBER(SEARCH($B$2,$A6:$L6,1))))
Is there a way to use the original sheet and above function to continue to search but also look into other sheets once they become available? This may be getting into VB?
Bookmarks