I have a large data sheet. I also have another cell (say, A1) created that has a value I'm searching for. Is there a way to create a macro or write something in VBA where if I double-click on A1, it will search my sheet for the next cell that has the same value as the one I have in A1?

Any help would be very much appreciated.

Thanks.