Re: $$Excel-Macros$$ Solution required for preparing Schedule

Can you please help me in workbook.. Regards, Subhash yadav On Tue, Jun 28, 2011 at 2:02 PM, Vasant wrote: > Sorry...correction. > > use this. > > Public Function CalculateType(Rng As Range) > If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value > = 1050 Or Rng.Value = 1300 O

Re: $$Excel-Macros$$ Solution required for preparing Schedule

Sorry...correction. use this. Public Function CalculateType(Rng As Range) If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value = 1050 Or Rng.Value = 1300 Or Rng.Value = 1550 Then CalculateType = 50 ElseIf Rng.Value = 750 Then CalculateType = 250 ElseIf Rng.Value = 1000 Or Rng.Val

Re: $$Excel-Macros$$ Solution required for preparing Schedule

try this. use this UDF for the type columns. Pass the Previous Type value into the function Public Function CalculateType(Rng As Range) If Rng.Value = 300 Or Rng.Value = 550 Or Rng.Value = 800 Or Rng.Value = 1050 Or Rng.Value = 1300 Or Rng.Value = 1550 Then CalculateType = 50 ElseIf Rng.Value =

Re: $$Excel-Macros$$ Solution required for preparing Schedule

Please help me out. On Tue, Jun 21, 2011 at 10:09 AM, Subhash Yadav wrote: > Dear Experts, > > Please refer my attached file for which i want solution. > > My queries are: > > 1. In the "type" column - Value is "previous type+50". but if the values > are 300,550,800,1050,1300,1550 etc this st