Data input to one cell?

  • Thread starter Thread starter Potaroo
  • Start date Start date
P

Potaroo

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
 
Back
Top