Information transfer between two sheets in same book

[Nevyn]

Hi Folks, need a hand please. I have an excel book with about a dozen sheets
in it. I have information in one row of cells that on pressing a button will
transfer to a new sheet without going back and forward to between sheets. The
information in both sheets is in same format and same order.

Hope you can help me
Nevyn

 

[JLatham]

Nevyn,
What is your question or need. You have said that you have information on
one row that, when a button is pressed, will transfer to a new sheet without
going back and forth.
That sounds like something that is already done, or is that what you want?

If that's what you want, then we need to know a little more about the sheets
in the workbook, you say you have about a dozen sheets now and your statement
says "transfer to a new sheet". So I presume you want a button to click on
the existing sheets that will take a row of data from that sheet and place it
onto some new sheet that will be added to the workbook?