*2011* * * PictOld *Achievement (1-10)* PictOld *Improvement (0-9)* *Jan-Mar* *Apr-Jun* *July-Aug* *Jul-Dec* *Jul11-Mar12* 100.00% 100.00% 100.00% 10 9
Yes, I want the formula to pick up the last entered value on the right (the next period would be blank like the BLUE cell above). Then when I enter the next periods data, the formula picks up the new most righted non-blank cell. Thank you sir for your patience and teachings.... John On Fri, Oct 7, 2011 at 12:07 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > You are welcome John. > > In order to include next set of data we can use defined name(s) but for > this to work, we need to create a locator cell, refrencing which Excel can > understand which period to pick up as I am not sure if you want right most > data to be picked up always. > > Share your thoughts and then we can proceed . . Cheers. > > Regards, > DILIPandey > On 7 Oct 2011 20:46, "John A. Smith" <johnasmit...@gmail.com> wrote: > >> Dilip, >> >> Thank you for the quick response. It works great. One other question; >> How could I change the formula to pick up the next period if data is added >> to cell I3 (through I13)? >> >> I marked up the spreadsheet for my new question. >> >> Thanks for the help with the formula, it works great. >> >> John >> >> On Fri, Oct 7, 2011 at 10:00 AM, Dilip Pandey <dilipan...@gmail.com>wrote: >> >>> Hi John, >>> >>> Please find attached the solved worksheet. Let me know if this works. >>> Thanks. >>> >>> Regards, >>> DILIPandey >>> On 7 Oct 2011 18:14, "John A. Smith" <johnasmit...@gmail.com> wrote: >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> 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 >> > -- > > ---------------------------------------------------------------------------------- > 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