If it would make it any easier:

I originally had a pivot table of sheet("Workload") and used the the values in in as a Dynamic Named Range for the listbox.

This worked perfectly up to a point.

The reason I'm looking at multiple columns now is that I couldn't get the datafield of the pivottable to change to current week ending value - it always remained at the value that i had 'maunally' selected to set it up in the first place.

If the listbox code above is too much hassle, does anyone know how I can change the datafields value to the current weekending value

This is the pivotcode i used:

Created new topic for this