Updating another Excel spreadsheet from current spreadsheet
up vote
0
down vote
favorite
I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same spreadsheet. I would like to do the same but fill a cell in a different spreadsheet.
I basically have a Form that has fields that auto-populate from a Master spreadsheet and in certain scenarios I want to be able to update the Master from the form... hence populate a cell in the Master.
I am a newbie to VBA, in fact I was happy to be able to just cut and paste the code and it worked as I do not understand the code and it was my first time doing anything with VBA
Thanks
microsoft-excel worksheet-function vba cells
edited Mar 20 '17 at 10:17
Community♦
1
asked Jan 24 '14 at 14:35
user292963
112
add a comment |
up vote
0
down vote
favorite
I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same spreadsheet. I would like to do the same but fill a cell in a different spreadsheet.
I basically have a Form that has fields that auto-populate from a Master spreadsheet and in certain scenarios I want to be able to update the Master from the form... hence populate a cell in the Master.
I am a newbie to VBA, in fact I was happy to be able to just cut and paste the code and it worked as I do not understand the code and it was my first time doing anything with VBA
Thanks
microsoft-excel worksheet-function vba cells
edited Mar 20 '17 at 10:17
Community♦
1
asked Jan 24 '14 at 14:35
user292963
112
1
Linking to the other question, posting the code you have tried and explaining what's gone wrong would all be helpful in helping us help you.
– Raystafarian
Jan 24 '14 at 14:45
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same spreadsheet. I would like to do the same but fill a cell in a different spreadsheet.
I basically have a Form that has fields that auto-populate from a Master spreadsheet and in certain scenarios I want to be able to update the Master from the form... hence populate a cell in the Master.
I am a newbie to VBA, in fact I was happy to be able to just cut and paste the code and it worked as I do not understand the code and it was my first time doing anything with VBA
Thanks
microsoft-excel worksheet-function vba cells
edited Mar 20 '17 at 10:17
Community♦
1
asked Jan 24 '14 at 14:35
user292963
112
I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same spreadsheet. I would like to do the same but fill a cell in a different spreadsheet.
I basically have a Form that has fields that auto-populate from a Master spreadsheet and in certain scenarios I want to be able to update the Master from the form... hence populate a cell in the Master.
I am a newbie to VBA, in fact I was happy to be able to just cut and paste the code and it worked as I do not understand the code and it was my first time doing anything with VBA
Thanks
microsoft-excel worksheet-function vba cells
microsoft-excel worksheet-function vba cells
edited Mar 20 '17 at 10:17
Community♦
1
asked Jan 24 '14 at 14:35
user292963
112
edited Mar 20 '17 at 10:17
Community♦
1
asked Jan 24 '14 at 14:35
user292963
112
edited Mar 20 '17 at 10:17
Community♦
1
edited Mar 20 '17 at 10:17
Community♦
1
edited Mar 20 '17 at 10:17
Community♦
1
1
asked Jan 24 '14 at 14:35
user292963
112
asked Jan 24 '14 at 14:35
user292963
112
asked Jan 24 '14 at 14:35
user292963
112
112
1
Linking to the other question, posting the code you have tried and explaining what's gone wrong would all be helpful in helping us help you.
– Raystafarian
Jan 24 '14 at 14:45
add a comment |
1
Linking to the other question, posting the code you have tried and explaining what's gone wrong would all be helpful in helping us help you.
– Raystafarian
Jan 24 '14 at 14:45
1
1
Linking to the other question, posting the code you have tried and explaining what's gone wrong would all be helpful in helping us help you.
– Raystafarian
Jan 24 '14 at 14:45
Linking to the other question, posting the code you have tried and explaining what's gone wrong would all be helpful in helping us help you.
– Raystafarian
Jan 24 '14 at 14:45
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
If you have both sheets open, you can simply use
Workbooks("Book2.xls").Sheets("Sheet1").Cells(1,1).Value = updatedValue
where "Book2.xls" is the workbook you are updating, "Sheet1" is the sheet within Book2 you are updating, and cell A1 is the cell to update. updatedValue is a variable containing whatever you want to update the value to.
This is Microsoft's Getting Started with VBA guide. I would highly recommend taking a look through it and understanding the code you have. This will help you solve your own problems in the future instead of needing to ask for code to copy and paste.
answered Jan 25 '14 at 21:54
thunderblaster
1137
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',
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%2f706388%2fupdating-another-excel-spreadsheet-from-current-spreadsheet%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
up vote
0
down vote
If you have both sheets open, you can simply use
Workbooks("Book2.xls").Sheets("Sheet1").Cells(1,1).Value = updatedValue
where "Book2.xls" is the workbook you are updating, "Sheet1" is the sheet within Book2 you are updating, and cell A1 is the cell to update. updatedValue is a variable containing whatever you want to update the value to.
This is Microsoft's Getting Started with VBA guide. I would highly recommend taking a look through it and understanding the code you have. This will help you solve your own problems in the future instead of needing to ask for code to copy and paste.
answered Jan 25 '14 at 21:54
thunderblaster
1137
add a comment |
up vote
0
down vote
If you have both sheets open, you can simply use
Workbooks("Book2.xls").Sheets("Sheet1").Cells(1,1).Value = updatedValue
where "Book2.xls" is the workbook you are updating, "Sheet1" is the sheet within Book2 you are updating, and cell A1 is the cell to update. updatedValue is a variable containing whatever you want to update the value to.
This is Microsoft's Getting Started with VBA guide. I would highly recommend taking a look through it and understanding the code you have. This will help you solve your own problems in the future instead of needing to ask for code to copy and paste.
answered Jan 25 '14 at 21:54
thunderblaster
1137
add a comment |
up vote
0
down vote
up vote
0
down vote
If you have both sheets open, you can simply use
Workbooks("Book2.xls").Sheets("Sheet1").Cells(1,1).Value = updatedValue
where "Book2.xls" is the workbook you are updating, "Sheet1" is the sheet within Book2 you are updating, and cell A1 is the cell to update. updatedValue is a variable containing whatever you want to update the value to.
This is Microsoft's Getting Started with VBA guide. I would highly recommend taking a look through it and understanding the code you have. This will help you solve your own problems in the future instead of needing to ask for code to copy and paste.
answered Jan 25 '14 at 21:54
thunderblaster
1137
If you have both sheets open, you can simply use
Workbooks("Book2.xls").Sheets("Sheet1").Cells(1,1).Value = updatedValue
where "Book2.xls" is the workbook you are updating, "Sheet1" is the sheet within Book2 you are updating, and cell A1 is the cell to update. updatedValue is a variable containing whatever you want to update the value to.
This is Microsoft's Getting Started with VBA guide. I would highly recommend taking a look through it and understanding the code you have. This will help you solve your own problems in the future instead of needing to ask for code to copy and paste.
answered Jan 25 '14 at 21:54
thunderblaster
1137
answered Jan 25 '14 at 21:54
thunderblaster
1137
answered Jan 25 '14 at 21:54
thunderblaster
1137
answered Jan 25 '14 at 21:54
thunderblaster
1137
1137
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f706388%2fupdating-another-excel-spreadsheet-from-current-spreadsheet%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
1
Linking to the other question, posting the code you have tried and explaining what's gone wrong would all be helpful in helping us help you.
– Raystafarian
Jan 24 '14 at 14:45