Excel Array construction

[sjaganmohan]

Hi everyone,

I have a difficulty in working with excel arrays. I wish to create a sheet from 2 seperate ranges. Below are the details.

i am trying to create a report every week.

Range 1 is in Sheet1: Columns("A:C"). the data in these columns may increase or decrease every week.

Range 2 is in Sheet2: Columns("A:A") with duplicate values.

Range 2("A2") is part of Range 1("C2").

i need to get Range1("C2") in sheet 2.range("B2") where Range 2("A2") is found in Range1("C2").

this should come for every row where Range1("C2") in sheet 2.range("B2")

i am unable to build the array for these.

Please help me.