Hi,

Could anyone assist my in creating a macro?

What I require is a macro that will copy and paste a range of data into a new sheet. This data is linked to a drop down list, so each time a new value is selected in the dropdown list the data changes (the data is linked to a vlookup).

Is there a way I can do this?

I had a code such as this;

' Macro1 Macro
'Sub copypasteprint()
Range("a42:a138").Select
Selection.Copy
Range("a1:g28").Select
Application.CutCopyMode = False
Selection.Copy
Range("a1:g28").Select
ActiveSheet.Paste
Range("a1:g28").Select


What alterations can I make to ensure it works properly?

Thanks,

sleep