delete data in horizontal table based on a cells value

[grantastley]

Hi

I am trying to delete data in a horizontal table based on a cells value. bellow is a basic setup of how the table is.

----A--B--C--D--E--F--G
1---10
2
3---1--2--3--4--5--6--7
4---a--c--e--g--i--k--m
5---b--d--f---h--j--l--n
6
7---8--9--10--11--12--13
8---o--q--s---u---w---y
9---p--r---t---v---x---z

Basicly I would like to delete the data
- i to z if 4 is entered in cell A1 (ijklmnopqrstuvwxyz)
- u to z if 10 is entered in cell A1 (uvwxyz)
- and so on
I can do this using if statements and clearcontents however the code goes on and on forever as the table is quite large.
once again any help/ideas will be appreciated.

[grantastley]

So this is what I have

Please Login or Register  to view this content.

and this is only 2 cases out of 7 and 2 tests out of 5.
Is there any way of condencing this?
P.S this code does not relate to the above table. But is for the same question, the table above was only a quick thing I put together as I can not upload an attachment from the work computer.