Hello everybody.

Hopefully someone can help me with this as I am stuck.(As usual)

I want to add a command button to a report that when clicked will copy the sheet into a new book.

I assume that this can be acheived throuch a Macro, but everything I've tried thus far has failed.

Thanks for your help!