wilkisa
Well-known Member
- Joined
- Apr 7, 2002
- Messages
- 657
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
Here's my scenario: Range BH6:BH35, Sheet name APR 2013
Cell BH6 is associated with the date of 4/1/2013 in cell A6, and so on through the month of April to cell A35.
The formula is cell BH6 is:
=IF(SUM(B6,G6,L6,Q6,V6,AA6,AF6,AK6,AP6,AU6,AZ6)>BG6,SUM(D6,I6,N6,S6,X6,AC6,AH6,AM6,AR6,AW6,BB6),0)
I have tried Data Validation to pop up a warning box if the value of the formula exceeds the value in BG6 but I didn't get it to pop up. I then tried it if the formula exceeds a fixed number of 205 but I can't seem to make it work if it is evaluating the results of a formula.
I also tried creating a macro to have a msgbox pop up if the value exceeds the value in BG6 (205) but I can't seem to make it follow down each day, changing to the next cell in BH.
Here's the wrench in the works: I need this macro to work in the same cell range on every sheet for the entire year and we change from month to month.
Help! I think Data Validation should work, which would make this much easier, but I'll take any help I can get at this point.
Cell BH6 is associated with the date of 4/1/2013 in cell A6, and so on through the month of April to cell A35.
The formula is cell BH6 is:
=IF(SUM(B6,G6,L6,Q6,V6,AA6,AF6,AK6,AP6,AU6,AZ6)>BG6,SUM(D6,I6,N6,S6,X6,AC6,AH6,AM6,AR6,AW6,BB6),0)
I have tried Data Validation to pop up a warning box if the value of the formula exceeds the value in BG6 but I didn't get it to pop up. I then tried it if the formula exceeds a fixed number of 205 but I can't seem to make it work if it is evaluating the results of a formula.
I also tried creating a macro to have a msgbox pop up if the value exceeds the value in BG6 (205) but I can't seem to make it follow down each day, changing to the next cell in BH.
Here's the wrench in the works: I need this macro to work in the same cell range on every sheet for the entire year and we change from month to month.
Help! I think Data Validation should work, which would make this much easier, but I'll take any help I can get at this point.