Macro - Copy Cell Above, Change Specific Value

[Screen-Pros]

I'm sure there is a cleaner way to do this - I was hoping a Macro would help

I'm trying to copy the cell above the target cell which contains a formula [=IF(A10=1,E150,IF(A10=2,ROUND(E150*C154,2),IF(A10=3,ROUND(E150*C155,2),IF(A10=4,ROUND(E150*C156,2)))))]

And paste the formula in the cell directly below with minor edits (changing each "A10" value to "A11")


This is the easiest solution I've found since excel is not properly cascading my formula through the worksheet.


Any help would be appreciated.

[Fluff13]

If you only want A10 to change, use
=IF(A10=1,E$150,IF(A10=2,ROUND(E$150*C$154,2),IF(A10=3,ROUND(E$150*C$155,2),IF(A10=4,ROUND(E$150*C$156,2)))))
Then you can drag the formula down

[Screen-Pros]

Thanks! Knew there had to be an easier way

[Fluff13]

Glad to help & thanks for the feedback