I need to link 2 cells from 2 different excel workbooks. How can I do that?
Example: Say if A1
cell of Book1
and B2
of Book2
are linked. If I update A1 cell of Book1
with 1000
, then B2
of Book2
should automatically get updated to 1000
. Any idea how to link the cells in c#?
Thanks in advance.