Thread: get distinct data from multiple sheets & then consolidate distinct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nikhil Nikhil is offline
external usenet poster
  
Posts: 44
Default 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..


Reply With QuoteReply With Quote