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.
