| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying cell contents from many cells and pasting into one cell | Excel Discussion (Misc queries) | |||
| Copying the data in and format of a cell to another cell | Excel Discussion (Misc queries) | |||
| Copying format to a new cell, w/o overwriting destination cell contents | Excel Discussion (Misc queries) | |||
| copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
| Copying excel format from cell to cell | Excel Discussion (Misc queries) | |||
Linear Mode
