Hi people

i have made a similar post to the above with reference to hyperlinking but also need help on this.

thank you for taking your time to read the post and i really hope you cna help.

i am a basic user of excel and am running excel 2007.

Background
I am a basic user of excel 2007.

I have created a simple accounts system which allows me to see my overall running balance on a day to day basis for all of my client's. So my current coloumns are;
A - Date
B - Client account number
C - Client name
D - Details of debit/credit
E - Debit coloumn
F - Credit Coloumn
G - Balance coloumn (Running balance of E & F & previous balance so the forumula currently is " =SUM(G1,-E2,F2 " and the formula for the balance under that would accordingly be " =SUM(G2,-E3,F3 " and so on)

This allows me to have one main ledger where i can incorporate all client monies coming in and going out and always know what the balance was on any specific date.

Problem
The above allows me to see day to day OVERALL balance and entries. I now would like to retian the above but when i update it on a daily basis with whatever money has come in and gone out i would like it to create or to the very least update sub-worksheets relating to individual client accounts.

so currently each client account is specifically identified by coloumn B the client account number. on the main ledger there will be a number of entries relating to that client account number. for example, on 1 january client account number "1234" paid in £100.00 and then on 22 january he paid out £50.00 and then on 25 january he paid in £100.00 so whilst individually his overall balance is now £150.00 i cannot tell this from the main ledger (as it holds every single client's accounts number details and alot more activities would have happened between 1 january to 25 january) unless i specifically track down each entry relating to the specific account number.

so can someone kindly advise me how i can create sub-worksheets so whenever i make a entry for account number 1234 ( or any other accout number) on the main ledger excel will create a sub-worksheet (does not matter if new file or in same file but preferablly in same file) and that sub-worksheet will only hold specific info for account number 1234. please note i do not want to be manually feeding both ledgers. i want to be feeding information into the main ledger and the main ledger to know which individual ledger it relates to and automatically fill the information in for me.

kind regards and i would like the reader to note i apprecaite any help given.

Asad

NB - my house is very cold at the moment and it is making my fingers cold thus affecting my typing so please xcuse the typing errors.