I followed most what was written in your wonderfull forum but no one
tackled the weakness in the wizzard for the multirange senario.

By that I mean once you go with the wizzard YOU CANNOT achieve the same
felexibilty as with single range with regard to field selection.

My question is : if VBA can do wonders why no one (as far as I know)
cameup with a remedy using VBA.

Allow me illustrate:

My single list consists of Item # , qty , supplier (let us say I have 3
suppliers A,B and C)

I use the wizzard for single list I get this wonderfull PT with
supplier as the colum. Now I can filter Suppler A no problem

I split the SAME list into 3 lists same layout

Try to use the multirange I CANNOT get the SAME PT. WHY????