K
K
ROW A B C G J
------------Coloumns
5
6 000 G56 TYSS 000G56TYSS 1000
7 001 HJ1 WER5 001HJ1WER5 1900
8 001 HJ1 WER5 001HJ1WER5 -1900
9 546 ST8 SVR5 546ST8SVR5 5600
10 230 W33 ZTT8 230W33ZTT8 -2000
11 230 W33 ZTT8 230W33ZTT8 4500
12 230 W33 ZTT8 230W33ZTT8 2000
13 130 TV5 LK12 130TV5LK12 800
14 152 Y12 RE88 152Y12RE88 9000
15 152 Y12 RE88 152Y12RE88 4400
16 152 Y12 RE88 152Y12RE88 -3000
17 152 Y12 RE88 152Y12RE88 -9000
18 152 Y12 RE88 152Y12RE88 3000
19 003 Q45 OPK2 003Q45OPK2 6000
In Row 5 I have headings and in Range ("A6:C10000") I have data as
show above
in each cell of Range("G6:G10000") I have formula which is
"=A6&B6&C6"
and
this formula been drag down to cell "G10000". This formula actually
combines the
value which are given in coloumns "A , B and C". I have figures in
coloumn "J"
I want Macro which should check coloumn "G" and if the values of
cells
in coloumn
"G" are same and in same Row of those cell in coloumn "J" cells if I
have "+" and
"-" figures of same amount then Row of those cells from coloumn "A"
to
coloumn
"L" should be deleted. For example in above data in coloumn "G"
cells
of Row 14 to 18
we have same values of "152Y12RE88" and there are plus and minus
figures in coloumn "J" cells of same Rows of coloumn "G" cell in
which
we have same values. The plus
and minus figures next to value of "15Y12RE88" are "9000 , 4400 ,
-3000 , -9000
and 3000". Now macro should delet 9000 and -9000 as they cancel each
other
and these figures are same in amount and also delete 3000 and -3000
so
the
figure should be left now is 4400. Basically I want Row from coloum
"A" to "L"
should be deleted when there are same values in coloumn "G" and there
figures
in coloumn "J" cells next to coloumn "G" cell value which cancel each
other.
Please if any friend can help
------------Coloumns
5
6 000 G56 TYSS 000G56TYSS 1000
7 001 HJ1 WER5 001HJ1WER5 1900
8 001 HJ1 WER5 001HJ1WER5 -1900
9 546 ST8 SVR5 546ST8SVR5 5600
10 230 W33 ZTT8 230W33ZTT8 -2000
11 230 W33 ZTT8 230W33ZTT8 4500
12 230 W33 ZTT8 230W33ZTT8 2000
13 130 TV5 LK12 130TV5LK12 800
14 152 Y12 RE88 152Y12RE88 9000
15 152 Y12 RE88 152Y12RE88 4400
16 152 Y12 RE88 152Y12RE88 -3000
17 152 Y12 RE88 152Y12RE88 -9000
18 152 Y12 RE88 152Y12RE88 3000
19 003 Q45 OPK2 003Q45OPK2 6000
In Row 5 I have headings and in Range ("A6:C10000") I have data as
show above
in each cell of Range("G6:G10000") I have formula which is
"=A6&B6&C6"
and
this formula been drag down to cell "G10000". This formula actually
combines the
value which are given in coloumns "A , B and C". I have figures in
coloumn "J"
I want Macro which should check coloumn "G" and if the values of
cells
in coloumn
"G" are same and in same Row of those cell in coloumn "J" cells if I
have "+" and
"-" figures of same amount then Row of those cells from coloumn "A"
to
coloumn
"L" should be deleted. For example in above data in coloumn "G"
cells
of Row 14 to 18
we have same values of "152Y12RE88" and there are plus and minus
figures in coloumn "J" cells of same Rows of coloumn "G" cell in
which
we have same values. The plus
and minus figures next to value of "15Y12RE88" are "9000 , 4400 ,
-3000 , -9000
and 3000". Now macro should delet 9000 and -9000 as they cancel each
other
and these figures are same in amount and also delete 3000 and -3000
so
the
figure should be left now is 4400. Basically I want Row from coloum
"A" to "L"
should be deleted when there are same values in coloumn "G" and there
figures
in coloumn "J" cells next to coloumn "G" cell value which cancel each
other.
Please if any friend can help