View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MCI MCI is offline
external usenet poster
 
Posts: 11
Default how to get one row out of every two rows?

suppose file1 has 200 rows, i want to get the first row, third row,
fifth row, ..., and put these 100 rows to a new file (file2). do i have
to use vba, or i can directly do it in excel

thanks a lot!