paulpatrick
Mechanical
I want to set up a spread sheet that breaks down each months bills into 4 weeks, that takes into account each weeks costs,earning and so forth.
I have a list of all costs and profits etc usually expected and listed. As each bill is paid one enters a tick or something in the box and it will carry the sums out.
How do I get excel to get it update the date accordingly each time its opened and show the correct week it falls into.
So it will let the user know what bills they have to pay and when they have paid it just tick off the box so the accounting pat is done?
Is this too far outside the realm of excel or what?
this is to be deployed then for use on a blackberry which, is why I need it to be justa tick the box thing.
I have a list of all costs and profits etc usually expected and listed. As each bill is paid one enters a tick or something in the box and it will carry the sums out.
How do I get excel to get it update the date accordingly each time its opened and show the correct week it falls into.
So it will let the user know what bills they have to pay and when they have paid it just tick off the box so the accounting pat is done?
Is this too far outside the realm of excel or what?
this is to be deployed then for use on a blackberry which, is why I need it to be justa tick the box thing.
