Hi: I want to deduct the data in col. B from data in col. G and then put
the deducted result in col C. But col B data of 1991 will be deducted
from col G data of 1990. For example:
cell(2,3).value
= cell(2,3).offset(-1,4).value - cell(2,3).offset(0,-1).value
A------B-----C----D-----E----F------G H I
1990--1----------3----------6-------8
1991--1----------9----------2-------7
1992--2----------5----------7-------1
I want to do it with a range and formula. Something like:
range("c2:c3").formular1c1 = "=RC[4].offset(-1,0) - RC[-1]"
Thanks
--
jesmin
------------------------------------------------------------------------
jesmin's Profile:
http://www.excelforum.com/member.php...o&userid=29540
View this thread:
http://www.excelforum.com/showthread...hreadid=492400