R
royboy
Once a month I get a three tab worksheet of data, forumulas graphs etc. I
want to manipulate the information differently, so I created a fourth tab
(call it "my tab") with lots of formulas, formating, highlighting etc. Of
course the "my tab" worksheet has references to the other tabs as is standard
in excel: 'tab1'!B14, 'tab3'!a1*'tab1'!a2, etc.
So, lets say that I have the jan.xls spreadsheet and build mytab as
described. Now I get the feb.xls spreadsheet. I want to copy mytab to the
feb.xls. So I do edit, "move or copy worksheet", select feb.xls from the
drop down, and select create a copy.
Now "mytab" has been added to the feb.xls worksheet. All the formating etc
is there. But all of my formulas now have references to jan.xls as follows:
='[jan.xls]tab1!b14 But I don't want the reference to the old data. I
want it to look at the feb.xls spreadsheet.
Can anyone help me with how to do that?
want to manipulate the information differently, so I created a fourth tab
(call it "my tab") with lots of formulas, formating, highlighting etc. Of
course the "my tab" worksheet has references to the other tabs as is standard
in excel: 'tab1'!B14, 'tab3'!a1*'tab1'!a2, etc.
So, lets say that I have the jan.xls spreadsheet and build mytab as
described. Now I get the feb.xls spreadsheet. I want to copy mytab to the
feb.xls. So I do edit, "move or copy worksheet", select feb.xls from the
drop down, and select create a copy.
Now "mytab" has been added to the feb.xls worksheet. All the formating etc
is there. But all of my formulas now have references to jan.xls as follows:
='[jan.xls]tab1!b14 But I don't want the reference to the old data. I
want it to look at the feb.xls spreadsheet.
Can anyone help me with how to do that?