YES/NO selective table

[Henkbos92]

Hello,

Who can help me with this problem.
I have a table with two columns "No Ageing failures" "Ageing failures", the table is related to a component and it has a standard table for each separated component.

I have questions that can only answered by yes or no and to answer these questions the table information can be shifted.

Example: Component sprocket
Question: End of designlife ? NO/YES
NO: the failures corrosion and fatigue are now shifting to the column "No Ageing failure"
YES: remain standing column "ageing failure"

 

[nuked]

What is the solution you seek?

btw, I lol'd at "Ageing failures". Plenty of those around free-excel-forums :D

 

[Henkbos92]

My solution Im seek is how to make a table that can shift information by questions that must be answered be YES or NO.

 

[Robert Mika]

My solution Im seek is how to make a table that can shift information by questions that must be answered be YES or NO.

Whre do you see the YES/NO?
In a cell next to the component?

 

[Henkbos92]

Whre do you see the YES/NO?
In a cell next to the component?

No not next to the component. The table has standaard information, but the information can be shifted by answering question below the table.

 

[nuked]

Can you upload an example? I (personally) don't have a clue what you are trying to achieve. What do you mean by 'move data'?

Why can't you have:

Component Ageing Failure
Sprocket No
Another1 Yes