N
nitn28
Hello everyone
I am new to excel vba n stucked in a problem hop i wil get help form
this forum
i hav around 2000 data in my worksheet n need to sort it out
My data is like this
1 2
3 4
5 6
7 8
9 10
13 15
15 16
17 19
19 21
28 27
as shown above i hav data in two columns wat i want to do is to copy
and paste the above values in different column based on condition say
in coulm c,d, e,f
Condition is if cell(2,1)-cell(1,1) and cell( 2,1)- cell( 2,2)
[subtraction]
just like this
a b c d e f g h
1 2 1 2 13 15 28 27
3 4 3 4 17 19
5 6 5 6 19 21
7 8 7 8 [these values r in
9 10 9 10 diff col. bn 13 &
9,
13 15 [copied d above range 10&15 is grtr than 3
15 16 bcoz deiff is less than 3 ]
17 19
19 21
28 27
Hope sum of u get time time to help me put as i m begnr in it n trying
hard to xplore xcel - vba
many thanx
I am new to excel vba n stucked in a problem hop i wil get help form
this forum
i hav around 2000 data in my worksheet n need to sort it out
My data is like this
1 2
3 4
5 6
7 8
9 10
13 15
15 16
17 19
19 21
28 27
as shown above i hav data in two columns wat i want to do is to copy
and paste the above values in different column based on condition say
in coulm c,d, e,f
Condition is if cell(2,1)-cell(1,1) and cell( 2,1)- cell( 2,2)
[subtraction]
move to next row if condition is not true then copy the range
just like this
a b c d e f g h
1 2 1 2 13 15 28 27
3 4 3 4 17 19
5 6 5 6 19 21
7 8 7 8 [these values r in
9 10 9 10 diff col. bn 13 &
9,
13 15 [copied d above range 10&15 is grtr than 3
15 16 bcoz deiff is less than 3 ]
17 19
19 21
28 27
Hope sum of u get time time to help me put as i m begnr in it n trying
hard to xplore xcel - vba
many thanx