Hey Guys,

I have a problem in Excel that I really need help with. I have two sheets, the first sheet has a column with duplicates (all my columns have headers). In my second sheet I would to have the list, generated from the column in the first sheet, but a unique list. I have tried different formulas, and nothing works! I am posting it here under Macros and VBAs, because perhaps a Macro would be a better solution, unfortunately I have little experience with Excel macro's, though I have some experience with VBA in Access. A solution in the form of Macro or a Formula would both be helpful!

Please help!

Many thanks!

S