get distinct data from multiple sheets & then consolidate distinct
 

I have data in a table in multiple worksheets... I would like to consolidate
the distinct data from these sheets into a single sheet....

eg. sheet1- A-B-C
sheet2 - X-Y-Z
sheet3 - A-B-E
sheet4 - X-Y-Z

the result should be :

A-B_c
X-Y-Z
A-B-E

this is to be done using a macro...

plz help..

get distinct data from multiple sheets & then consolidate distinct
 

Use the method shown he

http://www.j-walk.com/ss/excel/tips/tip47.htm

although this is for filling a listbox, the concept/approach presented does
what you want

--
Regards,
Tom Ogilvy


"Nikhil" wrote:

I have data in a table in multiple worksheets... I would like to consolidate
the distinct data from these sheets into a single sheet....

eg. sheet1- A-B-C
sheet2 - X-Y-Z
sheet3 - A-B-E
sheet4 - X-Y-Z

the result should be :

A-B_c
X-Y-Z
A-B-E

this is to be done using a macro...

plz help..