Reserve an exclusive range of cells/columns dependant on criteria

[KLUMPS]

Hi Guys,

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

model

Partno.

pass /fail

qty fail

serno (fails )

root cause

<tbody>
</tbody>

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.

a	1a	fail	3	101	top
				104	bottom
				105	side
a	1b	pass	0
b	1c	pass	0
c	1d	fail	1	201	top

<tbody>
</tbody>

all suggestions appreciated
CHEERS

 

[KLUMPS]

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