Make excel remember references Unicorn Meta Zoo #1: Why another podcast? ...
What is "leading note" and what does it mean to "raise a note"?
Expansion//Explosion and Siren Stormtamer
"Rubric" as meaning "signature" or "personal mark" -- is this accepted usage?
Why did Israel vote against lifting the American embargo on Cuba?
c++ diamond problem - How to call base method only once
Book with legacy programming code on a space ship that the main character hacks to escape
Mistake in years of experience in resume?
Check if a string is entirely made of the same substring
How to count in linear time worst-case?
What do you call the part of a novel that is not dialog?
Why didn't the Space Shuttle bounce back into space many times as possible so that it loose lot of kinetic energy over there?
Seek and ye shall find
I preordered a game on my Xbox while on the home screen of my friend's account. Which of us owns the game?
The art of proof summarizing. Are there known rules, or is it a purely common sense matter?
How to open locks without disable device?
Are these square matrices always diagonalisable?
Putting Ant-Man on house arrest
Refugee travel document from Spain to US
Does Feeblemind produce an ongoing magical effect that can be dispelled?
Has a Nobel Peace laureate ever been accused of war crimes?
What's parked in Mil Moscow helicopter plant?
Can I criticise the more senior developers around me for not writing clean code?
Raising a bilingual kid. When should we introduce the majority language?
Is Electric Central Heating worth it if using Solar Panels?
Make excel remember references
Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar ManaraProblem with transpose in Excel 2007/2008: Excel transposes even absolute referencesHow to edit a formula for a range of cells in Excel?Copying columns in Excel from sheet1 to sheet2 without having to cut and pasteExcel SUM From Different Sheets IF Date FoundExcel saves absolute references to other sheets in my workbook. This causes problems when emailing the workbook to colleaguesUse Excel to match data from a cell on a worksheet, then copy data from its neighboring column and paste on a different worksheetHow do I implement the VBA module to copy filtered dataUsing Excel Indirect with worksheet namesI have a spreadsheet linked to a database in excel. How can I grab the cells from the database without the formula references changing?Copying Chart to Another Sheet with Updated References in Excel
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I've got a worksheet named B that has references to worksheet A like this:
'sheet A'!A1
'sheet A'!C1
'sheet A'!F1
'sheet A'!G1
...
But now I need to add some new and old lines to the source from a worksheet that says:
A1
B1
F1
H1
Manually adding these lines will take too much time because I have to do a lot of them on a fairly regular basis.
Is there a way for me to copy/paste this new sheet onto the source whilst my references won't get pushed around (so that the reference to A1 will always stay on A1 even if I add or remove a line).
microsoft-excel worksheet-function
edited 13 hours ago
Máté Juhász
14.9k63552
asked 13 hours ago
Wim MertensWim Mertens
1
New contributor
Wim Mertens is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I've got a worksheet named B that has references to worksheet A like this:
'sheet A'!A1
'sheet A'!C1
'sheet A'!F1
'sheet A'!G1
...
But now I need to add some new and old lines to the source from a worksheet that says:
A1
B1
F1
H1
Manually adding these lines will take too much time because I have to do a lot of them on a fairly regular basis.
Is there a way for me to copy/paste this new sheet onto the source whilst my references won't get pushed around (so that the reference to A1 will always stay on A1 even if I add or remove a line).
microsoft-excel worksheet-function
edited 13 hours ago
Máté Juhász
14.9k63552
asked 13 hours ago
Wim MertensWim Mertens
1
New contributor
Wim Mertens is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I've got a worksheet named B that has references to worksheet A like this:
'sheet A'!A1
'sheet A'!C1
'sheet A'!F1
'sheet A'!G1
...
But now I need to add some new and old lines to the source from a worksheet that says:
A1
B1
F1
H1
Manually adding these lines will take too much time because I have to do a lot of them on a fairly regular basis.
Is there a way for me to copy/paste this new sheet onto the source whilst my references won't get pushed around (so that the reference to A1 will always stay on A1 even if I add or remove a line).
microsoft-excel worksheet-function
edited 13 hours ago
Máté Juhász
14.9k63552
asked 13 hours ago
Wim MertensWim Mertens
1
New contributor
Wim Mertens is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I've got a worksheet named B that has references to worksheet A like this:
'sheet A'!A1
'sheet A'!C1
'sheet A'!F1
'sheet A'!G1
...
But now I need to add some new and old lines to the source from a worksheet that says:
A1
B1
F1
H1
Manually adding these lines will take too much time because I have to do a lot of them on a fairly regular basis.
Is there a way for me to copy/paste this new sheet onto the source whilst my references won't get pushed around (so that the reference to A1 will always stay on A1 even if I add or remove a line).
microsoft-excel worksheet-function
microsoft-excel worksheet-function
edited 13 hours ago
Máté Juhász
14.9k63552
asked 13 hours ago
Wim MertensWim Mertens
1
New contributor
Wim Mertens is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 13 hours ago
Máté Juhász
14.9k63552
asked 13 hours ago
Wim MertensWim Mertens
1
New contributor
Wim Mertens is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 13 hours ago
Máté Juhász
14.9k63552
edited 13 hours ago
Máté Juhász
14.9k63552
edited 13 hours ago
Máté Juhász
14.9k63552
14.9k63552
asked 13 hours ago
Wim MertensWim Mertens
1
New contributor
Wim Mertens is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 13 hours ago
Wim MertensWim Mertens
1
asked 13 hours ago
Wim MertensWim Mertens
1
1
New contributor
Wim Mertens is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Wim Mertens is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Wim Mertens is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
you can use INDIRECT and ADDRESS for this.
the below will always point to cell A1:
=INDIRECT(ADDRESS(1,1))
And you can even point to a specific cell in another sheet like below:
=INDIRECT("Sheet2!"&ADDRESS(1,1))
ADDRESS makes use of cell reference, so 1,1 is A1, however, these numbers too can be replaced with other formulas, such as ROW, COLUMN etc. to enable a dynamic approach of setting a place in the spreadsheet, that can stay locked to a column or row when new rows or columns are added.
Was this what you was looking for ?
answered 13 hours ago
PeterHPeterH
3,74462851
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
});
}
});
Wim Mertens is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1429014%2fmake-excel-remember-references%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
you can use INDIRECT and ADDRESS for this.
the below will always point to cell A1:
=INDIRECT(ADDRESS(1,1))
And you can even point to a specific cell in another sheet like below:
=INDIRECT("Sheet2!"&ADDRESS(1,1))
ADDRESS makes use of cell reference, so 1,1 is A1, however, these numbers too can be replaced with other formulas, such as ROW, COLUMN etc. to enable a dynamic approach of setting a place in the spreadsheet, that can stay locked to a column or row when new rows or columns are added.
Was this what you was looking for ?
answered 13 hours ago
PeterHPeterH
3,74462851
add a comment |
you can use INDIRECT and ADDRESS for this.
the below will always point to cell A1:
=INDIRECT(ADDRESS(1,1))
And you can even point to a specific cell in another sheet like below:
=INDIRECT("Sheet2!"&ADDRESS(1,1))
ADDRESS makes use of cell reference, so 1,1 is A1, however, these numbers too can be replaced with other formulas, such as ROW, COLUMN etc. to enable a dynamic approach of setting a place in the spreadsheet, that can stay locked to a column or row when new rows or columns are added.
Was this what you was looking for ?
answered 13 hours ago
PeterHPeterH
3,74462851
add a comment |
you can use INDIRECT and ADDRESS for this.
the below will always point to cell A1:
=INDIRECT(ADDRESS(1,1))
And you can even point to a specific cell in another sheet like below:
=INDIRECT("Sheet2!"&ADDRESS(1,1))
ADDRESS makes use of cell reference, so 1,1 is A1, however, these numbers too can be replaced with other formulas, such as ROW, COLUMN etc. to enable a dynamic approach of setting a place in the spreadsheet, that can stay locked to a column or row when new rows or columns are added.
Was this what you was looking for ?
answered 13 hours ago
PeterHPeterH
3,74462851
you can use INDIRECT and ADDRESS for this.
the below will always point to cell A1:
=INDIRECT(ADDRESS(1,1))
And you can even point to a specific cell in another sheet like below:
=INDIRECT("Sheet2!"&ADDRESS(1,1))
ADDRESS makes use of cell reference, so 1,1 is A1, however, these numbers too can be replaced with other formulas, such as ROW, COLUMN etc. to enable a dynamic approach of setting a place in the spreadsheet, that can stay locked to a column or row when new rows or columns are added.
Was this what you was looking for ?
answered 13 hours ago
PeterHPeterH
3,74462851
answered 13 hours ago
PeterHPeterH
3,74462851
answered 13 hours ago
PeterHPeterH
3,74462851
answered 13 hours ago
PeterHPeterH
3,74462851
3,74462851
add a comment |
add a comment |
Wim Mertens is a new contributor. Be nice, and check out our Code of Conduct.
Wim Mertens is a new contributor. Be nice, and check out our Code of Conduct.
Wim Mertens is a new contributor. Be nice, and check out our Code of Conduct.
Wim Mertens is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1429014%2fmake-excel-remember-references%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
