K
K
hi, I have data in range (A1:C1000) and this range can increase or
decrease depending on the data I receive and remove. See the little
version of data below that I have
ROW A B C -----col
1 GG ZZZ -100
2 GG BBB 200
3 SS HHH 300
4 TT XXX -600
5 VV GGG 200
6 XX TTT 900
7 GG UUU 700
8 YY AAA 400
9 TT XXX 600
10 VV GGG -200
11 ZZ FFF 600
12 GG ZZZ 100
I want macro which should check in whole column A and B cells that if
the same codes value in these columns have + and - figures in column C
cells then it should delete both those rows. For example as in above
data in row 1 I have code GG in cell A1 and code ZZZ in cell B1 then
macro should find both these codes in whole column A and B and see how
many times these both codes appearing in same row and if they have +
and - figures in column C in same row cell then both rows of those +
and - figures should be deleted. Note that the GG and ZZZ codes can
be appear ten times in column A & B and so macro should check all and
so on with other codes. Please if any friend can help me in this
matter. if someone can come up with small macro which can do this job
then it will much helpful but otherwise any macro will do.
decrease depending on the data I receive and remove. See the little
version of data below that I have
ROW A B C -----col
1 GG ZZZ -100
2 GG BBB 200
3 SS HHH 300
4 TT XXX -600
5 VV GGG 200
6 XX TTT 900
7 GG UUU 700
8 YY AAA 400
9 TT XXX 600
10 VV GGG -200
11 ZZ FFF 600
12 GG ZZZ 100
I want macro which should check in whole column A and B cells that if
the same codes value in these columns have + and - figures in column C
cells then it should delete both those rows. For example as in above
data in row 1 I have code GG in cell A1 and code ZZZ in cell B1 then
macro should find both these codes in whole column A and B and see how
many times these both codes appearing in same row and if they have +
and - figures in column C in same row cell then both rows of those +
and - figures should be deleted. Note that the GG and ZZZ codes can
be appear ten times in column A & B and so macro should check all and
so on with other codes. Please if any friend can help me in this
matter. if someone can come up with small macro which can do this job
then it will much helpful but otherwise any macro will do.