Sorting Question

..A......B.......C..........D...........E...........F.........G..........H.......I.........J
REQ# PO# Book VENDOR CHARGE CONTACT DESC VEHICLE DATE PRICE


I setup a spreadsheet to track requisitions. The cell range is from A to J.

If I try sorting cell E in ascending order so I can group requisition by departments... the sort doesn’t work equally across the rows. It seems to change the requisition number (cell A) with the improper sort.

How can I sort a particular cell and have it work maintaining holding together the cell information across the entire row of cells?

Hope I’ve made myself clear
Thanks

Originally Posted by NBVC

Try selecting the entire range first, from A1 to J(whatever the last is).

and it still messes up. The odd thing is... it seems just Cell A (requisition Numbers) is having the problem.

When I do the Data/Sort/Column E - Ascending = problems with Cell A

When I highlight the entire range and then Data/Sort/Column E - Ascending = problems with Cell A

In both cases, after sorting, Cell A shows the worng Requisition Number

Originally Posted by oldchippy

Are you sure your "Requisition Number" is formatted to Number or General and not formatted Text

Yup, formatted to General.

I use the formula =A1+1 and filled down using that to generate the Requisition books numbers. When I do a sort that formula is still there calculates just as its intended to but since it now points to a different number... it generated a different number.

I guess i can't use that to fill in numbers in sequence any longer, or is there a way around that?

Thanks

Originally Posted by NBVC

I didn't see any formulas in the sheet you sent

You will have to copy and paste special|Values over the original if you want you numbers to stick to the rows they were originally part of.

Thanks for your help. All is well now.

Thanks again