VBA, Intercept 2 giving range from 2 sheet,If condition, intercepted copy to 3rd sheet

[david gonzalez]

Hi all, !!

I been searching the net about intercept ranges and copy to another sheet, but i can't find something "easier" for my knowledge and modify it...., please i need some help, i'm still learning VBA (God, i think my iq is getting away lol.. )

okay, this is the trouble :
-----------------------
sheet and Column to be compare :
SHEET-1 -> Column A,C,E <--versus--> PAGE-2 -> Column A,C,E,G,I

Sheet to copy compared data w/ condition :
sheet -> "INTERCEPTED"


Example :
---------
Compare Range A3:A20 Worksheet "SHEET1"
against Range A3:A20 worksheet "PAGE-2"
Condition:
If Min/Max Numbers (5 to 12 numbers ) are Intercepted,
Then paste these intercepted numbers in Empty cell Range A3 (down) of worksheet "intercepted" .
--------------------------------------------
Then the same Range A3:A20 worksheet "SHEET1"
against Range C3:C20 worksheet "PAGE-2"
Again the Condition :
If Min/Max Condition Meet, (5 to 12 numbers Intercepted ) ,
Then paste these intercepted numbers in empty cell Range B3 (down) of worksheet "intercepted" .
--------------------------------------------
Then the same Range A3:A20 worksheet "SHEET1"
against Range E3:E20 worksheet "PAGE-2"
If Min/Max Condition Meet, Then paste intercepted empty cell of Range C3 (down) of worksheet "intercepted" .
---------------------------------------------
Then the same till reach interception Range A3:A20 (SHEET1) to I3:I20 of worksheet "PAGE-2"
---------------------------------------------
Then Start over with Range
Compare Range C3:C20 Worksheet "SHEET1"
against Range A3:A20 worksheet "PAGE-2"
If Condition Meet, Then paste intercepted empty cell of Range C3 (down) of worksheet "intercepted" .

till reach interception Range E3:E20 (SHEET1) to I3:I20 of worksheet "PAGE-2 "


NOTE:
what i need to do is 10 times bigger,(than the sheet sample) i'm pretty sure that if i see a code structure (if someone help me)
i achieve the whole thing (modifying or expanding the code, U know... part of my learning..)


Best Regards

David

[GC Excel]

Hi,
Can you explain a little more how you compare the range from Sheet1 with the one in Page-2.
Is it cell by cell? example A3 vs A3

What do you mean by "If Min/Max Numbers (5 to 12 numbers ) are Intercepted"
Would help if you could provide expected output in your sample workbook for at least the first comparison (A-A).

[david gonzalez]

Hi Mr GC Excel,

no cell by cell, is by range :
range A3:A20 (Sheet-1) Compare against range A3:A20 (Page-2)

from the sheet sample :
SHEET-1 Column A3:A20 <-VS-> PAGE-2 Column A3:A20

Both ranges have 20 numbers, but after compare, none of these numbers match

so the condition is not meet.

But (hypothetically) , if more than 5 numbers exist in both ranges, ( for example 20,31,02,12,07,15 )
then numbers intercepted have to go in Column A of Sheet named "INTERCEPTED"
20
31
02
12
07
15
(in next empty cell )

Thank you

Best Regards

David

[david gonzalez]

Hi,
What do you mean by "If Min/Max Numbers (5 to 12 numbers ) are Intercepted"
Would help if you could provide expected output in your sample workbook for at least the first comparison (A-A).

The Min/Max is the condition of for example :
If in Sheet "SHEET-1" and in PAGE-2" are intercepted less than 5 numbers or More than 12 Numbers,
then not copy in sheet named "INTERCEPTED"

When i say numbers Intercepted, i mean that numbers exist in both ranges of both sheet.


Best Regards

David

[jindon]

from the sheet sample :
SHEET-1 Column A3:A20 <-VS-> PAGE-2 Column A3:A20

Both ranges have 20 numbers, but after compare, none of these numbers match

so the condition is not meet.

20 numbers?

[david gonzalez]

Hi Mr Jindon , !!

Yes sir is Duplicated (sorry, .. )

and is 18 numbers starting Row 3 till row 20..


Best Regards

David

[jindon]

See if my understanding is correct,

Please Login or Register  to view this content.