Data input to one cell?
 

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

Data input to one cell?
 

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