Data input to one cell?

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
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Query 1
Month Formula 3
Show 12 months in one field to 12 fields 4
How to use two drop-down list to fill data 2
Keep adding to one cell to carry a total in another 7
View lengthy text from one cell to another cell without widening c 1
formula to add year to date figures 3
Multiple Criteria, One Answer 1

Top