Hi .. I would like to fill a column in sheet1 from data that I enter into only one cell in sheet2, eg:
sheet2 A1 I enter 5 and it appears in A1 of sheet1.
I now go back to sheet2 A1 and enter fresh data, say 20 and that 20 now appears in cell A2 of sheet1.
I now go back to sheet2 and enter fresh data into A1 and that data appears in cell A3 of sheet1, and so on.
I'm only using cell A1 of sheet2 to enter data .. does this make sense ?
Any help will be much appeciated ..
sheet2 A1 I enter 5 and it appears in A1 of sheet1.
I now go back to sheet2 A1 and enter fresh data, say 20 and that 20 now appears in cell A2 of sheet1.
I now go back to sheet2 and enter fresh data into A1 and that data appears in cell A3 of sheet1, and so on.
I'm only using cell A1 of sheet2 to enter data .. does this make sense ?
Any help will be much appeciated ..