Match Columns of different workbook
I am now creating new macro. I still have difficulties
Anyway, I have two workbooks.
- Customer List
- Account List
on Customer List I have columns
Cust_No, Cust_ShortName, Cust_fname, Cust_mname, Cust_lname, Cust_Bdate, Cust_Address
while on Account List I have
CusT_NO, Acct_Name, Acct_No, Date_Created, Balance
Now... I want to match them using there Cust_NO. I want to get the ACCT_NO from the Account List. (by the way Cust_NO is unique so that's my basis for matching)
I want to copy Customer List and save as new file, but before copying it I want the Acct_No should be included in the new saved file.
I want it like this for the new file:
(New Saved file) columns
Cust_No, **Acct_No.**, Cust_ShortName, Cust_fname, Cust_mname, Cust_lname, Cust_Bdate, Cust_Address
microsoft-excel vba macros
add a comment |
I am now creating new macro. I still have difficulties
Anyway, I have two workbooks.
- Customer List
- Account List
on Customer List I have columns
Cust_No, Cust_ShortName, Cust_fname, Cust_mname, Cust_lname, Cust_Bdate, Cust_Address
while on Account List I have
CusT_NO, Acct_Name, Acct_No, Date_Created, Balance
Now... I want to match them using there Cust_NO. I want to get the ACCT_NO from the Account List. (by the way Cust_NO is unique so that's my basis for matching)
I want to copy Customer List and save as new file, but before copying it I want the Acct_No should be included in the new saved file.
I want it like this for the new file:
(New Saved file) columns
Cust_No, **Acct_No.**, Cust_ShortName, Cust_fname, Cust_mname, Cust_lname, Cust_Bdate, Cust_Address
microsoft-excel vba macros
"I am now creating new macro" - please share it and explain what it currently does, and how it should work different.(please don't answer in comment, but edit your question).
– Máté Juhász
Jan 29 at 8:27
So, you basically need a vlookup in another file?
– Moacir
Jan 29 at 11:13
yes I did. I also filter the data then delete all the blanks after I'd write down vlookup. thanks for your suggestions :)
– gee
Jan 30 at 6:25
add a comment |
I am now creating new macro. I still have difficulties
Anyway, I have two workbooks.
- Customer List
- Account List
on Customer List I have columns
Cust_No, Cust_ShortName, Cust_fname, Cust_mname, Cust_lname, Cust_Bdate, Cust_Address
while on Account List I have
CusT_NO, Acct_Name, Acct_No, Date_Created, Balance
Now... I want to match them using there Cust_NO. I want to get the ACCT_NO from the Account List. (by the way Cust_NO is unique so that's my basis for matching)
I want to copy Customer List and save as new file, but before copying it I want the Acct_No should be included in the new saved file.
I want it like this for the new file:
(New Saved file) columns
Cust_No, **Acct_No.**, Cust_ShortName, Cust_fname, Cust_mname, Cust_lname, Cust_Bdate, Cust_Address
microsoft-excel vba macros
I am now creating new macro. I still have difficulties
Anyway, I have two workbooks.
- Customer List
- Account List
on Customer List I have columns
Cust_No, Cust_ShortName, Cust_fname, Cust_mname, Cust_lname, Cust_Bdate, Cust_Address
while on Account List I have
CusT_NO, Acct_Name, Acct_No, Date_Created, Balance
Now... I want to match them using there Cust_NO. I want to get the ACCT_NO from the Account List. (by the way Cust_NO is unique so that's my basis for matching)
I want to copy Customer List and save as new file, but before copying it I want the Acct_No should be included in the new saved file.
I want it like this for the new file:
(New Saved file) columns
Cust_No, **Acct_No.**, Cust_ShortName, Cust_fname, Cust_mname, Cust_lname, Cust_Bdate, Cust_Address
microsoft-excel vba macros
microsoft-excel vba macros
edited Jan 29 at 8:37
Ahmed Ashour
1,3872716
1,3872716
asked Jan 29 at 7:31
geegee
344
344
"I am now creating new macro" - please share it and explain what it currently does, and how it should work different.(please don't answer in comment, but edit your question).
– Máté Juhász
Jan 29 at 8:27
So, you basically need a vlookup in another file?
– Moacir
Jan 29 at 11:13
yes I did. I also filter the data then delete all the blanks after I'd write down vlookup. thanks for your suggestions :)
– gee
Jan 30 at 6:25
add a comment |
"I am now creating new macro" - please share it and explain what it currently does, and how it should work different.(please don't answer in comment, but edit your question).
– Máté Juhász
Jan 29 at 8:27
So, you basically need a vlookup in another file?
– Moacir
Jan 29 at 11:13
yes I did. I also filter the data then delete all the blanks after I'd write down vlookup. thanks for your suggestions :)
– gee
Jan 30 at 6:25
"I am now creating new macro" - please share it and explain what it currently does, and how it should work different.(please don't answer in comment, but edit your question).
– Máté Juhász
Jan 29 at 8:27
"I am now creating new macro" - please share it and explain what it currently does, and how it should work different.(please don't answer in comment, but edit your question).
– Máté Juhász
Jan 29 at 8:27
So, you basically need a vlookup in another file?
– Moacir
Jan 29 at 11:13
So, you basically need a vlookup in another file?
– Moacir
Jan 29 at 11:13
yes I did. I also filter the data then delete all the blanks after I'd write down vlookup. thanks for your suggestions :)
– gee
Jan 30 at 6:25
yes I did. I also filter the data then delete all the blanks after I'd write down vlookup. thanks for your suggestions :)
– gee
Jan 30 at 6:25
add a comment |
1 Answer
1
active
oldest
votes
Unless you want to automate the process to be run regularly there is no need for a macro. You just need to open both files and create a VLOOKUP in the file you want your results in.
thank you. already did what you've said. and it worked out well. the output shows I really want. thanks a lot
– gee
Jan 30 at 6:24
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%2f1399535%2fmatch-columns-of-different-workbook%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
Unless you want to automate the process to be run regularly there is no need for a macro. You just need to open both files and create a VLOOKUP in the file you want your results in.
thank you. already did what you've said. and it worked out well. the output shows I really want. thanks a lot
– gee
Jan 30 at 6:24
add a comment |
Unless you want to automate the process to be run regularly there is no need for a macro. You just need to open both files and create a VLOOKUP in the file you want your results in.
thank you. already did what you've said. and it worked out well. the output shows I really want. thanks a lot
– gee
Jan 30 at 6:24
add a comment |
Unless you want to automate the process to be run regularly there is no need for a macro. You just need to open both files and create a VLOOKUP in the file you want your results in.
Unless you want to automate the process to be run regularly there is no need for a macro. You just need to open both files and create a VLOOKUP in the file you want your results in.
answered Jan 29 at 15:54
BradRBradR
925
925
thank you. already did what you've said. and it worked out well. the output shows I really want. thanks a lot
– gee
Jan 30 at 6:24
add a comment |
thank you. already did what you've said. and it worked out well. the output shows I really want. thanks a lot
– gee
Jan 30 at 6:24
thank you. already did what you've said. and it worked out well. the output shows I really want. thanks a lot
– gee
Jan 30 at 6:24
thank you. already did what you've said. and it worked out well. the output shows I really want. thanks a lot
– gee
Jan 30 at 6:24
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%2f1399535%2fmatch-columns-of-different-workbook%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
"I am now creating new macro" - please share it and explain what it currently does, and how it should work different.(please don't answer in comment, but edit your question).
– Máté Juhász
Jan 29 at 8:27
So, you basically need a vlookup in another file?
– Moacir
Jan 29 at 11:13
yes I did. I also filter the data then delete all the blanks after I'd write down vlookup. thanks for your suggestions :)
– gee
Jan 30 at 6:25