setting one worksheet cell range reference to another worksheet

[erkapilbhatia]

I want to set one worksheet cell range reference to another worksheet using aspose.cells.For example i have two worksheet(wrk1 and wr2). I have some data on wrk1 and wrk2 is balnk.Now on wrk2 i want cells refrence of wrk1(like want cell reference of wrk1 sheet A1:A10 on wrk2 with same style as on wrk1) .

Please suggest.

[Miraun]

Gotta use Paste Special twice:

Copy
Paste special
Paste Link

Copy
Paste Special
Paste Formatting

[erkapilbhatia]

this solution will not work for me as its copy and paste from one sheet to another.I want it through cell reference, so that if i will change any data in wrk1 it should automatically changed in wrk2.
please suggest.