Try this in B5 of sheet2 and drag right. =IF((COLUMN()-1)<=Sheet1!$B$3,Sheet1!$B$2,IF((COLUMN()-1)=Sheet1!$B$3+1,SUM(OFFSET($A$5,,1,,Sheet1!$B$3)),""))
On Mon, Feb 23, 2015 at 7:29 AM, Gaurav Devrani <gauravdev1...@gmail.com> wrote: > Yes Sure.. I will get back to you with that formula. No worries. > > Regards > Gaurav Devrani > > On Mon, Feb 23, 2015 at 7:25 AM, Enock Wangila <ekwang...@gmail.com> > wrote: > >> Hi Gaurav, >> >> Thank you for you help. Quick question, is there a way of using a formula >> instead of a code to do what you have done. Maybe an If statement of some >> sort. Would appreciate if that were possible. I really need a formula. >> >> On Mon, Feb 23, 2015 at 4:42 PM, Gaurav Devrani <gauravdev1...@gmail.com> >> wrote: >> >>> 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. >>> >> >> >> >> -- >> >> *Enock Wangila,* >> *Intern Analyst* >> >> *Umati Capital Ltd* >> >> >> *Eden Square * >> >> *Block 1, 7th Floor* >> *P.O Box 856-00606* >> >> >> *Mobile: +254 708 037 464* >> *Email: ekwang...@gmail.com <ekwang...@gmail.com>* >> >> -- >> 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.
