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?


--
Ken Hudson


"lianeanddave" wrote:

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