I have a spread sheet with invoice numbers and info on it, I am wanting to
sort all of the invoice numbers to the correct order but at the same time
keep all of the relevent info with the same invoice number?? How do i do this?

Thanks

Molly,

If you select all the columns and sort on the invoice number column then all
the data remain intact and stay with their respective invoice number.

Mike

"Molly" wrote:

I have a spread sheet with invoice numbers and info on it, I am wanting to
sort all of the invoice numbers to the correct order but at the same time
keep all of the relevent info with the same invoice number?? How do i do this?

Thanks

Select entire area involved, then sort by the column or row that has the
invoice numbers in it.
--
Hazel


"Molly" wrote:

I have a spread sheet with invoice numbers and info on it, I am wanting to
sort all of the invoice numbers to the correct order but at the same time
keep all of the relevent info with the same invoice number?? How do i do this?

Thanks

Do you have one row of data per invoice number?

If so, make sure you select all colmns before sorting.

If you have an invoice number column then multiple rows of data for that
number you will have to first insert the invoice number into the blank
cells.

number1 data
blank data
blank data
number2 data
blank data

etc.

Easiest way to do this is select the number column and F5SpecialBalnksOK

Type an = sign in top blank and arrow up or point to cell above.

CTRL + ENTER to fill in the blanks.

CopyPaste SpecialValuesOKEsc.


Gord Dibben MS Excel MVP

On Fri, 14 Nov 2008 05:19:02 -0800, Molly
wrote:

I have a spread sheet with invoice numbers and info on it, I am wanting to
sort all of the invoice numbers to the correct order but at the same time
keep all of the relevent info with the same invoice number?? How do i do this?

Thanks