Hi Guys

I have an excel spreadsheet that contains data in the following format.
row 5 has in column A a row heading, row 6 another column heading etc down
36 rows.

I want to be able to move data along the row leaving the row heading and
paste it into another row again leaving the row heading. ie cut and paste.

the problem is multiple people will be using this spreadsheet with limited
PC/Excel skills.

So i would like to be able to prompt the user to say move the data from row
5 and paste it into row 34 using an input box.

eg if you wanted to move the data from row 5 it would be B5:H8 then paste it
into row 34 into B34:H34. With the user just entering 5 for "row 5" in the
from input and entering 34 for "row34" for the to input, the field range is a
constant its just the row that changes.

hope that makes sense, and that someone can help