Need a way to copy and past information

[CRS-]

Hello

i am tring to make a holiday rota and i am looking for away to copy information form one sheet to the next, on the click of a button and then delete the information on the first sheet, i will also need it to keep saving it to the next row when different data is added

i have uploaded my excel file to try explain what i mean

thank you if anyone can help

[BigDawg15]

CROSS POST

http://www.mrexcel.com/forum/excel-q...formation.html

Cross Posting is allowed as long as you include links to all your posts on other forums. This is one of the rules you agreed to when you joined this board and Excelforum.

Please read this: http://www.excelguru.ca/content.php?...-cross-posters to understand the reasons for this rule.

You might be interested to know that some people do not reply to cross posted threads on the basis that:
1. Someone else will answer
2. Why bother going to other boards just to see if anyone has answered.

Thanks,

BigDawg15

[patel45]

Please Login or Register  to view this content.

right clic on save button to assign this macro

[CRS-]

hey thank you that works amazing, is there anyway i could get it to delete the information from the frist sheet once it had moved it
across to the second sheet.

thanks again

[patel45]

Please Login or Register  to view this content.