Cell copying from tab to tab

M

Michelle

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
 
J

Jim Thomlinson

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.
 
M

Mike H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top