I would like to input monthly data in a cell, lets say Cell A1

Within the spreadsheet I have a set of monthly figures, lets say from Cells
M1 through to M12 (Jan to Dec)

If state that Cell M1 = $A$1 and drag that down to M12.

Is there a formula to automatically junp to Cell M2 etc when I input data
into Cell A1 each month?

Thank you for your expertise.

Cheers, Peter

Why not just input the monthly figures direct into the range M1:M12 ?

Or input into A1:A12,
then just link M1:M12 via using simple link formulas viz:
Put in M1: =IF(A1="","",A1)
Copy M1 down to M12
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Potaroo" wrote in message
...
I would like to input monthly data in a cell, lets say Cell A1

Within the spreadsheet I have a set of monthly figures, lets say from
Cells
M1 through to M12 (Jan to Dec)

If state that Cell M1 = $A$1 and drag that down to M12.

Is there a formula to automatically junp to Cell M2 etc when I input data
into Cell A1 each month?

Thank you for your expertise.

Cheers, Peter