Thanks,
I did try that but it failed to work correctly, even on a simple subset of data, I couldn't even tweak the VBA code to make it work after using the recorder to create the code, the recorded code didn't even work. I'll look at it again at a later date