dear Mr. Verma, et us try both macros with the NEW source table (as New Input) like this
please find attached: ** a workbook containing this data ** a workbook containing both macros X1 1.7 11/11/2008 01/11/2010 X2 2.4 11/12/2009 01/11/2010 X3 3.8 11/01/2010 01/11/2010 X4 2.5 12/30/2009 01/11/2010 X5 4.2 11/22/2009 01/11/2010 X6 4.9 02/01/2010 01/11/2010 X7 5 01/06/2010 01/11/2010 X8 5.5 01/16/2010 01/11/2010 X9 5.2 01/03/2010 01/11/2010 if you don't mind, you are requested to attached the result sheets to this groups. I 'll do the same on May 10, 2011. thank you and best regards STDEV(i) On Sun, May 8, 2011 at 3:13 PM, rajan verma <rajanverma1...@gmail.com> wrote: > > 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
NewInput for Anvesh_Case.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
2X_Solution.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
