hi Mike,

Welcome to the Forum
Yes, this is definitely possible.

Have you tried searching the Forum for "delete rows" before posting your question?
(I know there a lot of threads returned for this search.)

In case you don't find anything suitable (?), here is a google search that shows a range of possibilities: http://www.google.co.uk/search?hl=en...G=Search&meta=
The dmcritchie, J-Walk & Ozgrid links are all worth a look.

If you would like more specific help, can you please upload a sample workbook with your existing layout?
It may also be useful if you could record a macro of your actions [alt + T + M + R] when doing this manually. We can then modify this code in the uploaded workbook to make it more flexible.

hth
Rob