Copy G5, paste in G7.
The formula =Sheet2!C5 will paste as =Sheet2!C7
--
David Biddulph

"DC" wrote in message
...
For example:

For sheet 2, Cell C 5, and C7 already got data as 1015 and $30
respectively

when I'm in sheet 1, at cell G 5, if I link "Sheet 2 C 5" to this cell, it
will replicate "1015" tho this cell.... but at the same time I would like
to
have C 7 to be replicated t Sheet 1 at cell G7 as well..... can it be done
or
another method can be use....

Appreciate anyone advise....