Cell copying from tab to tab
 

I have a 'summary' tab and a 'detailed' tab.

Cell C16 on both seem to be linked somehow. When I change C16 on the
'detailed' tab to be the text I need, it puts that same text in cell C16 on
the summary tab... which I need to be a formula etc.

How can I un-link these cells from tab to tab

Cell copying from tab to tab
 

Cell C16 on your summary tab is most likely a formula something like...

='Detailed'!C16

remove/delete that formula and the cell will no longer be linked.
--
HTH...

Jim Thomlinson


"Michelle" wrote:

I have a 'summary' tab and a 'detailed' tab.

Cell C16 on both seem to be linked somehow. When I change C16 on the
'detailed' tab to be the text I need, it puts that same text in cell C16 on
the summary tab... which I need to be a formula etc.

How can I un-link these cells from tab to tab

Cell copying from tab to tab
 

Michelle,

Note the terminology, WORKSHEET and not TAB. A TAB is the part of a
worksheet that holds the name and provides some other functionality.

Select C16 on the summary worksheet and look in the formula bar, what's
there? does it say something like

=Sheet1!$C$16

Where Sheet1 is the name of your Detail worksheet. If so delete the formula
and the link is broken.

I don't understand
which I need to be a formula etc.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Michelle" wrote:

I have a 'summary' tab and a 'detailed' tab.

Cell C16 on both seem to be linked somehow. When I change C16 on the
'detailed' tab to be the text I need, it puts that same text in cell C16 on
the summary tab... which I need to be a formula etc.

How can I un-link these cells from tab to tab