Data copied from sheet to sheet

[Gary121]

Hi

I'm useing Excel 2010 and I want to be able to enter data into sheet1, and have it copied into sheet2.

EG.
I have a list of Minerals and a list of of Prices, in sheet1. In sheet2 I have the exact same list of Minerals and Prices. I would like the list in sheet2 to automaticaly update with the data I enter into the price list coloumb from sheet1, as this changes regulary.

Thanks
Gary

Sorry, didn't see new uesers, will post in there)

[jeffreybrown]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.