| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
| Input Cell in One variable data table | Excel Worksheet Functions | |||
| Input cell on Data Table will not work | Excel Discussion (Misc queries) | |||
| format cell from data input to output form | Excel Worksheet Functions | |||
| Input Date when data is entered into another cell | Excel Worksheet Functions | |||
Threaded Mode
