hi STDV(i) Your macro only working with 3 Rows.. if he want to add more data in that table it will not expend all table..
On Sun, May 8, 2011 at 1:40 PM, rajan verma <rajanverma1...@gmail.com>wrote: > hi > find attached File > > > > On Sat, May 7, 2011 at 11:33 AM, anvesh.gw...@gmail.com < > anvesh.gw...@gmail.com> wrote: > >> Hi, >> >> I need help in VBA code. >> I have excel sheet on which data is write as below mention >> >> >> Input >> >> A B C D >> 1 X1 1.5 11/11/2008 01/11/2010 >> 2 X2 2.5 11/12/2009 01/11/2010 >> 3 X3 3.5 11/01/2010 01/11/2010 >> >> I want Output in another sheet as given below >> >> Output >> >> A B C D >> 1 X1 1.0 11/11/2008 01/11/2010 >> 1 X1 0.5 11/11/2008 01/11/2010 >> 2 X2 2.0 11/12/2009 01/11/2010 >> 2 X2 0.5 11/12/2009 01/11/2010 >> 3 X3 3.0 11/01/2010 01/01/2010 >> 3 X3 0.5 11/01/2010 01/01/2010 >> >> >> Procedure >> 1. Check column B if it contain decimal than separate integer and >> decimal i.e if value is 1.5 than >> insert row and split as mention above in output >> 2. Check C and D for date if "C" column Date is less than "D" Column >> than pick Date of "D" column other wise pick date of "C" Column. >> >> Can any body help me in this. >> >> Thanks in advance >> Anvesh >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> > > > > -- > Regards > Rajan verma > +91 9158998701 > -- Regards Rajan verma +91 9158998701 -- ---------------------------------------------------------------------------------- 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