Excel linking both ways between two sheets Announcing the arrival of Valued Associate #679:...
AppleTVs create a chatty alternate WiFi network
Why are vacuum tubes still used in amateur radios?
Is multiple magic items in one inherently imbalanced?
How did Fremen produce and carry enough thumpers to use Sandworms as de facto Ubers?
Intuitive explanation of the rank-nullity theorem
Co-worker has annoying ringtone
Is there hard evidence that the grant peer review system performs significantly better than random?
How often does castling occur in grandmaster games?
How would a mousetrap for use in space work?
A letter with no particular backstory
Putting class ranking in CV, but against dept guidelines
Random body shuffle every night—can we still function?
What to do with repeated rejections for phd position
What does this say in Elvish?
A term for a woman complaining about things/begging in a cute/childish way
Has negative voting ever been officially implemented in elections, or seriously proposed, or even studied?
How do living politicians protect their readily obtainable signatures from misuse?
Is there public access to the Meteor Crater in Arizona?
How many time has Arya actually used Needle?
How to run automated tests after each commit?
Does the Mueller report show a conspiracy between Russia and the Trump Campaign?
The test team as an enemy of development? And how can this be avoided?
How could we fake a moon landing now?
Why are my pictures showing a dark band on one edge?
Excel linking both ways between two sheets
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)Microsoft Excel – How to link or copy cells to a different worksheet on every nth rowExcel: autofill formulas in listsCompare two Excel sheetsLinking sheets in ExcelExtending a sheet with hidden/deleted last columns in Microsoft ExcelLinking two excel sheets on different computers without sharing filesdoes 1 row from excel worksheets exist in another worksheet. If so copy, copy value from cellAdd additional columns to spreadsheet based on templateRobust linking of cells ExcelForce error formulas with reference to a specific sheet
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
There are similar questions answered but mine is a simpler case, so I hope a "keystroke solution" exists.
I've done some calculations with formulas, using several intermediate cells. Now I want to give the result to somebody else who does not care about these intermediate computations, and I do not want them to be distracted by some hidden columns, so I prefer to keep all these intermediate cells on another sheet.
I can paste links there, but this won't help - what I need is that the cells in the new sheet refer to the cells in the old one, while the final results in the old sheet use values from the new sheet.
What is the easiest way to do this?
microsoft-excel links
asked 7 hours ago
მამუკა ჯიბლაძემამუკა ჯიბლაძე
13419
add a comment |
There are similar questions answered but mine is a simpler case, so I hope a "keystroke solution" exists.
I've done some calculations with formulas, using several intermediate cells. Now I want to give the result to somebody else who does not care about these intermediate computations, and I do not want them to be distracted by some hidden columns, so I prefer to keep all these intermediate cells on another sheet.
I can paste links there, but this won't help - what I need is that the cells in the new sheet refer to the cells in the old one, while the final results in the old sheet use values from the new sheet.
What is the easiest way to do this?
microsoft-excel links
asked 7 hours ago
მამუკა ჯიბლაძემამუკა ჯიბლაძე
13419
Does your colleague need the formulas in the final sheet, or just the end results? If the latter, use 'paste values' from your final sheet to the copied sheet you're going to share.
– Alex M
6 hours ago
@AlexM No this won't do - they must be entering some values in some cells and see the final results in some other cells
– მამუკა ჯიბლაძე
6 hours ago
Well, cell references can refer to other workbooks, so you could theoretically maintain a workbook with the intermediate calculations, and give your colleague access to a workbook that has formulas that reference those calculated fields; as long as the filepath of the calculating workbook stays constant, everything will work for your colleague. Is that what you mean?
– Alex M
6 hours ago
@AlexM Yes, and I obviously can just type in the paths in necessary places, I just want to know whether there is an easier way. For example, pasting links produces them automatically, but I want that also links would appear to the cells that I moved to another place.
– მამუკა ჯიბლაძე
12 mins ago
add a comment |
There are similar questions answered but mine is a simpler case, so I hope a "keystroke solution" exists.
I've done some calculations with formulas, using several intermediate cells. Now I want to give the result to somebody else who does not care about these intermediate computations, and I do not want them to be distracted by some hidden columns, so I prefer to keep all these intermediate cells on another sheet.
I can paste links there, but this won't help - what I need is that the cells in the new sheet refer to the cells in the old one, while the final results in the old sheet use values from the new sheet.
What is the easiest way to do this?
microsoft-excel links
asked 7 hours ago
მამუკა ჯიბლაძემამუკა ჯიბლაძე
13419
There are similar questions answered but mine is a simpler case, so I hope a "keystroke solution" exists.
I've done some calculations with formulas, using several intermediate cells. Now I want to give the result to somebody else who does not care about these intermediate computations, and I do not want them to be distracted by some hidden columns, so I prefer to keep all these intermediate cells on another sheet.
I can paste links there, but this won't help - what I need is that the cells in the new sheet refer to the cells in the old one, while the final results in the old sheet use values from the new sheet.
What is the easiest way to do this?
microsoft-excel links
microsoft-excel links
asked 7 hours ago
მამუკა ჯიბლაძემამუკა ჯიბლაძე
13419
asked 7 hours ago
მამუკა ჯიბლაძემამუკა ჯიბლაძე
13419
asked 7 hours ago
მამუკა ჯიბლაძემამუკა ჯიბლაძე
13419
asked 7 hours ago
მამუკა ჯიბლაძემამუკა ჯიბლაძე
13419
asked 7 hours ago
მამუკა ჯიბლაძემამუკა ჯიბლაძე
13419
13419
Does your colleague need the formulas in the final sheet, or just the end results? If the latter, use 'paste values' from your final sheet to the copied sheet you're going to share.
– Alex M
6 hours ago
@AlexM No this won't do - they must be entering some values in some cells and see the final results in some other cells
– მამუკა ჯიბლაძე
6 hours ago
Well, cell references can refer to other workbooks, so you could theoretically maintain a workbook with the intermediate calculations, and give your colleague access to a workbook that has formulas that reference those calculated fields; as long as the filepath of the calculating workbook stays constant, everything will work for your colleague. Is that what you mean?
– Alex M
6 hours ago
@AlexM Yes, and I obviously can just type in the paths in necessary places, I just want to know whether there is an easier way. For example, pasting links produces them automatically, but I want that also links would appear to the cells that I moved to another place.
– მამუკა ჯიბლაძე
12 mins ago
add a comment |
Does your colleague need the formulas in the final sheet, or just the end results? If the latter, use 'paste values' from your final sheet to the copied sheet you're going to share.
– Alex M
6 hours ago
@AlexM No this won't do - they must be entering some values in some cells and see the final results in some other cells
– მამუკა ჯიბლაძე
6 hours ago
Well, cell references can refer to other workbooks, so you could theoretically maintain a workbook with the intermediate calculations, and give your colleague access to a workbook that has formulas that reference those calculated fields; as long as the filepath of the calculating workbook stays constant, everything will work for your colleague. Is that what you mean?
– Alex M
6 hours ago
@AlexM Yes, and I obviously can just type in the paths in necessary places, I just want to know whether there is an easier way. For example, pasting links produces them automatically, but I want that also links would appear to the cells that I moved to another place.
– მამუკა ჯიბლაძე
12 mins ago
Does your colleague need the formulas in the final sheet, or just the end results? If the latter, use 'paste values' from your final sheet to the copied sheet you're going to share.
– Alex M
6 hours ago
Does your colleague need the formulas in the final sheet, or just the end results? If the latter, use 'paste values' from your final sheet to the copied sheet you're going to share.
– Alex M
6 hours ago
@AlexM No this won't do - they must be entering some values in some cells and see the final results in some other cells
– მამუკა ჯიბლაძე
6 hours ago
@AlexM No this won't do - they must be entering some values in some cells and see the final results in some other cells
– მამუკა ჯიბლაძე
6 hours ago
Well, cell references can refer to other workbooks, so you could theoretically maintain a workbook with the intermediate calculations, and give your colleague access to a workbook that has formulas that reference those calculated fields; as long as the filepath of the calculating workbook stays constant, everything will work for your colleague. Is that what you mean?
– Alex M
6 hours ago
Well, cell references can refer to other workbooks, so you could theoretically maintain a workbook with the intermediate calculations, and give your colleague access to a workbook that has formulas that reference those calculated fields; as long as the filepath of the calculating workbook stays constant, everything will work for your colleague. Is that what you mean?
– Alex M
6 hours ago
@AlexM Yes, and I obviously can just type in the paths in necessary places, I just want to know whether there is an easier way. For example, pasting links produces them automatically, but I want that also links would appear to the cells that I moved to another place.
– მამუკა ჯიბლაძე
12 mins ago
@AlexM Yes, and I obviously can just type in the paths in necessary places, I just want to know whether there is an easier way. For example, pasting links produces them automatically, but I want that also links would appear to the cells that I moved to another place.
– მამუკა ჯიბლაძე
12 mins ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1427478%2fexcel-linking-both-ways-between-two-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1427478%2fexcel-linking-both-ways-between-two-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Does your colleague need the formulas in the final sheet, or just the end results? If the latter, use 'paste values' from your final sheet to the copied sheet you're going to share.
– Alex M
6 hours ago
@AlexM No this won't do - they must be entering some values in some cells and see the final results in some other cells
– მამუკა ჯიბლაძე
6 hours ago
Well, cell references can refer to other workbooks, so you could theoretically maintain a workbook with the intermediate calculations, and give your colleague access to a workbook that has formulas that reference those calculated fields; as long as the filepath of the calculating workbook stays constant, everything will work for your colleague. Is that what you mean?
– Alex M
6 hours ago
@AlexM Yes, and I obviously can just type in the paths in necessary places, I just want to know whether there is an easier way. For example, pasting links produces them automatically, but I want that also links would appear to the cells that I moved to another place.
– მამუკა ჯიბლაძე
12 mins ago