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

[barneyboy]

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

 

[barneyboy]

Perfection !! .. Many thanks for your indulgence .. this is exactly what I wanted

bb

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

Perfection !! .. Many thanks for your indulgence .. this is exactly what I wanted

bb

 

[barneyboy]

Will do, mate .. thanks again