Hi everyone,

I have 5 separate text lists in E34:E50, J34:J50, N34:N50, Q34:Q50 and T34:T39.

A number of items are common across the lists and some are unique.

I need to have a 6th master List (E55:E80 approx) that contains all the entries contained in the 5 lists with no duplicates and which will update when the sub-lists are amended.

Grateful for any assistance with this one.

TIA

Ed