Hi All -
Is there any way if I can make "D2" dynamic. I mean while pasting it to other Row or other Column "D2" should change to D3 or E2 ( Bascially I want to adjust Relative Reference concept while pasting.)
=INDIRECT("Sheet1!"&"$D2").
Any help would be appreciated.
Thanks!