Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have been looking for an entire day to find a solution to this. Found
'some' answers but not the thing I need. I got a few workbooks with a lot of worksheets. For almost every workbook there needs to be a list of unique values coming from different worksheet (always in the same workbook). I would like to get a clue on how to do that. So suppose worksheet 1, and worksheet 2 I would like to create a list on worksheet 3 gathering all unique values from columns B (of both worksheet 1 and 2) using VBA. I'm really really not familiar with VBA so suggestions more than welcome. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create List of Unique Values from several columns | Excel Discussion (Misc queries) | |||
Create a list from many columns | Excel Discussion (Misc queries) | |||
How do I create a list of unique values from 2 columns of data | Excel Worksheet Functions | |||
Compare 2 columns, and create a list of items that are in both lists | Excel Worksheet Functions | |||
How do I create multiple columns from a one-column list in Excel? | Excel Worksheet Functions |