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!
|