Sorting

[Guest]

Can anyone help me with this? Below is a sample of the spreadsheet I'm creating. I am compiling a list of tapes along with what spots are on each tape. I'd like to sort the list by Column A, Tape Name, but keep the Spot Names in Column B and Spot Length in Column C with the correct Tape Name.

Column A Column B Column C
(Tape Name) (Spot Name) (Spot Length)
MTV Promo :30
TNT Nascar1 :30
Nascar2 :30
Nascar3 :30
FOX Spot A :30

Any way to group rows together so they will stay together when sorted?

 

[hcj]

Hi Viki,
Sorting should work just fine as long as you select all
columns and rows to be sorted and use Data/Sort.
Selection should be automatic if you start with the cursor
in any one of those fields and then use Data/Sort.
Make sure there are no blank columns or rows in the
data set - those will mess you up.
Do NOT use the A/Z sort buttons - they'll scramble your
data! As a user of both Access and Excel, I finally
removed the A/Z sort buttons from my Excel toolbar just to
avoid making that mistake.

Good luck.

-----Original Message-----
Can anyone help me with this? Below is a sample of the

spreadsheet I'm creating. I am compiling a list of tapes
along with what spots are on each tape. I'd like to sort
the list by Column A, Tape Name, but keep the Spot Names
in Column B and Spot Length in Column C with the correct
Tape Name.

 

[Vasant Nanavati]

You will have to first fill in the blanks in column A.

--

Vasant

Can anyone help me with this? Below is a sample of the spreadsheet I'm

creating. I am compiling a list of tapes along with what spots are on each
tape. I'd like to sort the list by Column A, Tape Name, but keep the Spot
Names in Column B and Spot Length in Column C with the correct Tape Name.