Use an inputbox or form to ask your questions and have a macro that finds
the lastrow on the other sheet
lr=sheets("destsht").cells(rows.count,1).end(xlup) .row+1
range("b2").copy sheets("destsht").cells(lr,1)
Post back with your coding efforts for comments.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Iain" wrote in message
...
Hi

I am trying to create a macro that copies information put on one
worksheet,
and places it into the corresponding area on another worksheet. I am
trying
to get it so that i can click on a "new data" macro that will be placed on
worksheet "Menu", and I am asked a series of 4 questions that require an
input and these answers are placed in the relevant place on worksheet "B".
Answer 1 goes in "C5", answer 2 goes in "D5", answer 3 goes in "H5" and
answer 4 goes in "I5", but each time it is "run" it starts on the next
available row. I have done this in the past for a previous employer, and
i
now i have come to build a sheet for my own use i cant remember how it is
done.

Please can someone stop me from pulling my hair out.

Thanks for looking,

Iain