Reserve an exclusive range of cells/columns dependant on criteria

[KLUMPS]

Hi Guys,

help! I'm trying to select ranges dependant on certain criteria

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]model[/TD]
[TD]Partno.[/TD]
[TD]pass /fail[/TD]
[TD]qty fail[/TD]
[TD]serno (fails )[/TD]
[TD]root cause[/TD]
[/TR]
</tbody>[/TABLE]

model , partno & pass/fail , qty fail will be common throughout. data will be entered sequentially.
I would like to to reserve a range serno (fails) & root cause depending on whether pass/fail selected. and enter data in that range dependent on qty fail.
i'd like to revert back to the main sequence afterwards.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]a[/TD]
[TD]1a[/TD]
[TD]fail[/TD]
[TD]3[/TD]
[TD]101[/TD]
[TD]top[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]104[/TD]
[TD]bottom[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]105[/TD]
[TD]side[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]1b[/TD]
[TD]pass[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]1c[/TD]
[TD]pass[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]1d[/TD]
[TD]fail[/TD]
[TD]1[/TD]
[TD]201[/TD]
[TD]top[/TD]
[/TR]
</tbody>[/TABLE]

all suggestions appreciated
CHEERS

 

[KLUMPS]

ok HAVE GIVEN UP ON THIS IDEA AND USED A PIVOT TABLE TO SUMMARISE THE DATA