Sort Prices into Ascending Order

[theColster123]

Hi Guys.

I was just wondering, is this possible:

I have a worksheet that calculates the cheapest price of some items. In column B are the item names, in column C are the descriptions, and in column D are the prices.

Is it possible, in a new worksheet, to sort the data into price ascending order?


EDIT: I have Excel 2003, and I'm using Windows 7.

 

[tusharm]

Copy the data to the other worksheet (use Paste Values to ensure you get only the values), then sort the data.

 

[theColster123]

Thanks, didn't realise it was that easy. Thank you.

 

[tusharm]

You are welcome.