Using a command button to copy selected data to another worksheet

Hi All

Am a newbie to Excel VBA (basically I know nothing so please be kind) and need some help. I am trying to create Quote File which will copy data from one worksheet called R&R to another worksheet called Quote which will then be linked to a Quote Form.

In the R&R Worksheet in Col A I have the List of Data, Col B has a list of Labour Hours which correspondes with the data in Col A and which also needs to copy over to the Quote worksheet/Form.

What I need is to somehow have the ability to select multple lines in Col A then using a comand Button or something similar copy the data in both Col A and B that I have selected into the Quote Worksheet but I need to keep Col A and B seperate on the Quote Sheet. I hope this makes sense!

Would be very glad to hear from anyone with a solution to this. I have attached a copy of the file with what I have done so far.


Thanks 02.flea