Evening guys,

I am looking for a solution to an excel problem I have. I think a macro is required and although I have bought Excel VBA programming for dummies I haven't got round to getting through it in enough detail to solve my problem.

Basically I want to calculate a non-utilisation fee for a bank account (i.e. if i have a loan for £100 - but i only withdray £75, I pay a fee on the remaining £25). Sounds simple enough but I have a lot of accounts and want to calculate this fee on a daily basis for a specified period based on the following inputs:

Account number - e.g 12345678
Account Limit - e.g £100 in example above
Fee - percentage that is charged i.e. 1% per annum
Dates - e.g 1/1/10 to 31/3/10

Now this data needs to pick up the account number (in column B of another worksheet) then scan along the daily balances to pick up the dates (added complication is that balances will only be available for workind days) and the appropriate balance in the rows. It then needs to calculate the applicable non utilisation fee for each day and sum this total for the specified dates above.

If anyone could help me with this I would be very grateful, I always thought I was a good on excel but when it came to this problem I was stumped and feel that a macro is required which is definetly not my strong point!!

If anyone needs more information please let me know and all replies are much appreciated.

Fonzie