Formula repopulating macro Help

I am trying to create a macro which will start in E2 with
=IF(Dealers!B2=930,Dealers!A2,"") and continue down to E26 and the Formula would end there with
=IF(Dealers!B26=930,Dealers!A26,""). This is what I have so far.

Please Login or Register  to view this content.

This however gets stuck in a loop and I have to force excel to shutdown or it runs forever. Also its just pasting the same formula into each cell and not changing it to correspond with the following cell. Any help with this would be great

OllyXLS that worked extremely well thanks. However as I tried to extrapolate that to the next column it did not work. Example:

Please Login or Register  to view this content.

While Column E is B2:B27 Column F needs to be B28:B51. With the above code though Column F restarts at B2. Do I just need to change the RC2 and RC1?

Thanks OllyXLS