LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pulling data from one workbook to another based on a condition Dave H[_3_] Excel Worksheet Functions 3 December 17th 08 04:11 AM
Copying Selected Rows From Workbook1 to WorkBook2 [email protected] Excel Discussion (Misc queries) 0 October 10th 06 11:27 PM
Copying Selected Rows From Workbook1 to WorkBook2 [email protected] Excel Discussion (Misc queries) 0 October 10th 06 11:24 PM
Copying data based on a condition aheintz57 Excel Worksheet Functions 4 October 9th 06 05:12 AM
Copy range based on condition Sotomayor Excel Programming 1 September 10th 06 01:11 AM


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"