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 vasant...@gmail.com 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

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

Please help me out. On Tue, Jun 21, 2011 at 10:09 AM, Subhash Yadav scy2...@gmail.com 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

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

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