The solution would need a simple macro. using Button_Click event this can be done. It just has one trick that is the use of static variable to store the last row of data used or a loop and condition to check what value is currently in cell and then select the next value from dump. Problem is many organizations don't permit macros what's policy for Wipro I don't know. Would a macro solution work for you?
Warm regards, Anand Kumar On Sep 27, 9:02 pm, hemant shah <hemanthin...@gmail.com> wrote: > Hi Team, > > Can you please help on the attached file. > > I have explained my query in the attached sheet. > > Regards, > Hemant Shah---------- Forwarded message ---------- > From: <hemant.s...@wipro.com> > Date: Mon, Sep 27, 2010 at 9:25 PM > Subject: Book1.xls > To: hemanthin...@gmail.com > > Please do not print this email unless it is absolutely necessary. > > The information contained in this electronic message and any > attachments to this message are intended for the exclusive use of the > addressee(s) and may contain proprietary, confidential or privileged > information. If you are not the intended recipient, you should not > disseminate, distribute or copy this e-mail. Please notify the sender > immediately and destroy all copies of this message and any > attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient > should check this email and any attachments for the presence of > viruses. The company accepts no liability for any damage caused by any > virus transmitted by this email. > > www.wipro.com > > > > Book1.xls > 28KViewDownload -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
