Hi Bob,

I tried using that code but it didn't work. When I change the dropdown in C4 it works fine and the correct data is brought back. When I change the dropdown in C6, nothing happens. Ideally I want the macro to look in column A of 'Raw Data' for the value of C4 and look in column B of 'Raw Data' for the value of C6. If either of C4 or C6 is changed then the macro should bring in new data. At the moment it's only working when C4 is changed, not C6. I tried to duplicate the worksheet change event but I don't think you can do that.

Thanks