Hi , I guess you also want to merge the header cells in sheet 2 for all entries.. Please refer to this new sheet.
Regards Gaurav Devrani On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani <gauravdev1...@gmail.com> wrote: > HI Enock, > > Please check the attached file and let me know if I missed something. > > Regards > Gaurav Devrani > > On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila <ekwang...@gmail.com> > wrote: > >> Hi Guys, >> >> I want a formula that populates values in a worksheet, on a single row >> based on two values entered on a different worksheet. The formula should >> then sum the populated cells and input the result in the cell adjacent to >> the last cell entry. Example: I want to fill 9 cells in sheet2 with a value >> of 100 and sum the cell entries in the adjacent cell to give 900. The >> operations of populating and summing should be contained in a single >> formula. I have attached an excel file for illustration. >> >> Cheers, >> >> -- >> 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/d/optout. >> > > > > -- > Thanks & Regards > Gaurav Devrani > > -- Thanks & Regards Gaurav Devrani -- 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/d/optout.
Illustration (1).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12