How can I link cells between two sheets so that value gets updated on the second sheet
I have a workbook with several sheets. I have dates on the sheets that i update to same value daily.
eg. on sheet 1, the date is in cell A1, on sheet 2, the date is in cell C2, does not follow a particular order but i update them to same value daily.
Is there anyway i can link the cells, so any change made in one affects the rest?
microsoft-excel microsoft-excel-2007
add a comment |
I have a workbook with several sheets. I have dates on the sheets that i update to same value daily.
eg. on sheet 1, the date is in cell A1, on sheet 2, the date is in cell C2, does not follow a particular order but i update them to same value daily.
Is there anyway i can link the cells, so any change made in one affects the rest?
microsoft-excel microsoft-excel-2007
add a comment |
I have a workbook with several sheets. I have dates on the sheets that i update to same value daily.
eg. on sheet 1, the date is in cell A1, on sheet 2, the date is in cell C2, does not follow a particular order but i update them to same value daily.
Is there anyway i can link the cells, so any change made in one affects the rest?
microsoft-excel microsoft-excel-2007
I have a workbook with several sheets. I have dates on the sheets that i update to same value daily.
eg. on sheet 1, the date is in cell A1, on sheet 2, the date is in cell C2, does not follow a particular order but i update them to same value daily.
Is there anyway i can link the cells, so any change made in one affects the rest?
microsoft-excel microsoft-excel-2007
microsoft-excel microsoft-excel-2007
asked Mar 16 '11 at 20:33
Belonwu OguguaBelonwu Ogugua
13113
13113
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
on Sheet2 set the formula for C1 to:
=Sheet1!A1
rinse and repeat for the other sheets.
edit- other option would be to make cell Sheet1!A1 a named range, and then in the other cells use:
=NamedRange
to define a named range in Excel-2007 select the cell you want to name, go to the Formulas tab and click on Define Name. Enter the desired name and press OK.
add a comment |
Excel can do it for you automatically:
- click Sheet2, click C2
- press '='
- click Sheet1, click A1
- press Enter
Done.
add a comment |
You can also concantenate the cells and this will update it, just go to cell C2 and click FX find formula concantenate and click back to A1 and just do that with all the tabs
add a comment |
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%2f258469%2fhow-can-i-link-cells-between-two-sheets-so-that-value-gets-updated-on-the-second%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
on Sheet2 set the formula for C1 to:
=Sheet1!A1
rinse and repeat for the other sheets.
edit- other option would be to make cell Sheet1!A1 a named range, and then in the other cells use:
=NamedRange
to define a named range in Excel-2007 select the cell you want to name, go to the Formulas tab and click on Define Name. Enter the desired name and press OK.
add a comment |
on Sheet2 set the formula for C1 to:
=Sheet1!A1
rinse and repeat for the other sheets.
edit- other option would be to make cell Sheet1!A1 a named range, and then in the other cells use:
=NamedRange
to define a named range in Excel-2007 select the cell you want to name, go to the Formulas tab and click on Define Name. Enter the desired name and press OK.
add a comment |
on Sheet2 set the formula for C1 to:
=Sheet1!A1
rinse and repeat for the other sheets.
edit- other option would be to make cell Sheet1!A1 a named range, and then in the other cells use:
=NamedRange
to define a named range in Excel-2007 select the cell you want to name, go to the Formulas tab and click on Define Name. Enter the desired name and press OK.
on Sheet2 set the formula for C1 to:
=Sheet1!A1
rinse and repeat for the other sheets.
edit- other option would be to make cell Sheet1!A1 a named range, and then in the other cells use:
=NamedRange
to define a named range in Excel-2007 select the cell you want to name, go to the Formulas tab and click on Define Name. Enter the desired name and press OK.
answered Mar 16 '11 at 20:55
XantecXantec
2,18511214
2,18511214
add a comment |
add a comment |
Excel can do it for you automatically:
- click Sheet2, click C2
- press '='
- click Sheet1, click A1
- press Enter
Done.
add a comment |
Excel can do it for you automatically:
- click Sheet2, click C2
- press '='
- click Sheet1, click A1
- press Enter
Done.
add a comment |
Excel can do it for you automatically:
- click Sheet2, click C2
- press '='
- click Sheet1, click A1
- press Enter
Done.
Excel can do it for you automatically:
- click Sheet2, click C2
- press '='
- click Sheet1, click A1
- press Enter
Done.
answered Mar 16 '11 at 21:01
karatedogkaratedog
725511
725511
add a comment |
add a comment |
You can also concantenate the cells and this will update it, just go to cell C2 and click FX find formula concantenate and click back to A1 and just do that with all the tabs
add a comment |
You can also concantenate the cells and this will update it, just go to cell C2 and click FX find formula concantenate and click back to A1 and just do that with all the tabs
add a comment |
You can also concantenate the cells and this will update it, just go to cell C2 and click FX find formula concantenate and click back to A1 and just do that with all the tabs
You can also concantenate the cells and this will update it, just go to cell C2 and click FX find formula concantenate and click back to A1 and just do that with all the tabs
answered Jan 9 '13 at 16:54
user186718user186718
111
111
add a comment |
add a comment |
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%2f258469%2fhow-can-i-link-cells-between-two-sheets-so-that-value-gets-updated-on-the-second%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