Need Help...

[harsh90]

Hallo all.

My name is Har**** and I am new to big formulation of formulas or VBA. Currently I have a problem in which I need to combine certain sheets in one sheets. I have given link of my sheet to see what it looks like. There are 4 sheets which contains different norms and its descreiption what they are used for. In the sheet named "TZ und Normen", its the sheet were it contain technical drawing number and the certain norms from earlier 4 sheets. In the sheet called Dashboard, this is where it should be combined. When for example, in Dashboard sheet, in front of TZ 1, when I enter the norms from sheet TZ und Normen as listed, in sheet Dashboard, it should notify me that yes the norm is present in the 4 sheets. If the norm is not there than it should notify add the norm.

Please help me out im this situation.

My file : https://drive.google.com/file/d/0B5gUJCTN2BcnOTdBX1ZkcEhOWlE/view?usp=sharing

Waiting for the valuable replys.

MfG

Har****

 

[iliace]

I hope I understand your question correctly.

On Dashboard sheet, in B4, I enter this formula: =IF(ISNUMBER((MATCH(B$2, INDEX('TZ und Normen'!$A$4:$G$13, MATCH($A4, 'TZ und Normen'!$A$4:$A$13, 0), 0), 0))), "Normen", "")

Copy this formula to B4:OK13.

Each cell that has a matching value in the "TZ und Normen" sheet will display the word Normen where it is required, indicating that you have to enter a value. Otherwise, it is blank.

Does that help?

 

[harsh90]

Thank You @iliace.

Ja, that is what I am looking but it should give the same name that is in sheet "TZ und Normen" and not Normen. For example, in B4 it should come DIN 1 and not Normen and so on for the other as in fornt of TZ 1 it is DIN 1 and so on.

Waiting for your valuable reply and thank you for valuable time.

ich danke ihnen im voraus.

MfG
Har****

 

[harsh90]

Thank You @iliace.

Ja, that is what I am looking but it should give the same name that is in sheet "TZ und Normen" and not Normen. For example, in B4 it should come DIN 1 and not Normen and so on for the other as in fornt of TZ 1 it is DIN 1 and so on.

Waiting for your valuable reply and thank you for valuable time.

ich danke ihnen im voraus.

MfG
Har****

Also there are some norms for example TL 193, DIN 167, VDA 115 which are not in sheets DIN, VW, VDA, TL [DIN, VW, VDA, TL sheet have norms 1 to 100]. But as they are in TZ und Normen, it should notify in Dashboard sheet that the respective norm is not in the DIN, VW, VDA, TL sheet [Here for example TL 193. So in Dashboard it gives for example a cross or red backgroud which shows it is not in the TL sheet and so need to be added.When it is add in TL sheet, cross or red background will go and show the norm ie TL 193.Same for other]. So when I add that Norm in the respective sheet [DIN, VW, VDA, TL],than in Dashboard sheet it should again display the norm and not the message.

 

[harsh90]

I hope I understand your question correctly.

On Dashboard sheet, in B4, I enter this formula: =IF(ISNUMBER((MATCH(B$2, INDEX('TZ und Normen'!$A$4:$G$13, MATCH($A4, 'TZ und Normen'!$A$4:$A$13, 0), 0), 0))), "Normen", "")

Copy this formula to B4:OK13.

Each cell that has a matching value in the "TZ und Normen" sheet will display the word Normen where it is required, indicating that you have to enter a value. Otherwise, it is blank.

Does that help?

Thank You @iliace.

Ja, that is what I am looking but it should give the same name that is in sheet "TZ und Normen" and not Normen. For example, in B4 it should come DIN 1 and not Normen and so on for the other as in fornt of TZ 1 it is DIN 1 and so on.

Also there are some norms for example TL 193, DIN 167, VDA 115 which are not in sheets DIN, VW, VDA, TL [DIN, VW, VDA, TL sheet have norms 1 to 100]. But as they are in TZ und Normen, it should notify in Dashboard sheet that the respective norm is not in the DIN, VW, VDA, TL sheet [Here for example TL 193. So in Dashboard it gives for example a cross or red backgroud which shows it is not in the TL sheet and so need to be added.When it is add in TL sheet, cross or red background will go and show the norm ie TL 193.Same for other]. So when I add that Norm in the respective sheet [DIN, VW, VDA, TL],than in Dashboard sheet it should again display the norm and not the message.

Waiting for your valuable reply and thank you for valuable time.

ich danke ihnen im voraus.

MfG
Har****