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
