Sorting Data
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
|