.Find Loop causing Excel to freeze

Hey all, I have a sheet set up as follows:

A2: Actor Name
B2: Movie Name
F2: Scene 3
A3: Actress Name
B3: Movie Name
F3: Scene 6
ect...

I first search for the movie name and then check cell to the left to see if it has the desired name. The problem arises when the first search result doesn't have the desired name left of it. I would like to keep searching the sheet for the movie and looking at the name until it is a match.

Please Login or Register  to view this content.

Thanks all for your help. This will conclude my macro once fixed!

hi Trippin,

Try recording a macro of your actions ([alt + t + m + r]) as you step through them manually, stop recording & review the recorded code. This will give some sound base code (in the context of autofiltering a name) which can then be made more flexible. If you have any questions about making the code flexible, please include your recorded code with the questions.

Edit: I posted the above before seeing Stephen's last post & I agree with him - is a macro really needed?

hth
Rob