repopulating a formula macro

[tghiotto]

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.

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic


By posting your spreadsheet sample, we can test and analyze.

[6StringJazzer]

Try inserting the red part:

Please Login or Register  to view this content.

[tghiotto]

6StringJazzer That was the ticket. Thank you immensely

[6StringJazzer]

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.