Excel: Fill column in sheet1 with data entered in one cell from sheet2 ..

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 ..:nya:

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of February 16, 2017.

For more resources for Microsoft Excel