I have the following macro below to copy data from a named range "Summary overaged" and paste in M1 onwards on sheet "overaged"
Your assistance is most appreciated
Code:
Sub Copy_overaged()
Sheets("overaged").Select
Range("Summary_overaged").Copy
Sheets("overaged").Select
Range("M1").PasteSpecial xlPasteFormats
Range("M1").PasteSpecial xlPasteValues
End Sub
Your assistance is most appreciated