How to match, merge and sum data

**owum** · 06-18-2013, 06:56 PM

Hi all,

Calling for someone who can help me here with VBA macro.

I have data A1:D13 in Sheet1 where I want to match the data in Column A2:A13, then copy and sum the rest of the column to Sheet2 if they are matched, along with those which are not matched. Note that in column B, I want to 'merge' the string if data A is matched. Finally a status '1' or '0' if it has been changed. Please see the attached sample file.

All help is much appreciated! Thank you very much!

**rcm** · 06-18-2013, 11:12 PM

try the macro included

**owum** · 06-19-2013, 12:36 AM

Many thanks for the help! It works the way I want in my orig file, what about if I want to compare more than 2 dates? Should I modify the match function? Thanks again.

**rcm** · 06-19-2013, 01:45 AM

I was afraid you asked that...There would be more code to be added (for starters a loop to search each remaining record for more matches!!!)

**owum** · 06-19-2013, 08:55 AM

Thanks for the pointer, I will try to look into the loop. Can you or anyone point me to any posts with similar nature? Thanks again.

**rcm** · 06-19-2013, 10:30 AM

try it now, it should work for more than 2 matches

**owum** · 06-19-2013, 05:08 PM

Thank you very much, sir. You did it elegantly!

**owum** · 06-19-2013, 05:13 PM

How do I make this post as [SOLVED]?

**rcm** · 06-19-2013, 08:12 PM

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve

if any questions arise look into the ? button to your rightmost boundary or the FAQ
- Click Save