Copy entire ranges

R

RJF

Is there a function in Excel that lets you copy and entire range from one tab
to another?

Thank you.

Rachel
 
B

Bernard Liengme

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
 
R

RJF

What I really mean is to LINK an entire named range from one worksheet to
another worksheet within the same workbook. I don't want to link (or copy)
the entire worksheet just link the range.

Sorry for the incorrect terminology and for not being very clear the first
time. I'm not used to using this help feature.

Also, thank you for your quick response.
 
Top