First, I am a very novice Excel user. I have a 2000+ row worksheet that my
boss would like me to add a search box for. Each cell entry in this column in
a unique account number. Ctrl-f does not work because my account numbers
begin at 1 and end at 10000 (205 could be returned from multiple cells 2051
and 2052...). This is joined by 7 other related columns that display YTD data
on the account. Basically I need to enter the account number in the search
box and have the whole row of data appear at the top of the range for that
account. I think this may have to be done in VBA and that is over my head.
Any assistance would be greatly appreciated.