Code to create numbers in sequence

[GKT]

To make the querry more simple I have attached the sheet
A request to kindly access the sheet.

Thanks
GKT

[Kaper]

Try following code (create a button in jour sheet1 and assign this macro):

Please Login or Register  to view this content.

[jindon]

Try the attached.

[GKT]

Thanks for the reply Kaper & Jindon.
The code is perfect but as I wanted it to be executed in the
same sheet i.e sheet1. Is it possible?
Else it is perfect.
Also Jindon I wanted the result in column A only.

Thanks again
GKT

[jindon]

Even simpler.

[Kaper]

Also mine corrected:

Please Login or Register  to view this content.

Slower one, but could be (who knows ) a bit easier to understand

[GKT]

Hello again Jindon
I just re-checked the first code. It is displaying the data in column A.
Comparing both of your code the I would prefer the first since the data
is put up in column A . I will manage the data in sheet2.
In that case even the Kaper solution is workable.
Only one change if I might require in the future. The data which is
put up in sheet2 as per the first code. I want the data from A2 onwards considering
row 1 will be headers.

Thanks
GKT

[Kaper]

row 1 with headers:

Please Login or Register  to view this content.

[jindon]

Change to

Please Login or Register  to view this content.

You can still see col.B, if you change to

Please Login or Register  to view this content.

[GKT]

This is a confusing decision since both the options are acceptable to me
and can be given SOLVED.
But since Kaper gave the exact requirement I would grade him first and then to Jindon.
Also I will use both the codes as and when required.

However many thanks to both of them.

GKT

[jindon]

Don't worry.

Your question and the presentation of the result is confusing.
My result at the first time is exactly the same as your presentation anyway.