Hi Gurus,
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Emp name[/TD]
[TD]father name[/TD]
[TD]mother name[/TD]
[TD]Guardian name[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]XXX[/TD]
[TD]XXX[/TD]
[TD]XXX[/TD]
[/TR]
[TR]
[TD]david[/TD]
[TD][/TD]
[TD]XXX[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
i have a requirement in excel, i want to save an employee details name as Jmaes i need any one of father/mother/guardian columns row value should be mandatory for this requirement please help me with your solution like validation or macro.
if i miss provide the james father/mother/guardian details it should provide the error message like please provide james father/mother/guardian details.
Please help me on this
[TABLE="width: 563"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 563"]
<colgroup><col><col><col><col></colgroup><tbody></tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Emp name[/TD]
[TD]father name[/TD]
[TD]mother name[/TD]
[TD]Guardian name[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]XXX[/TD]
[TD]XXX[/TD]
[TD]XXX[/TD]
[/TR]
[TR]
[TD]david[/TD]
[TD][/TD]
[TD]XXX[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
i have a requirement in excel, i want to save an employee details name as Jmaes i need any one of father/mother/guardian columns row value should be mandatory for this requirement please help me with your solution like validation or macro.
if i miss provide the james father/mother/guardian details it should provide the error message like please provide james father/mother/guardian details.
Please help me on this
[TABLE="width: 563"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][TABLE="width: 563"]
<colgroup><col><col><col><col></colgroup><tbody></tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]