Hi,
Thanks Roger, however Pivot Tables are not what I'm after, they are great
for me and my reports but for the end user. I was thinking that the best
choice was probably linked to index/match or vlookup using a combo box
selector system, just not sure which is the best way forward. Many thanks
though for your suggestion.

Mickey