I have a column with say 100 rows of various numbers. In another
column I want to set it up so that it takes the number from first row
and copies it to say B1 then want to put the number from 11th row and
put in in B2, then number from 21st row and put it in B3 etc.
Please help.
Mike

Col A 
   your data column
Col C 
   you put in C1:  =1  in C2 you put =c1+10, you copy c2 and you paste
it for as many number as you want
Col B
   col b1 you put ="a"&c1 you copy b1 and you paste it for as many
number as   you want
  you select the col B and you do copy and paste special, value
  
  you should get something like

  =a1
  =a11
  =a21 etc

  now to convert it to formula

  you select the column B you go to data, text to column and you do
next next  finish


good luck

Col A 
   your data column
Col C 
   you put in C1:  =1  in C2 you put =c1+10, you copy c2 and you paste
it for as many number as you want
Col B
   col b1 you put ="=a"&c1 you copy b1 and you paste it for as many
number as   you want
  you select the col B and you do copy and paste special, value
  
  you should get something like

  =a1
  =a11
  =a21 etc

  now to convert it to formula

  you select the column B you go to data, text to column and you do
next next  finish


good luck

Sorry forget the fist one

it's easier than that.  assuming your data is in column A, try this
formula in column B:

=INDEX(A:A,ROW()*10-9)

it works in excel 2003, at least.

-cab