sort rows in alphabetical order and move the corresponding data

L

lianeanddave

i have 100 rows and i have i have 8 columns 1 with newspaper name 6 with
dates that we are missing the voucher copy for and 1 with supplier name i
need to put the supplier name into alphabetical order but i need it to move
the newspaper name and date columns as well so that they all will be correct
if anyone can help asap i would be most grateful many thanks
 
P

Paul Sheppard

lianeanddave said:
i have 100 rows and i have i have 8 columns 1 with newspaper name
with
dates that we are missing the voucher copy for and 1 with supplier nam
i
need to put the supplier name into alphabetical order but i need it t
move
the newspaper name and date columns as well so that they all will b
correct
if anyone can help asap i would be most grateful many thanks
Click to expand...

Hi lianeanddave

Highlight all the data columns A - H(assuming data to be in columns A
H) , the Data > Sort > In the sort by select Column H or if the column
have headers the name associated with column H, check the Ascending bo
and click O
 
K

Ken Hudson

Hi,
If your data is in columns A through H, highlight cell A1.
Go to Data > Sort...
All cells with data should be highlighted.
In the "Sort by" drop down box select column H and the data should sort on
the eighth column with the rest of the data following it.
Does that answer your question?
 
S

Scott

First, highlight the entire section of the spreadsheet that contains your
list. Then, click on the "Data" drop down box and you will see an option
called "Sort". Click on that and a box will pop up that will give you
options as to which column to sort by. Choose the Supplier Name column to
sort by and click on the "Ok" button and your list will be sorted
alphabetically by supplier name.
 
Top