Auto Adding Names in Sheet

[Deepak]

Hi all,

I have 150 names in Sheet 1 from A1 to A150

also i have 151 sheets in the workbook

I want names to automatically appear in sequence for e.g.
- The name in A1 of Sheet 1 - should appear in A1 of Sheet 2
- The name in A2 of Sheet 1 - should appear in A1 of Sheet 3
- The name in A3 of Sheet 1 - should appear in A1 of Sheet 4
- The name in A4 of Sheet 1 - should appear in A1 of Sheet 5
- The name in A5 of Sheet 1 - should appear in A1 of Sheet 6

and so on

guys all your help is appreciated.

Thank you.
Deepak
[email protected]

 

[Don Guillett]

something like

for i=1 to 150
cells(i,"a").copy sheets(i+1).cells(1,1)
next i