software

I have 1000 names in sheet1. (Cells A1 to A1000)

I want to put names 1 to 10 in Sheet2 - Cells A1 to A10
I want to put names 11 to 20 in Sheet3 - Cells A1 to A10
I want to put names 21 to 30 in Sheet4 - Cells A1 to A10

etc.

until all 1000 names used up.

I want to be able to cut amp; paste from sheet 2 to 3 , 4 etc.
However, after the Camp;P I do not want to have to change every address.
I.e. In sheet 3. I do not want to be forced to changed to change cell
A1 to =sheet1!A11

I need a form of quot;dynamicquot; cell addressing. Something like
=a(x*10 1)..

Do you understand my query? If so well done!--
dewsbury
------------------------------------------------------------------------
dewsbury's Profile: www.excelforum.com/member.php...oamp;userid=16084
View this thread: www.excelforum.com/showthread...hreadid=520297Let's assume you have 101 worksheets. Sheet1 with the data and sheets 2-101
all blank. Enter and run this macro:Sub Macro1()
' gsnu
Dim r1, r2 As Range
For i = 2 To 101
Set r2 = Worksheets(i).Range(quot;A1quot;)
Set r1 = Worksheets(1).Range(Cells((i - 2) * 10 1, quot;Aquot;), Cells((i - 2) *
10 10, quot;Aquot;))
r1.Copy r2
Next
End Sub
--
Gary's Studentquot;dewsburyquot; wrote:

gt;
gt; I have 1000 names in sheet1. (Cells A1 to A1000)
gt;
gt; I want to put names 1 to 10 in Sheet2 - Cells A1 to A10
gt; I want to put names 11 to 20 in Sheet3 - Cells A1 to A10
gt; I want to put names 21 to 30 in Sheet4 - Cells A1 to A10
gt;
gt; etc.
gt;
gt; until all 1000 names used up.
gt;
gt; I want to be able to cut amp; paste from sheet 2 to 3 , 4 etc.
gt; However, after the Camp;P I do not want to have to change every address.
gt; I.e. In sheet 3. I do not want to be forced to changed to change cell
gt; A1 to =sheet1!A11
gt;
gt; I need a form of quot;dynamicquot; cell addressing. Something like
gt; =a(x*10 1)..
gt;
gt; Do you understand my query? If so well done!
gt;
gt;
gt; --
gt; dewsbury
gt; ------------------------------------------------------------------------
gt; dewsbury's Profile: www.excelforum.com/member.php...oamp;userid=16084
gt; View this thread: www.excelforum.com/showthread...hreadid=520297
gt;
gt;


Perfect ! Thanks--
dewsbury
------------------------------------------------------------------------
dewsbury's Profile: www.excelforum.com/member.php...oamp;userid=16084
View this thread: www.excelforum.com/showthread...hreadid=520297