Thread: How do I display every 5th row of data from a worksheet in a new .
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
  
Posts: 1,998
Default How do I display every 5th row of data from a worksheet in a new .
One way would be to use a helper column, listing 1-5, 1-5, 1-5 etc down the
column and then using the AutoFilter to pick out the rows with the 5 on
them.....

Vaya con Dios,
Chuck, CABGx3




"jct" wrote:

Need to display every nth row of data from an existing worksheet into a new
worksheet. Any suggestions? Thanks
Reply With QuoteReply With Quote