In worksheet2, in the cell to reflect the value of A1 in Sheet1.

=Sheet1!A1

as an example.

--
Regards,
Tom Ogilvy

"Excel" wrote in message
...
I would like to plug in a number to a cell on worksheet one and it
automatically populate the fields from worksheet two?????? help