[deepdiver01]

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?

 

[Rollin_Again]

I'm not trying to be rude but your description is very vague. Is it possible to .ZIP and post a sample workbook so that we can better understand what you are asking. Try to be a little more detailed in explaining what you are currently doing from start to finish and I'm sure someone will be happy to help including myself


Rollin

 

[ddockstader]

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.

 

[kenneth2k1]

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.

 

[deepdiver01]

Thanks everyone for the input.

It is pretty well decided that I will not be able to raise a new sheet automatically as I would have liked to.

I can only do it within 1 sheet.

Never mind. I wilkl just have to work around it.

Thanks again.