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

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