Try this...

Do this once.

Select the cell on the 2nd sheet
Right clickCopy
Navigate to the other sheet and select the cell where you want the value to
appear.
Right clickPaste SpecialPaste Link

--
Biff
Microsoft Excel MVP


"thermocorp" wrote in message
...
Hello,

I have a spreadsheet with a number of different worksheets. All I want to
do
is if I enter a number into a cell on the 2nd worksheet for example, I
want
it to automatically show in a specific cell on the first worksheet. So a
simple copy and paste but for excel to automatically do it for me! it
seems
like something so easy that I just cant figure out how to do.