putting numbers by vba macro

Hi,

macro will be placed in macro.xlsm & book1.xlsx has located at diiferent path so the path should be hardcoded in the macro so that i can change it as per my needs

In sheet2, whenever i run this macro it should put the data in series from 1 to 100 in row 1
after each run of the macro it will put the numbers in series like 1,2,3,4 & so on

Thnx

Both the macros pasting the data from column B i want it to paste the data from column A

No Sir bcoz may be A1 will have data 1 or it may not have any data Sir, So i am looking for the same

Thnx Alot Davesexcel Sir for Helping me in solving this problem Sir
Have a Awesome Day Sir