Excel 2007 : copy paste macro

[handfull]

Hi everyone,
I am a complete novice with VBA /Excel and i am trying to learn as best i can
What i would like to do is copy and paste certain cells within a colum and output to another work sheet using a macro.
What i would like to do is create a macro to copy " Sheet1 ColumnA cell 2 & 3 & 10 & 11 and so on on unitl the end blank cell in that column and paste it to another worksheet and output the format as Sheet2 ColumnA and ColumnB, i have managed to do this but i dont know how i did ? the reason i am asking is i want to recreate s similar macro using differnet cells /columns to finish of my project and i cant seem to replicate the macro

Here is the macro i created.

Please Login or Register  to view this content.

Sorry if my explanation is a little unclear

Thanks for any help Guys

Appreciate it..

[TMS]

Not sure I understand the "rules of engagement" here ;-)

Sheet1 ColumnA cell 2 & 3 & 10 & 11 and so on on unitl the end blank cell in that column

Can you post a sample workbook?

Regards

[handfull]

Hi,
Thanks for the kind response sorry that its not so precise.
I have attached the sheet for you to view, again please understand i have no idea what im doing which you will surely see within a few seconds but im trying
I was going to explain what i am trying to do but i thought it might be easier and less confusing if you view the workbook first.

Thanks for your time..

[TMS]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

To clear the "copy all macs" sheet, you could use:

Please Login or Register  to view this content.

Regards

[handfull]

Hi TmShucks,
Thanks for the code it works alot better than my effort and is alot quicker.

Can i just ask ? in the workbook i also want to copy from Sheet1 to the FEC sheet, again its only certain cells, i can see within your code how to change the worksheet ref but am not sure how to select the cells i want to copy and paste from to ?

Thank you so much for your help really appreciate it..

[TMS]

Sorry, missed the follow up. Try this:

Please Login or Register  to view this content.

Regards

[handfull]

Hi,
Thank you so much for your help, i have managed to get all the cells to copy across now using your code above andi have also managed to edit that code to copy the other cells i needed to copy as well. There is a lot to this VBA within excel but i can see why you guys use it and how fast it can be..

Thanks so much for all your help i would not have been able to do it without your assitance.

All the best.

Matt