macro to copy with incremental values

Hi folks,
i have this macro that copies the values of the formula and pastes in steps every 30 rows. It is working except that it copies the formula without increasing the value of the cells in the formula. So that now i have the same formula on row 1 and row 30, row 60 etc

what's wrong?

thanks

Please Login or Register  to view this content.

Does the formulas in A1:F1 have locked cell references? How does the formulas look like?

hi berlan,
the formulae are as follows
thanks for taking the toruble

=TODAY()
='C:\M-C\[Meta-ASCII.xlsm]Sheet1'!$D$11
=MAX('C:\M-C\[Meta-ASCII.xlsm]Sheet1'!$E$1:$E$11)
=MIN('C:\M-C\[Meta-ASCII.xlsm]Sheet1'!$F$1:$F$11)
='C:\M-C\[Meta-ASCII.xlsm]Sheet1'!$G$1
=SUM('C:\M-C\[Meta-ASCII.xlsm]Sheet1'!$H$1:$H$11)

try your macro after changing the formulas to;

=TODAY()
='C:\M-C\[Meta-ASCII.xlsm]Sheet1'!$D11
=MAX('C:\M-C\[Meta-ASCII.xlsm]Sheet1'!$E1:$E11)
=MIN('C:\M-C\[Meta-ASCII.xlsm]Sheet1'!$F1:$F11)
='C:\M-C\[Meta-ASCII.xlsm]Sheet1'!$G1
=SUM('C:\M-C\[Meta-ASCII.xlsm]Sheet1'!$H1:$H11)