View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Two worksheets to one

I have two worksheets.

Each have a Primary Agency column,

I would like a third worksheet that consildates the two worksheets to
one column of unique values.


Example:

Worksheet 1
KT
A5
12
12
KT
JK

Worksheet 2
GT
KT
A5
14

Worksheet 3 (the worksheet I want to generate) should look like:

KT
A5
12
GT
14
JK

Notice that they are combined but also only listed once.

Thanks In Advance.