LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Sort a small number of cells

I have an excel spreadsheet with 2 columns per day of the month, one for
check number and one for the amount of the check. Rows 1-5 are frozen because
they contain headings. Rows 6-20 are for Company A, rows 21-35 are for
Company B, rows 36-50 are for Company C, and so-on. What I need to do is put
the checks for one day and for one company in order so I can find them more
easily on a separate list that has check numbers in numerical order.
Essentially, I need to put an area of 2 columns by 15 rows in numberical
order without changing anything else on the spreadsheet.

I have one document that will allow me to do this, and one that will not.
When I try to do this on the second document, it puts the 15 rows in the
correct order but moves every cell in the rows instead of just the ones I
selected.

Any help would be greatly appreciated!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting number of cells that make up a sum.. tim m Excel Discussion (Misc queries) 2 September 21st 06 02:55 PM
how to sort anything that looks like a number as a number cyndiwise notsowise Excel Discussion (Misc queries) 4 August 29th 06 08:19 PM
Excell-How to add the number of cells containing text? = a sum aruba64taw Excel Worksheet Functions 2 December 21st 05 09:51 AM
How do I sort linked cells ? karen Excel Discussion (Misc queries) 5 November 12th 05 11:25 PM
Counting the total number of cells with specified condition(freque Kelvin Excel Discussion (Misc queries) 2 July 10th 05 12:22 PM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"