automation of accounts workbook

Hi all
I need help in creating a workbook for my checking account. From this account I issue post dated checks to my suppliers. The procedure I want is to enter the checks data in one main sheet “chq book”. And I want excel to create month sheet automatically according to the date of the checks and the detail of the checks to be copied to the month sheet automatically. And when the due date comes I will reconcile the checks from the month sheet. And when I reconcile the check in the month sheet then the detail of the check should automatically be copied to the last empty row of the sheet “main account”. Because the deposits will also go to the “main account” sheet.
The main requirements are as follows
1. A new sheet should be created automatically according to the due date of the check. And if I enter more checks in the same month they should automatically go to that sheet. And when I enter more and more checks they should be sorted date wise.
2. When a check is issued in a new month then the new month sheet should be created automatically.
3. If I edit or delete any data from the main sheet “chq book” the data in the corresponding month sheet should be updated automatically.
4. When I reconcile a check the data of the check should be copied to the last empty row of the “main account” sheet.
5. I need the same formatting as it is in the sample sheet.


Any help will be appreciated.

Please Login or Register  to view this content.

thank you Mr. TMS for your response.

I posted the question for help. its not dependency on others.

the automation may not seem necessary for you but it is for me.

any ways thanks a lot.

Thank you both TMS and Newdoverman for the explanation.
I think I have used wrong wording to describe my need (automation).
any ways I thank both of you from my heart.

as I have very little basic knowledge about excel and you people have lots of knowledge about excel. and you can do the job many different ways. And I Thought to solve the problem this way but you people moved me in correct direction.

before this I had no idea about the pivot table.
but now I got the idea and I think this is the best and simple solution for my problem.

once more thanks a lot for the help.

@TMS
@newdoverman

I feel some difficulty in this way. I hope you will understand.

this solution will work for the current dated checks. but if the check is due after 60 days then what will be the scenario?

@TMS

thank you for the response

but you are not getting my point.

the main point is that I want to keep the detail of the post dated checks and on other sheet I want to keep track of my current account also.

in your example I can keep track of all the checks. and from this example I understood that there is no need to create so many sheets for separate months.

but in my sample workbook I also created a second main sheet named (main account) in which I keep track of the deposits also. and what was my point that when a check is cleared the following should be the procedure.

when I reconcile the check from the checks sheet its data be copied to the last empty row of the accounts sheet . so that beside keeping track of the checks I can keep track of my bank account also

hope you understood what I wanted.

thanks again