VBA to generate a universal list

[The_Snook]

Hi,

This is no doubt absolute simples to those in the VBA know. What i'm looking to achieve is a universal (duplicate free) list generated from the office names on each monthly tab in column B. I'd like the output to start in cell B3 on the 'summary' tab.

Hopefully the attached example shows what i'm looking to achieve.

Thanks in advance,

Snook

[oeldere]

See the attached file.

Please Login or Register  to view this content.

[The_Snook]

Thanks for trying to assist me oeldere but it's not quite what I was looking to achieve. What I'm after is simply a list of all the office locations where any duplicates are excluded.

If you (or anyone) would like me to clarify anything further just give me a shout.

Thanks,

Snook

[AB33]

Try the attached.

[The_Snook]

Bingo bongo!

Thanks AB33, much appreciated!