Private sub worksheet change, run when two seperate cells change

[jtd84]

Hi,

I've attached a file with a macro that I've built (with the help of excel forum). I've reached a point where I'm stuck and can't get it to work. I have a worksheet change event that runs once cell C4 is changed by the user but I also need it to change when C6 is changed. The macro pulls rows of data that contain the criteria entered by the user from the 'Raw data' tab. I'm sure it's something small I've missed but I can't figure it out. Thanks in advance.

Cheers

[Bob Phillips]

Please Login or Register  to view this content.

[jtd84]

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

[Bob Phillips]

I have no idea about the data, so cannot test, but try this

Please Login or Register  to view this content.

[jtd84]

Hi Bob,

I've tried using your code above with no luck, I'm still having the same issue mentioned previously. I've attached a workbook with the code you wrote, are you able to have a look to see what the error is? It seems like it's almost there and just needs a tweak.

Thanks

[Bob Phillips]

I think I was being a bit slow here

Please Login or Register  to view this content.

[jtd84]

thanks mate, works perfect. Appreciate the help!