create one unique master list from multiple lists

[rickf19]

Hi
I have 12 tabs (months) which have between 3 and 7k rows (codes) and I need to create a list of all the individual unique codes to act as a lookup table. I have copied all the columns with the codes into one sheet called Detail but dont know how to create one list from columns b to m which lists every seperate code from all the columns.

Hope there is a way to do this as it is going to keep coming up within various other data sets

Thanks

Rick

 

[Artik]

If you copied the columns from sheets 1-12 into one column in the Detail sheet, you could apply an advanced filter to get uniques. The filter requires that the data contain a header.

Artik