Thread: Can excel to pull out every tenth row into a separate sheet? How?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Can excel to pull out every tenth row into a separate sheet? How?
Assuming shots are in Sheet1 Column A

=INDIRECT("SHeet1!A"&ROW()*10)

Entered in A1 of a new sheet.

Copy down as far as you wish.


Gord Dibben MS Excel MVP

On Mon, 25 Jun 2007 14:16:02 -0700, Eileen
wrote:

I have a huge series of Surveying shots (P,N,E,Z,D) and I would liket o pull
every tenth shot out and into a separate sheet. Any advice?

Reply With QuoteReply With Quote