G
Grek
Hi All,
I'm working an a small macro to make my daily work easier
Unfortunately I'm not good enough in excel to make it 100% by myself
That's why I would really much appreciate your help on this ;-)
I've attached the file in this post.
Here is the problem :
Below are the datas from the sheet "Estim - FX contracts by Fund"
SELL JPY 496.000,00 BUY USD 16/07/2004
SELL USD 15.234,59 BUY EUR 19/07/2004
BUY EUR -8.711,74 SELL USD 19/07/2004
SELL USD 630.909,49 BUY EUR 19/07/2004
SELL CHF 136,78 BUY EUR 19/07/2004
BUY USD -11.563,43 SELL JPY 16/07/2004
BUY USD -10.168,00 SELL JPY 16/07/2004
BUY USD -398,02 SELL JPY 20/07/2004
Here are the results from the sheet I would like to be generate
automaticly in the sheet "Estim -Aggregate FX contracts". It's in fac
a summary of the above datas by currency and same value date.
SELL JPY 496.000,0 BUY USD 16/07/2004
SELL USD 646.144,08 BUY EUR 19/07/2004
SELL CHF 136,78 BUY EUR 19/07/2004
BUY USD -21.731,43 SELL JPY 16/07/2004
BUY USD -398,02 SELL JPY 20/07/2004
BUY EUR -8.711,74 SELL USD 19/07/2004
For instance 646.144,08 is the sum of those 2 lines :
SELL USD 15.234,59 BUY EUR 19/07/2004
SELL USD 630.909,49 BUY EUR 19/07/2004
Does anyone has an idea how I could do that ? I don't think tha
sumprod would work in that case. Would it ?
Thank you very much in advance,
Gre
Attachment filename: gregsmacro.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=62035
I'm working an a small macro to make my daily work easier
Unfortunately I'm not good enough in excel to make it 100% by myself
That's why I would really much appreciate your help on this ;-)
I've attached the file in this post.
Here is the problem :
Below are the datas from the sheet "Estim - FX contracts by Fund"
SELL JPY 496.000,00 BUY USD 16/07/2004
SELL USD 15.234,59 BUY EUR 19/07/2004
BUY EUR -8.711,74 SELL USD 19/07/2004
SELL USD 630.909,49 BUY EUR 19/07/2004
SELL CHF 136,78 BUY EUR 19/07/2004
BUY USD -11.563,43 SELL JPY 16/07/2004
BUY USD -10.168,00 SELL JPY 16/07/2004
BUY USD -398,02 SELL JPY 20/07/2004
Here are the results from the sheet I would like to be generate
automaticly in the sheet "Estim -Aggregate FX contracts". It's in fac
a summary of the above datas by currency and same value date.
SELL JPY 496.000,0 BUY USD 16/07/2004
SELL USD 646.144,08 BUY EUR 19/07/2004
SELL CHF 136,78 BUY EUR 19/07/2004
BUY USD -21.731,43 SELL JPY 16/07/2004
BUY USD -398,02 SELL JPY 20/07/2004
BUY EUR -8.711,74 SELL USD 19/07/2004
For instance 646.144,08 is the sum of those 2 lines :
SELL USD 15.234,59 BUY EUR 19/07/2004
SELL USD 630.909,49 BUY EUR 19/07/2004
Does anyone has an idea how I could do that ? I don't think tha
sumprod would work in that case. Would it ?
Thank you very much in advance,
Gre
Attachment filename: gregsmacro.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=62035