Ascending order sort..

[ChrisB]

my spreadsheet consists of about 7 columns of data, each row has
relevant data that corresponds to each column in that row. For example,
in Row 1, I have A which is product, B which is description, C which is
price, D which is stock, and so on. I had to sort column A in ascending
order for me to be able to perform a VLOOKUP. Now that ive sorted A in
ascending order, that has completely screwed up my spreadsheet, it
threw off all my product IDs so now they dont correspond with the
descriptions or price anymore! is there anyway that when I sort by
ascending order the column I want, it will take everything else in that
row with that perticular column ?

 

[Peo Sjoblom]

Select the whole table before you start sorting on A

Regards,

Peo Sjoblom