Copying Range based on condition from workbook 1 to workbook2
 

Hi evryone

i m new 2 vba n excel m trying to solve some problems as a part of my
problem i want to

copy range of data whenevr the difference of the activecell and cell
below is less than 3 if
until differnce is less than 3 copy the range say a1:b20

if the difference is gretaer than 8 thn take that cell as frst cell
thn again find diff with the cell below it and copy as far as
difference is less than 3 between two cells n paste data in othr rane
say e1:f20

hop i hav mad my query bit clear waiting 4 ur responses
many thanks in advance

Copying Range based on condition from workbook 1 to workbook2
 

On Apr 26, 8:08 am, wrote:
Hi evryone

i m new 2 vba n excel m trying to solve some problems as a part of my
problem i want to

copy range of data whenevr the difference of the activecell and cell
below is less than 3 if
until differnce is less than 3 copy the range say a1:b20

if the difference is gretaer than 8 thn take that cell as frst cell
thn again find diff with the cell below it and copy as far as
difference is less than 3 between two cells n paste data in othr rane
say e1:f20

hop i hav mad my query bit clear waiting 4 ur responses
many thanks in advance

nt evn clos