The name range is called ReportCopy and the range formula is a dynamic =OFFSET('C Register'!$H$1,,,COUNTA('C Register'!$H:$H),6)
The Nacro I am trying to us is: ' Keyboard Shortcut: Ctrl+e
'
Sheets("C Register").Select
Range("ReportCopy").
Selection.Copy
Sheets("Report").Select...