Thank you so very much for your quick response and great feedbackI have used your suggestion and adapted it to suit the particular project that I am working on and it all seems to be working great except for the Product filter again...
Please could you just have a look at my adapted code to check what I have done wrong? The Product filter is just not filtering correctly. I think I might have made a boo-boo with typing the code.
PS: My Customer and Product drop down boxes were linked to other worksheets that were not included in this workbook, so they will not show...