View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve[_4_] Steve[_4_] is offline
external usenet poster
 
Posts: 184
Default Sort blocks of data as if each block was a single record

Hi all, not sure if this is possible or not. beginning on row 6 I
have several blocks of data. Each block is exactly 9 rows long, 40
columns wide. In the first row of each block(and only the first row
of each block), column A, there is an identifier. I would like to
sort based on that identifier, but each block has to stay in tact. So
essentially, each block of 9 rows must move together as if it were a
single row of data. Thanks for all of your help!!