Sort data and copy another cell

[boyblundell]

Few things i need help here please.

I need to sort data in a column which is = to a value in another cell on another work sheet.

Once this data has been filtered and sorted i need copy it to another worksheet, but also bring over some information from another column.

I then need to select the highest four values from this column and add them up.

However the data can be forever changing.

Can anyone help.

Regards

[c_m]

not sure what you mean by "I need to sort data in a column which is = to a value in another cell on another work sheet."

but if you are doing this to just find the sum of first four highest values...try:
=SUMPRODUCT(LARGE(A:A,{1;2;3;4}))

adjust the formula for if statement to incorporate the condition