monthly debit entry

[tantrick]

hello :
i'm a relative novice to excel, and although i've searched excel's help indices. I haven't yet been able to find a solution to what I think is a fairly straightforward question. Hope someone can help. I'm designing a no-frills domestic accounts spreadsheet, organised as an ongoing monthly record of income and expenditure and provide up to date balance information. Some of my current expenditure is in the form of several separate direct debits - amounts paid regularly each month to energy suppliers, isp providers etc. Since these monthly amounts are usually the same, and debits take place on the same date each month, is it possible to have excel automatically copy a single row entry across all the monthly pages without having to copy and paste the original debit information each time a new month begins?

many thanks for your time

[ajryan88]

A couple of options you have are:

Option 1
If each worksheet already exists for the future months, then simply copy the debit information from an old worksheet, then select all future worksheets (using Ctrl or Shift), and then paste the information on one of these worksheets. This will paste the debit information onto each of the worksheets for you, and you only have to paste once.

Option 2
I suspect this is more likely going to be the correct scenario for you, but this will work if you create a new worksheet at the beginning/end of each month. You will need to use VBA for this.
Firstly, lets assume that the debit information that you want to copy is contained in cells A1:B5, and you have an old worksheet named "Jan-2013" (change this information in the VBA code below to whatever is appropriate to your data). Secondly, you will need to paste this code into the ThisWorkbook module of your workbook:

Please Login or Register  to view this content.

Option 3
The third (and probably simplest) option that you have would be to copy an existing worksheet and paste it as your new worksheet, remove any data that you don't want and leave the data that you do want, and then rename the worksheet.

Hopefully one of these solutions has helped you.

[tantrick]

Thanks ever so much for your reply. Seems like one way or the other copying and pasting seems to be the most realistic option for me. I'm amazed that a program as supposedly as sophisticated as Excel doesn't appear to offer an option for performing what is surely quite a routine task.Maybe a dedicated domestic accounting package might be more appropriate? Oh well :/ Thanks again for your time and help

[ajryan88]

You're welcome, I'm glad I could be of assistance.

Please don't forget to mark this thread as solved and add to my reputation if you are satisfied with the outcome