Compare and replace Data [closed]
Comparing two excel workbooks and a specific column, and then replacing another column with specific data.
I have two Excel Workbooks. I need to compare names in workbook 1, Column B with Workbook 2 Column B. And then if there is a match, replace the email address in Workbook 1, Column c, with email address from Workbook 2, Column c.
How do I complete this in Excel and/or utilizing Kutools in Excel.
search find-and-replace comparison
asked Dec 21 '18 at 17:25
Bonnie Wnenkowski
62
closed as too broad by DavidPostill♦ Dec 21 '18 at 19:22
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
Comparing two excel workbooks and a specific column, and then replacing another column with specific data.
I have two Excel Workbooks. I need to compare names in workbook 1, Column B with Workbook 2 Column B. And then if there is a match, replace the email address in Workbook 1, Column c, with email address from Workbook 2, Column c.
How do I complete this in Excel and/or utilizing Kutools in Excel.
search find-and-replace comparison
asked Dec 21 '18 at 17:25
Bonnie Wnenkowski
62
closed as too broad by DavidPostill♦ Dec 21 '18 at 19:22
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
I do have Kutools, but can't find an answer on their site, and can't figure out how to even ask the question on their site.
– Bonnie Wnenkowski
Dec 21 '18 at 17:26
Please add additional information with an edit to the question and not as comment. This makes the question more neatly arranged.
– zx485
Dec 21 '18 at 17:36
Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill♦
Dec 21 '18 at 19:22
add a comment |
Comparing two excel workbooks and a specific column, and then replacing another column with specific data.
I have two Excel Workbooks. I need to compare names in workbook 1, Column B with Workbook 2 Column B. And then if there is a match, replace the email address in Workbook 1, Column c, with email address from Workbook 2, Column c.
How do I complete this in Excel and/or utilizing Kutools in Excel.
search find-and-replace comparison
asked Dec 21 '18 at 17:25
Bonnie Wnenkowski
62
Comparing two excel workbooks and a specific column, and then replacing another column with specific data.
I have two Excel Workbooks. I need to compare names in workbook 1, Column B with Workbook 2 Column B. And then if there is a match, replace the email address in Workbook 1, Column c, with email address from Workbook 2, Column c.
How do I complete this in Excel and/or utilizing Kutools in Excel.
search find-and-replace comparison
search find-and-replace comparison
asked Dec 21 '18 at 17:25
Bonnie Wnenkowski
62
asked Dec 21 '18 at 17:25
Bonnie Wnenkowski
62
edited Dec 21 '18 at 21:07
asked Dec 21 '18 at 17:25
Bonnie Wnenkowski
62
asked Dec 21 '18 at 17:25
Bonnie Wnenkowski
62
asked Dec 21 '18 at 17:25
Bonnie Wnenkowski
62
62
closed as too broad by DavidPostill♦ Dec 21 '18 at 19:22
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as too broad by DavidPostill♦ Dec 21 '18 at 19:22
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
I do have Kutools, but can't find an answer on their site, and can't figure out how to even ask the question on their site.
– Bonnie Wnenkowski
Dec 21 '18 at 17:26
Please add additional information with an edit to the question and not as comment. This makes the question more neatly arranged.
– zx485
Dec 21 '18 at 17:36
Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill♦
Dec 21 '18 at 19:22
add a comment |
I do have Kutools, but can't find an answer on their site, and can't figure out how to even ask the question on their site.
– Bonnie Wnenkowski
Dec 21 '18 at 17:26
Please add additional information with an edit to the question and not as comment. This makes the question more neatly arranged.
– zx485
Dec 21 '18 at 17:36
Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill♦
Dec 21 '18 at 19:22
I do have Kutools, but can't find an answer on their site, and can't figure out how to even ask the question on their site.
– Bonnie Wnenkowski
Dec 21 '18 at 17:26
I do have Kutools, but can't find an answer on their site, and can't figure out how to even ask the question on their site.
– Bonnie Wnenkowski
Dec 21 '18 at 17:26
Please add additional information with an edit to the question and not as comment. This makes the question more neatly arranged.
– zx485
Dec 21 '18 at 17:36
Please add additional information with an edit to the question and not as comment. This makes the question more neatly arranged.
– zx485
Dec 21 '18 at 17:36
Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill♦
Dec 21 '18 at 19:22
Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill♦
Dec 21 '18 at 19:22
add a comment |
0
active
oldest
votes
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
I do have Kutools, but can't find an answer on their site, and can't figure out how to even ask the question on their site.
– Bonnie Wnenkowski
Dec 21 '18 at 17:26
Please add additional information with an edit to the question and not as comment. This makes the question more neatly arranged.
– zx485
Dec 21 '18 at 17:36
Welcome to Super User! Please note that superuser.com is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill♦
Dec 21 '18 at 19:22