multiple sort function and combine cell

[yeahremy]

Hi,

Am trying to do a macro to sort thing data that we have but its above my skills so if anyone can help.

I have attached a spreadsheet.
In Sheet1 is what we have. then detail and average is what we should obtain at the end.

in detail sheet:
Column A (take from Sheet1/Order OrderSide column with 1=Buy and 2= Sell)
then the others cells are sorted
1- by exchange (replacing code in Sheet1/columnK by the code table in Ex Code sheet
2- by strike in column F
3 -by Option Type (Call/Put)
4- by price

column E,F and G are a split of Column F in Sheet1.


in average sheet:
we need an average (price) of the detail in Sheet1. so we need 1 line per exchange per structure
line 2 for example is equal to the sum of size in Sheet1/Quantity per structure and column H is the average price (sum Column G divided by Sum Column D) per structure

let me know if you can help and if you need more information/clarification

really appreciate

[yeahremy]

I really need some advices on that one. Is there anyone you can help me out ?

[arlu1201]

For the sorting part of "detail" sheet, you want the sorting to be done by the sort command in excel right?

For the 2nd part - "Average" sheet, which columns denotes the change in structure, so we know which cells should be combined for averaging?

[yeahremy]

to avoid confusion, going forward we will input on sheet1 only 1 ticker (or structure if you prefer so only CVX or LNC on this case...keeping in mind there is about 200 other names we use) then the detail and average will be based on that

for the detail sheet. it must be sorted by strike, then option type then price if possible (descending is preferable) the idea is to have only 1 line if strike/options type/price
are equals. we need to do that for each "comment" type (CBOE,ISE, etc...)

for the average sheet, there is no structure issue as there will be only one underlying security code or ticker. as its an average we need to get one line for each strike/options type. same we need to do that for each "comment" type (CBOE,ISE, etc...)

thanks very much