B
bills2
Hello,
I'm on Excel v X for the Mac using OS 10.3.
I have many multitab/sheet Excel files and quite a few of them have cell
references (or copies) of cells on other tabs/sheets and/or files. They
have always worked fine. Depending on where they come from the
receiving cell shows a complex location detail of the cell where the
data is coming from.
My problem is that I've been building some simple invoice type forms.
All was going fine until I got to what I thought was going to be the
easy step: setting up to have some cells to autocopy into the 2nd tab
or sheet from other sheets or master sheets. Simple, huh?
For many of the cells where I did this (only trying to autocopy name,
address, town, state, zip, telephone #) what shows up in the receiving
cell is the actual formula for the location of what I'm trying to have
show up in the receiving cell.
I read some reference to having both sheets saved prior to setting up
the formulas. Can't see that makes any difference.
Protected sheets, merged cells are involved so I've trying playing with
all those variations I can think of: no luck or predictable success.
As I played around I found that many cells in the receiving sheet DO get
the correct result. I've moved some of them back into the proper spot
(where I want the name, address or town info to go) wilh success - that
is, after moving it the other cell contents do show up correctly.
Thought I was sorta on a roll there, so I modified an equation in a
successfully showing cell to be a little smarter. Voila, again back to
just showing the entire location equation of the info I want from the
other sheet/cell.
I've never seen this and can't see anything about mismatched formating
either. I'm frustrated.
Can anyone offer some help?
Thanks
Bill
I'm on Excel v X for the Mac using OS 10.3.
I have many multitab/sheet Excel files and quite a few of them have cell
references (or copies) of cells on other tabs/sheets and/or files. They
have always worked fine. Depending on where they come from the
receiving cell shows a complex location detail of the cell where the
data is coming from.
My problem is that I've been building some simple invoice type forms.
All was going fine until I got to what I thought was going to be the
easy step: setting up to have some cells to autocopy into the 2nd tab
or sheet from other sheets or master sheets. Simple, huh?
For many of the cells where I did this (only trying to autocopy name,
address, town, state, zip, telephone #) what shows up in the receiving
cell is the actual formula for the location of what I'm trying to have
show up in the receiving cell.
I read some reference to having both sheets saved prior to setting up
the formulas. Can't see that makes any difference.
Protected sheets, merged cells are involved so I've trying playing with
all those variations I can think of: no luck or predictable success.
As I played around I found that many cells in the receiving sheet DO get
the correct result. I've moved some of them back into the proper spot
(where I want the name, address or town info to go) wilh success - that
is, after moving it the other cell contents do show up correctly.
Thought I was sorta on a roll there, so I modified an equation in a
successfully showing cell to be a little smarter. Voila, again back to
just showing the entire location equation of the info I want from the
other sheet/cell.
I've never seen this and can't see anything about mismatched formating
either. I'm frustrated.
Can anyone offer some help?
Thanks
Bill