Excel problem

D

David

hi!

anyone knows how to perform the following tasks in excel?
I'm not very familiar with excel features. Can anyone help me on how can
that be done?

1) i want to link cells in sheet1 to sheet2, meaning that when i key in a
value
in one of the cell in sheet1, that value will also be displayed on sheet2.
2) from that sheet2, if i already got a list of cells with values there.
I would like excel to automatically sort the value(numeric) in ascending
order.
So that i can plot a paretto chart.

Thks!
 
Top