View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jdpf jdpf is offline
external usenet poster
 
Posts: 7
Default How to select data in non adjacent rows of a column automatically

How can I select the data in non adjacent rows of a column (eg. A1, A9. A17.
A25.......A800, A 808, A816 etc.) and place it into another column? The data
I need to select is consistently 8 rows apart in a very large spreadsheet. I
am using Excel 2003.