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 -- ---------------------------------------------------------------------------------- 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
Solution.xlsm
Description: Binary data
