Date input table different for each different process? Excel 2007

[aph]

Hi I used to work at a facility where you worked down an excel spread sheet as you added a process you clicked a button and the new process and all it's date tables appeared under the current one (I think all the template individual processes were on a seperate work sheet in the same work book) any idea how I do this in excel?

So basically I'm working on the sheet click Process A button and all the boxes I need to fill in for process A appear under the current process.

Cheers for any info or info as to what this way of doing things is called in Excel so I can do some more research via the web.

 

[SkipVought]

Hi,

So what's the problem with entering a new row of data at the bottom of your table?

Sure, a FORM might be nice, but that also takes some design and macro programming. Is the added value worth the additional effort, and do you have the knowledge & skill to make it?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[aph]

Because the next process is different from job to job.

So for product A you may need process A ,B & C
For product B you may need A, Z, B

Hence why I want to add the section to the form as and when needed. I've done Access data bases, qualified in application programming and web design so I think I can do it it's just how I do it I'm a bit mistified on.

So is it a form I need as the orginal I saw was just a spread sheet that allowed you to add the next section depening on the process???

 

[SkipVought]

How do those different processes MAP to your database/table?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[aph]

However I want the data base and tables are not done yet.

 

[SkipVought]

???

Please be clear.

So for product A you may need process A ,B & C
For product B you may need A, Z, B

[TT]
Product Process
A A
A B
A C
B A
B Z
B B
[/TT]
Pretty simple.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[aph]

Why are you even bothered in this method above?

All I want to know is how to add a section to a excel spreadsheet (or form) it it pointless doing it as you are saying as there are 55 + processes and 1000's(it's actually limitless as we do custom jobs as well) of different products. To do it as you are doing is excactly why i asked the orginal question.

I will need to define the 55 processes but then add them to the job sheet as and when the product may or may not require it.

The as job A comes along add the processes that product needs on that job.

Next week product A could come in again but they only want a few of the processes done so those only need adding to the final job sheet.
---------------------------
So the form/spread sheet will have a certain ammount of normal data at the top of the form E.G customer delivery date etc
-------
Then next will be a list of the processes as buttons when you click on a button the table for operators to enter data for that process will then appear for them to fill in. Once this process is done they click on a button and hey presto
--------
then next process will appear for them to fill in and so on and so forth.
---------------------------

The idea being only the process actually being used will be there for the operators to enter the data for that process without have a bloody long spread sheet/form that operator have to scroll down until they get to the bit they need.

Skip this is not a points gathering thing I just want to know how the bloody hell to I make it as flexable as i have described above I'm sure your a much better programeer than i'll ever be and to be honest I won't loose any sleep over it but if you cannot just tell me how it's done or the method of how to do it don't bother replying YOU do not need to worry about the processes at all or the product i just wanto know how to pull a section into a form/spread sheet thats all.

 

[xlhelp]

Wow! A scholar and a gentleman!

Canadian eh! Check out the new social forum Tek-Tips in Canada.
I should live a long time - I eat a lot of preservatives.

 

[Gruuuu]

aph, with an Access Database background, you should be able to set up tables in a database and use queries to generate lists of available processes dynamically, as it seems you are attempting to do.

If you wish to go that route, I suggest doing a little research in that direction and posting your updated question in

http://tek-tips.com/threadminder.cfm?pid=707

Furthermore, I suggest being a bit more gracious of people attempting to help you for free, considering that the people with the knowledge to do so generally get paid for the content knowledge they so freely distribute.

 

[aph]

Well from where i was sitting SkipVought was just coading me and taking the piss he did not have to help me at all he just made the question more complicated than it needed to be and from my point of view that was deliberate IMO

xlhelp thanks for your helpful input

Gruuuu thnaks for the heads up and information I'll look in that direction.