Hello,
I have a workbook with 20 sheets, mostly consisting of dates and costs (the workbook is to keep track of all the income/outgoings of a small business) An current bank balance amount is entered at the start of the month and checked daily. Every debit that has been paid can then be marked off the workbook, (so far, so good).
The fixed costs that are paid every month on the same date are also done manually.
The way it is done at the moment uses a drop down list with "Paid", then on another sheet is the formula, =IF(Jan!$D2="Paid",Jan!$C2,0)
Now the question,
Is it possible to automatically mark off a payment by using the system clock?
Something along the lines of, when the due date is current, the cell will display "Paid" (if this is possible, I wont have to change any other formulas)
Also, is there any set time that this should run, before opening, midday, closing time?
If the answer is VBA, could you be specific as to where to place the code, ( still learning).
Many thanks
Colin.
I have a workbook with 20 sheets, mostly consisting of dates and costs (the workbook is to keep track of all the income/outgoings of a small business) An current bank balance amount is entered at the start of the month and checked daily. Every debit that has been paid can then be marked off the workbook, (so far, so good).
The fixed costs that are paid every month on the same date are also done manually.
The way it is done at the moment uses a drop down list with "Paid", then on another sheet is the formula, =IF(Jan!$D2="Paid",Jan!$C2,0)
Now the question,
Is it possible to automatically mark off a payment by using the system clock?
Something along the lines of, when the due date is current, the cell will display "Paid" (if this is possible, I wont have to change any other formulas)
Also, is there any set time that this should run, before opening, midday, closing time?
If the answer is VBA, could you be specific as to where to place the code, ( still learning).
Many thanks
Colin.