Need to get values based on multiple conditions through Macro

[mahmad558]

So far my code is working OK however I dont seem to be getting desired values since all the values are dynamic and change from time to time, hence the need for change, I need to embed this in my code, I have no idea how to acheive it. I need these values only when column D & J is clicked.

Please Login or Register  to view this content.

Current Code in use which doesnt give desired values:

Please Login or Register  to view this content.

[TMS]

This formula won't work for two reasons

Please Login or Register  to view this content.

1. The first line of the formula refers to G7, not G47

2. If a value is less than 30, it will also be less than all the higher test values that precede it. So the formula will return the <=90 result. You need to reverse the order of the tests.

The second formula also has the same issue (2).

[mahmad558]

The point here is to embed the code and this is for the entire column range G4 : G76 , A4 : A76 , F4 to F76, H4 : H76, M4 : M76
the <= sign can be changed to >= depedning on the result I get.
***Corrections***

Please Login or Register  to view this content.

[TMS]

I'm not going to spend any time embedding a formula in code when I know it won't work.


Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[mahmad558]

Have uploaded the file for your reference, the idea is that when I click on Column J or Column D, I need this calculation, which you can see in column N & O, this value should display in Cell A3 when column D is clicked and in M3 when Column J is clicked.

Instead of using <= I have used >=, I have corrected that.