MrExcel Publishing
Your One Stop for Excel Tips & Solutions

An automated daily balance sheet


Posted by Oguz N. SAYINER on December 13, 2001 1:35 AM

Hi from √Ěstanbul, Turkey. I would like to create an excel workbook which creates a daily balance sheet (with the same format like previous ones) everytime you press a button and copies the values of previous daily assets to the new sheet and name the worksheet on the tag with the date of the day you create it.

I guess I need a macro to do it but I am really bad at it.

Thanks a lot in advance.


Posted by Verges on December 13, 2001 1:59 AM

I think you will need to provide more detail

Posted by Oguz N. SAYINER on December 21, 2001 7:33 AM

Re: I think you will need to provide more detail

Posted by Oguz N. SAYINER on December 21, 2001 7:57 AM

Re: I think you will need to provide more detail

The workbook I need to create is an daily balance sheet including that day's and previous day's figures (incomes, expenses, bank balances and a combination of simple summation formulas) in different columns.
Each time the workbook openned, it is to ask if an new worksheet is to be created. (A button will do fine for it.)

If it is required, the new worksheet will be named on that date (the date you create it) on the worksheet tag and, look like exactly the same with the previous worksheets in the format, but copy the figures on the previous worksheet's today column to the new worksheet's previous day column. So, new figures (of the day the new worksheet is created) will be added manually by the user in the columns of that day (named today). To put it short, current figures will be entered, and compared with the last figures comming from the previous worksheet.

I guess it is clearer now... If you help me with macro formulation to create a new worksheet everytime it is needed and to put that day's date on the name tag. I think I can handle the copy part in the macro code...

thanks for your interest... looking forward to hear from you.