$$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. Violation of the rule gives a stop and message "Cannot mix large and small invoices." is this doable with data validation or vba? Thanks for any help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$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 name copy the above formula to B10 and change the "Raman Choudary" to that name. Hope this is of some help. Regards. On Friday, July 19, 2013 12:50:57 AM UTC-4, excel lerner wrote: > Hi Experts > > Good morning Every Body. > > I have Two sheets in excel 2003 file.One is master sheet and 2nd one > reprot sheet. > > daily i have to send report to HO.I enter values in master sheet date wise. > In report sheet if i select or enter date data to be update from master > sheet with name.only one name will be in master sheet. > Please help me any formula? > i am attaching. test file. > > Thanks in advance > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.