I know it doesn't help with this problem, but when you said that you use this SS to track clients and their purchases, I was thinking that you might want to look at using a database program instead of Excel.
Solved: Asking too much from excel?
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?
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?
- Status
- Not open for further replies.
1 - 1 of 5 Posts
1 - 1 of 5 Posts
- Status
- Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
