Hi
I am using Excel 2013 and I currently run a macro that gives me a NEW list of data which I could compare to the prior list. I am hoping to that via VBA code within the current macro I have set up. I want to compare a piece of data to the see if it matches the existing set of data (e.g. John Taylor = John Taylor). If there is a match, just add the associated data to the existing name. If the name on the new pull is NOT in the existing list, then add the name to the existing list AND fill in the appropriate data. Example below:
Column A has the existing list of names
Column B has a % value tied to each name
Week 1 run
John 50%
Suzy 60%
Sally 70%
Week 2 run
John 60%
Suzy 35%
Steve 75%
What I would like to see as the end result on the existing list is this:
Master list
John 50% 60%
Suzy 60% 35%
Sally 70% 0% (because Sally was NOT found on the new list, she gets a 0% for the current week)
Steve 0% 75% (Steve is on the new list so his data for that week flows over to the existing list with the prior week being 0% because he wasn't on the list during the prior run)
I hope this makes sense. My head is spinning trying to find a way to use a helper tab with the names from existing and the new pull and trying vlookups, etc, but I just cannot get anything to work like the above.
Thanks
Kent
I am using Excel 2013 and I currently run a macro that gives me a NEW list of data which I could compare to the prior list. I am hoping to that via VBA code within the current macro I have set up. I want to compare a piece of data to the see if it matches the existing set of data (e.g. John Taylor = John Taylor). If there is a match, just add the associated data to the existing name. If the name on the new pull is NOT in the existing list, then add the name to the existing list AND fill in the appropriate data. Example below:
Column A has the existing list of names
Column B has a % value tied to each name
Week 1 run
John 50%
Suzy 60%
Sally 70%
Week 2 run
John 60%
Suzy 35%
Steve 75%
What I would like to see as the end result on the existing list is this:
Master list
John 50% 60%
Suzy 60% 35%
Sally 70% 0% (because Sally was NOT found on the new list, she gets a 0% for the current week)
Steve 0% 75% (Steve is on the new list so his data for that week flows over to the existing list with the prior week being 0% because he wasn't on the list during the prior run)
I hope this makes sense. My head is spinning trying to find a way to use a helper tab with the names from existing and the new pull and trying vlookups, etc, but I just cannot get anything to work like the above.
Thanks
Kent