I am running excel 2000 within Office 2000 pro.
I am revising an account file that I use in the course of my business.
At the moment it is very bulky as I need to have a separate sheet for the breakdown of each persons individual purchases. These sheets are in the file even though they may not all be used.
These separate sheets are accessed and modified by the cover sheet when the primary client details are entered, and not all the sheets are necessarily used at the time.
Is there any way that a secondary sheet will be raised only when the client's primary information is entered on the cover sheet.
I have been through all excel help sites that I can find and referred to the excel books that are currently available.
I am thinking that this will not be possible. Any thoughts?