"TPSKAM" wrote in message
...
I am trying to utilize the sort function to sort multiple columns while
maintaining a grouping of cells. My need is to eliminate blank groups of
information and maintain the grouping of the information. The cells of
this
spreadsheet are set up to reference different tabs within the workbook. I
would like to sort the A-D group by column A, the F-I group by the column
F,
the K-N group by column K and also the O-R Group by column R. Utilizing a
standard sort will eliminate the blanks but I can't figure out how to sort
the parenthetical ranges to maintain the integrity of the information. My
example would be as follows while sorting the groups by it's first cell in
the parenthetical grouping. The skipped cells are empty columns within
the
spreadsheet.

(A1B1C1D1) (F1G1H1I1) (K1L1M1N1) (O1P1Q1R1)
(A2B2C2D2) (F2G2H2I2) (K2L2M2N2) (O2P2Q2R2)

(A4B4C4D4) (F4G4H4I4) (K4L4M4N4) (O4P4Q4R4)

Thank you for your help!!!

Greg K

I'm not sure I really follow what you're after, so ignore this if it isn't
what you want!
Are you are saying that information in columns A to D is to be sorted (by
column A), leaving columns F upwards untouched; and then columns F to I to
be sorted, leaving other columns untouched, etc.? If so, simply select
columns A to D and sort by column A. Then unselect these, select columns F
to I and sort by column F, etc.