Macro to drag formula and paste values

EDIT 3rd AUGUST:
Bumping up.

In a nutshell:

1) the row number 3 would have the formula column (A3:BU3)
2) macro would drag the formula down up to row 1000 (columns "A3:BU3" from row 4 to 1000)
3) macro would copy and past values from row 4 to 1000 (columns "A3:BU3"), keeping original formula in row 3

Thank you!!



Hi guys,

Once again need your expertise, any help would be appreciated.

The formula below is slowing down the spreadsheet and looking for a macro that could:

1) the only cell that would keep the formula would be the first cell in the row 2 (column "i")
2) macro would drag the formula down up to row 1000 (column "i" from row 3 to 1000)
3) macro would copy and past values from row 3 to 1000 (column "i"), keeping original formula on row 2

=IFERROR((VLOOKUP(A2,Sales!$B:$AR,MATCH(CONCATENATE($O$1,"/",$P$1),Sales!$3:$3,0)-1,0)+VLOOKUP(A2,Sales!$B:$AR,MATCH(CONCATENATE($O$1,"/",$P$1),Sales!$3:$3,0)-2,0)+VLOOKUP(A2,Sales!$B:$AR,MATCH(CONCATENATE($O$1,"/",$P$1),Sales!$3:$3,0)-3,0)+VLOOKUP(A2,Sales!$B:$AR,MATCH(CONCATENATE($O$1,"/",$P$1),Sales!$3:$3,0)-4,0))/4+(SUMIFS(Blending!$E:$E,Blending!$A:$A,A2,Blending!$J:$J,$Q$1)*-1+SUMIFS(Blending!$E:$E,Blending!$A:$A,A2,Blending!$J:$J,$R$1)*-1+SUMIFS(Blending!$E:$E,Blending!$A:$A,A2,Blending!$J:$J,$S$1)*-1+SUMIFS(Blending!$E:$E,Blending!$A:$A,A2,Blending!$J:$J,$T$1)*-1)/4,"")

That would fix the issue.

Thanks everyone,

Rick