Thanks to both of you for your help.

Mark07, it seems like your code has done the trick.
I've attached it for your interest (and anyone elses).

Basically I've cut and pasted your work (thanks yet another time). I can't honestly say that I FULLY understand how it works but I'm largely there.

I've stripped all the maths and other macros etc that I had in the original workbook. It was running at 1.5mb and wasn't a good size to post here. This is JUST the input part of the process.

Interestingly, with this method there seems to be a pause between clicking on a dropdown and waiting for it to actually drop. It must be the time taken for the code to store the data and then read again. It was instantaneous before.
No complaints though, it only offers exclusive data as I asked.

I need some code to re-initialise the form when I click CLEAR. Any ideas? I did get some code for that a while back - couldn't make it work.

Bottom line...you guys really have helped. Both strangers to me and yet you found the time to help. The internet is a wonderful thing.


I will be happy to a part of this forum and help (in my limited way) in the future.

Regards,

Paul