repopulating a formula macro

So i am having issues with repopulating a fomula in 2 columns. The 1st column needs to be =IF(Dealers!$B2=930,Dealers!$A2,"") and the macro copies it down 25 cells so it ends in =IF(Dealers!$B26=930,Dealers!$A26,""). THe 2nd column needs to do the exact same thing except start with =IF(Dealers!$B27=930,Dealers!$A27,"") and end with =IF(Dealers!$B51=930,Dealers!$A51,""). However the 2nd column starts as =IF(Dealers!$B27=930,Dealers!$A2,"") and ends with =IF(Dealers!$B51=930,Dealers!$A26,""). So the macro only works the 1st time through and doesnt repopulate correctly. Hopefully I can find some help with this code. I think i am close to the answer.

Please Login or Register  to view this content.

6StringJazzer That was the ticket. Thank you immensely

Glad to hear it. If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved.

Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.