Text from worksheet transfer to another

[Djanvk]

Ok here is what I want to do.

I have a list of names on one worksheet and these names periodically
change, now I want them on another worksheet in the same workbook but
want them to automatically to update and not have to type to in on the
second worksheet. Is there a way to do this, please help..


Thanks

 

[pfsardella]

Assume names are in Column A on Sheet1

On Sheet2 in Cells A1,

=Sheet1!A1

Copy down formula as needed.

HTH
Paul

 

[Djanvk]

Thanks for the help, just what I needed...