tough date macro....help needed....

S

Sam

hello there ...
i need some help from some of the expert excel vba guys out there ...
in column A ...from cell A1...i have 5 stock names....

A
B
C
D
E


in column B i have allocations in %....say 15%....for the 5
stocks...each,.....so now...total alloc....is 75%....the remainng is
kept as cash ...in cell A6...ie 25%.....
as total has to be 100%..
now in column C ...i have call back dates.....
31st oct 2005
15th aug 2005
30th june 2005
31st oct 2005
31st dec 2005.....

now in column D i have notice periods......
15 days...
30 days...
45 days
30 days...
15 days....

now ...what i want to do thru the macro is as follows :

in cell H1 ...i have todays date = today()...
and cash as of now is 25%....
i want the macro to find out the first earliest call back date....and
then
redeem the corr stock.....taking into consideration the notice
period.....state the notice period....in column E ....and then
allocate that amount from column B....to cash....

so in the above ex....
IT is stock C....
with alloc....15%..
and notice period....45 days....
so.....if call back date....is 30 june......
15 april.....stock C shud be called back.....as notice period is 45
days...
and that 15 % ....shud be ...now added to cash......ie 25% + 15 % =
40%.....


then the macro shud go n find the 2nd stock...3rd stock......4th stock
and so on......

pls help me in this...as i am in gr8 need of such a tool....
ur help wlll be greatly appreciated...

thanks

sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top