Copying Range based on condition from workbook 1 to workbook2

  • Thread starter Thread starter nitn28
  • Start date Start date
N

nitn28

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
 
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
Click to expand...

nt evn clos
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Condition based copy/paste of range 1
Condition based copy/paste of range 2
Want code to copy to ABOVE row 22 column A on sheet 1 10
Copy a range data from 1 sheet to multiple selected sheets 1
Copy data from workbook 2 to workbook 3 mystery! 2
Import multiple workbooks to current workbook in specified row number 0
Copy Range to Another Workbook 6
Copy named range based on variable 2

Back
Top