Compare a value with value in other sheets and then COPY data into a sheet.

**acsishere** · 02-26-2009, 06:26 AM

Dear Friends,

I need a help to solve a problem.

I have a worksheet in which I have customer data (currently active). The ANO field is the unique code for each customer.

In other three sheets, QLY1, QLY2, QLY3 some sales stats (of customers) are there.

Now, I need to cosolidate the customer data with QLY (all 1, 2, 3) statistics together in a CONSOLIDATED sheet.

Besides, I need to count no.of QLYs in which the concerned ANOs appear.

I have attached the sample file for your kind reference.

Thanking you and in anticipation,

acsishere.

**NickMinUK** · 02-26-2009, 12:28 PM

Use vlookup and isna. See attached

**NickMinUK** · 02-26-2009, 12:38 PM

Forgot the count. Now added

**acsishere** · 02-26-2009, 01:18 PM

Dear Sir,

Thanks for your solution with application of formulas. It seems simple & good.

But, as I have more than 150 columns/15,000 rows in each QLY file, I think it is a tedius job to copy in each & every column.

Hence, I feel a VB code will be the better solution to do as it may not take more than a minute to do the process.

Any help in VB?

sincerely yours,
acsishere.