I have got this macro:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 24/09/2005 by Shane Nation
'

'
Range("A1,B1,C1,E1,G1,I1:J1,L1:N1").Select
Range("L1").Activate
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
End Sub

Waht I am trying to do is click on call A"n" i.e. selecting different rows
as I move down the sheet, then ru a macro which copys only the columns
a,b,c,e,g,i,n in the selected row. Open a diffresent and paste them at the
current cursur location.

This macro just selts the same cells and pasts them in the same location
each time it is run.

Please can someone help?

Thanks