Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting number of cells that make up a sum.. | Excel Discussion (Misc queries) | |||
how to sort anything that looks like a number as a number | Excel Discussion (Misc queries) | |||
Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
How do I sort linked cells ? | Excel Discussion (Misc queries) | |||
Counting the total number of cells with specified condition(freque | Excel Discussion (Misc queries) |