Hi I use excel to keep track of my transactions i.e. credits at my bank account. I would like if possible to have excel automatically add a date in a new row such as a30 and in the next column the figure £200 on a couple of work sheets, how can I achieve this? It will save me having to do it manually. When I start a new row, I put the date i.e. the 20th of may and in column b the amount. Excel adds the 200 to the total credit. I have another spreadsheet in the same workbook and I would like excel to do the same thing on a regular day in the month to subtract from the total. Regards Adrien You can get me off list at: adriencollins06@xxxxxxx or adrien_collins@xxxxxxxxxxx Or adrien.collins@xxxxxxxxx Speakon is a free fully self-voicing accessible multimedia program for the visually impaired, find out more by downloading the software from: http://www.a-technic.net/speakon.htm You can join the speakon user group by sending a blank e-mail to: speakon-subscribe@xxxxxxxxxxxxxxx ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq