Copy visible cells and then transfer output to another sheet.

Hi,

I am trying to copy the visible cells in a range to another sheet called template

Please Login or Register  to view this content.

After this, I would like to be able to copy everything in the template sheet into a new workbook, save it and then return to the original workbook.

Could someone please help me with this.

Kind regards
James