I think I do something similar with a form and some VBA code behind it for my "To Do" lists (I always seem to have a myriad of things to do - work, house, computer, etc. - each one being a different worksheet that is opened when I select the tab on the form). But Rollin is right. We need a little more information and a sample workbook (sanitized so that no real information is in it - we don't need live data) would greatly assist us in determining what the best solution is.
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
