Thanks Dilip Your solution is great, and does exactly what i needed, your support is so very much appreciated.
Thanks a Million Dave -----Original Message----- From: Dilip Pandey [mailto:dilipan...@gmail.com] Sent: Wednesday, March 02, 2011 10:17 PM To: excel-macros@googlegroups.com Cc: Pehrson, Dave Subject: Re: $$Excel-Macros$$ Macro to Average a series of numbers in excel Hi Dave, This is a kind of realistic problem which many user faces on daily basis. I have designed the solution for you which you can further customize as per your changing requirements. See the attached file and feel free to get back in case of any help required. :) Thanks & Best Regards, DILIPandey On 3/1/11, Pehrson, Dave <dpehr...@walbro.com> wrote: > Thanks for your interest in this problem, > > My intent in this process, as you can see in the attached example, is > to help automate the process of leveling monthly quantities into > weekly quantities. There are too many variables to develop an > algorithm to determine which cells to level, and which cells not to > level, so I want the production planner to make the decision and > perform the function of calculating the average over the predetermined period. > > In the example in Yellow, the planner would place the curser in cell > J22 and press the macro button 5 weeks. The macro I started > highlights the > 5 week period, what I want to do is extend the logic to add the > contents of the range selected, divide the sum by 5 (roundedup,0) and > place the results in each of the cells in the selected area > > In the example in Blue, the planner would place the curser in cell O22 > and press the macro button 4 weeks. The macro I started highlights > the > 4 week period, what I want to do is extend the logic to add the > contents of the range selected, divide the sum by 5 (roundedup,0) and > place the results in each of the cells in the selected area > > Row 23 contains the numbers that I would like to see in row 22. (this > row is only to show the example) > > Thanks for any help you can offer. I'm not a programmer, and often > don't develop the most effective solutions, so in you see a better > approach I would love your input. > > Dave > > -----Original Message----- > From: excel-macros@googlegroups.com > [mailto:excel-macros@googlegroups.com] On Behalf Of Dilip Pandey > Sent: Sunday, February 27, 2011 10:46 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Macro to Average a series of numbers in > excel > > Hi Dave, > > Please attach a sample file while replying to this email. > > Thanks, > DILIPandey > > On 2/25/11, Diamond Dave <dpehr...@walbro.com> wrote: >> Expert Team, >> I'm struck. What I'm trying to do is create a macro that will >> average > >> a series of numbers and replace the numbers in the predefined series >> with that average number. Currently I'm assuming two variables. One >> macro for a set of 4 numbers, and one set for a series of 5 numbers. >> The following is an example of a series of 4. I you can help with >> this, I can use the example to create the process for a series of 5 >> 1. I will identify a range of numbers >> X a b c d e f g >> 1 1000 0 0 1000 B to E is the range > selected to average >> 500 500 >> 500 500 the numbers ro replace above numbers >> >> Any support will be appreciated. >> >> -- >> --------------------------------------------------------------------- >> - >> ------------ >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips >> and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, mvp > MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- > ---------------------------------------------------------------------- > -- > ---------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips > and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > ---------------------------------------------------------------------- > ------------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips > and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
