Creating a list in Sheet2 from data input into Sheet1

[P_Stich]

To clarify further I want data input into Sheet1 to populate Sheet2 as a list. So if I enter "North" into cell C7 of Sheet1 I want it to populate cell A1 of Sheet2. Then I go back to Sheet1 and enter "South" I want it to populate cell A2 of Sheet2 and so on. I want to be able to populate several columns in Sheet2 using data input into Sheet1, always in the same cells in Sheet1 but making a list in Sheet2. I hope this makes sense. Any help would be greatly appreciated. Thanks.

[nathansav]

In sheet1

Please Login or Register  to view this content.

[P_Stich]

This seems to just make an exact copy on sheet2. Is there any way to make it so you have sheet1 as a data input sheet and sheet2 as a list generating sheet?

[nathansav]

always in the same cells in Sheet1 but making a list in Sheet2

i interpeted that as what you wanted.

So do you want if there is an entry for it, dont add, if there isnt then add?