$$Excel-Macros$$ Data Validation

I need to setup validation for a named range based on the value in say cell G5. The rule being as follows: IF cell G5 = 25,000.00 the validation rule is, the named range values <=25,000.00. On the other hand if cell G5 = 25,001.00 the validation rule for the named range is >= 25,000.00. Violati

$$Excel-Macros$$ Re: formula required to update values form one sheet to another sheet with date criteria

Not clear what you are trying to do but if your master sheet has different names and you are trying to sum for your report sheet try the following: =SUMIF(MASTER!$B$5:$B$35,"Raman Choudary",MASTER!C5:C35) That goes into B9 of your report sheet. You can then copy across. If B10 is a different