software

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

Thank you.

Rachel

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

quot;RJFquot; gt; wrote in message
...
gt; Is there a function in Excel that lets you copy and entire range from one
gt; tab
gt; to another?
gt;
gt; Thank you.
gt;
gt; Rachel
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.

quot;Bernard Liengmequot; wrote:

gt; Do you really mean COPY ? If so just copy and paste
gt; If you want Sheet2 to show the same values as in Sheet1, use =Sheet1!A1
gt;
gt; Please, a workbook is made up of WORKSHEETS, the tab is the thing that opens
gt; a worksheet
gt; If you use incorrect terminology you will find it hard to use Help
gt;
gt; best wishes
gt;
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;RJFquot; gt; wrote in message
gt; ...
gt; gt; Is there a function in Excel that lets you copy and entire range from one
gt; gt; tab
gt; gt; to another?
gt; gt;
gt; gt; Thank you.
gt; gt;
gt; gt; Rachel
gt;
gt;
gt;