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

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 columns
have headers the name associated with column H, check the Ascending box
and click OK


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399485