Do you really mean COPY ? If so just copy and paste
If you want Sheet2 to show the same values as in Sheet1, use =Sheet1!A1

Please, a workbook is made up of WORKSHEETS, the tab is the thing that opens
a worksheet
If you use incorrect terminology you will find it hard to use Help

best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"RJF" wrote in message
...
Is there a function in Excel that lets you copy and entire range from one
tab
to another?

Thank you.

Rachel