Auto Fill Numbers

Hi Friends,

I Need a formula for if we enter Five in A1 Cell then Auto fill the B column Starting with B1 1 to 5 & if We enter the Value in A5 then Start the Auto fill from B5 is it posible with out Macro or VBA?


Thanks

Liju

Hi Friend ,

I need the Attached format using Fromula they have any solution its a great help for me

Thanks

Liju

Some changes were needed in your example but have a look at the attached:

AUTOFILL NUMBERS.xls

Thanks

Exactly i requred the same but there it in A column Values are repeating..

I know and there is a way around that which I can't think of at this time - maybe someone else will help you. Cheers

Thank You..