Find like value from data dump, change multiple cells within row
up vote
0
down vote
favorite
I have names and various data, including dates. Data dump worksheet includes Names, Date, and data. I want to look within existing multiple worksheets to find the name from data dump WS, then update the date and increase the count of two additional cells. Can this be done with a formula, or do I need to find someone to write a macro?
Existing WS
Alexander | 24NOV18 | 13 | 6
Dump WS
Alexander | 18DEC18 | (irrelevant data)
Desired output on Existing WS
Alexander (no change) | 18DEC18 | 14 | 7
(where the last two columns are a simple +1 on the previous count)
microsoft-excel
edited Nov 21 at 2:18
Scott
15.5k113789
asked Nov 20 at 23:50
Byron Denman
11
add a comment |
up vote
0
down vote
favorite
I have names and various data, including dates. Data dump worksheet includes Names, Date, and data. I want to look within existing multiple worksheets to find the name from data dump WS, then update the date and increase the count of two additional cells. Can this be done with a formula, or do I need to find someone to write a macro?
Existing WS
Alexander | 24NOV18 | 13 | 6
Dump WS
Alexander | 18DEC18 | (irrelevant data)
Desired output on Existing WS
Alexander (no change) | 18DEC18 | 14 | 7
(where the last two columns are a simple +1 on the previous count)
microsoft-excel
edited Nov 21 at 2:18
Scott
15.5k113789
asked Nov 20 at 23:50
Byron Denman
11
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have names and various data, including dates. Data dump worksheet includes Names, Date, and data. I want to look within existing multiple worksheets to find the name from data dump WS, then update the date and increase the count of two additional cells. Can this be done with a formula, or do I need to find someone to write a macro?
Existing WS
Alexander | 24NOV18 | 13 | 6
Dump WS
Alexander | 18DEC18 | (irrelevant data)
Desired output on Existing WS
Alexander (no change) | 18DEC18 | 14 | 7
(where the last two columns are a simple +1 on the previous count)
microsoft-excel
edited Nov 21 at 2:18
Scott
15.5k113789
asked Nov 20 at 23:50
Byron Denman
11
I have names and various data, including dates. Data dump worksheet includes Names, Date, and data. I want to look within existing multiple worksheets to find the name from data dump WS, then update the date and increase the count of two additional cells. Can this be done with a formula, or do I need to find someone to write a macro?
Existing WS
Alexander | 24NOV18 | 13 | 6
Dump WS
Alexander | 18DEC18 | (irrelevant data)
Desired output on Existing WS
Alexander (no change) | 18DEC18 | 14 | 7
(where the last two columns are a simple +1 on the previous count)
microsoft-excel
microsoft-excel
edited Nov 21 at 2:18
Scott
15.5k113789
asked Nov 20 at 23:50
Byron Denman
11
edited Nov 21 at 2:18
Scott
15.5k113789
asked Nov 20 at 23:50
Byron Denman
11
edited Nov 21 at 2:18
Scott
15.5k113789
edited Nov 21 at 2:18
Scott
15.5k113789
edited Nov 21 at 2:18
Scott
15.5k113789
15.5k113789
asked Nov 20 at 23:50
Byron Denman
11
asked Nov 20 at 23:50
Byron Denman
11
asked Nov 20 at 23:50
Byron Denman
11
11
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f1377134%2ffind-like-value-from-data-dump-change-multiple-cells-within-row%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
