| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Distinct Counts with Multiple Criteria | Excel Discussion (Misc queries) | |||
| Applying multiple distinct conditional formatting rules | Excel Discussion (Misc queries) | |||
| Extracting distinct data | Excel Discussion (Misc queries) | |||
| comparing distinct data | Excel Programming | |||
| Distinct Data In Combo Box | Excel Programming | |||
Linear Mode
