Forum Home
Press F1
Thread ID: 60850	2005-08-15 08:44:00	MS Excel timed transaction	Eric1 (8728)	Press F1

Post ID	Timestamp	Content	User
381522	2005-08-15 08:44:00	I keep my bank accounts on MS Excel but have not yet worked out how to enter timed transactions. That would be for things such as pensions that have a regular timed re-occurrence. Is it possible to enter a formula of this type.	Eric1 (8728)
381523	2005-08-15 21:52:00	Im not sure what you mean Eric. You enter times in a cell like HH:MM (eg 08:50) or are you meaning you want a cell to change its value every so often. Could you give an example please.	Parry (5696)
381524	2005-08-16 04:11:00	Parry I want Excel to automatically enter my pension every 14days, so that I don't have to enter it manualy.	Eric1 (8728)
381525	2005-08-16 09:17:00	Hi Eric, you can have formulas which will look for a certain date then show an amount etc but the cell is static and may only be good for the next date rather than on-going. eg where the amount you receive would replace the example text below =IF(TODAY()=DATEVALUE("16/8/2005"),"Pension Due Today","No Pension Today") By the sounds of it you want a new row inserted into your list of financial transactions. This is certainly possible but only with a macro, not a formula. Im wondering how beneficial it will be though because it may get out of sync when there are holidays such as Christmas etc so I would need to understand the rules if you wanted me to attempt to write a macro for you. regards, Graham EDIT: Just thought of how it could work. I could have a date automatically entered into a cell which reflects the next date the pension is due. After a new row in inserted this date would be updated with the next one due in 14 days time. If the macro gets out of sync and the next pension date is not the date in the cell then you can manually amend this date and the macro will continue on 14 days from (and including) the new date you entered.	Parry (5696)
1