Re: Excel 2003 tabs and reference cells
- From: Edwin Tam <edwintam@xxxxxxxxxx>
- Date: Fri, 20 Apr 2007 01:03:15 +0800
Yes, you can create a template tab.
When you have renamed a copy of that template tab, you can change all your
references (in your summary sheet) to that new copy by using the "Replace"
function of Excel.
For example, your old sheet is called "Sheet1" and the new copy is called
"Sheet2". You want to link to the new one...
From the Edit menu, choose Replace. In the "Find What" field, put "Sheet1".In the "Replace With" field, put "Sheet2". Click "Replace All".
Then, if a cell contains an original formula "=Sheet1!C7", it will be
changed to "=Sheet2!C7".
Regards,
Edwin Tam
http://www.vonixx.com/
On 4/20/07 12:50 AM, in article
24C1399C-666D-43B2-B1C5-E94604596EA4@xxxxxxxxxxxxx, "CreativeMom"
<CreativeMom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I'm using a worksheet that has several tabs. I need to pull select
information from all tabs into one Summary tab. I've create the references I
need for the tabs I have now but there will be others.
Can I create a "template" tab so that it can be copied and renamed and the
reference in the Summary tab will update or will I have to make the change
manually fore each reference?
.
- Prev by Date: Re: Brackets not minus signs for negative quantities - how?
- Next by Date: Macro for adding repeated url path to a field?
- Previous by thread: Brackets not minus signs for negative quantities - how?
- Next by thread: Macro for adding repeated url path to a field?
- Index(es):
Relevant Pages
|
