Right click on the tab for the sheet you want to copy. Choose "move or
copy..' from the list that comes up. Check the "make a copy" checkbox

In the top of that dialog box, choose the workbook where you want the copy
to go. Click on OK and get a perfect replica

"JR Hester" wrote:

Is there any way to copy data from one shhet to another AND have the column
width/row hieght trasfer as well? I am accustomed to using paste special, but
this seem sNOT to include col width and row hieght.

Any way to accomplish without VBA?

Thanks