It's even easier than that, what you are asking for is a link and all you
have to do is to copy the cell
then paste special and select paste link. No need to type anything

--


Regards,


Peo Sjoblom

"da" wrote in message
...









Thanks. It worked. It was so easy, I should have known that, duh...












"Sheeloo" wrote:

Enter in the desired cell in Sheet4
(I am assuming sheet name is Sheet1 for worksheet1)

=Sheet1!D4

OR you can also enter = in any cell in Sheet4
Then click on Sheet1
Click on D4
Press Enter and you are done

The number I want to copy from is on worksheet 1 and copy to worksheet
4.
The cell address in worksheet 1 is Row 4, Column D.
--
If you find this post helpful pl. choose "Yes"...


"da" wrote:

HI
I want to copy a cell address which is on a different worksheet (same
file).
How do I do it? I tried using the ADDRESS formula but it does not show
correct result.

thank you