PDA

View Full Version : VBA Script to fill in missing data



AlexKeith53
02-26-2017, 12:46 PM
Hi Everyone,

I am working on an Analytics project and need some help with formatting the data. I need a way to compare candidate names and fill in their candidate ID based on what data I already have. Below is an example of the data I am working with:





can_id
can_nam



MURPHY, SCOTT



MURPHY, SCOTT



MURPHY, SCOTT



MURPHY, SCOTT



MURPHY, SCOTT



MURPHY, SCOTT



MURPHY, SCOTT



MURPHY, SCOTT



MURPHY, SCOTT



MURPHY, SCOTT



MURPHY, SCOTT



MURPHY, SCOTT


H0NY20079
MURPHY, SCOTT M


H0NY20079
MURPHY, SCOTT M



MURPHY (NY), SCOTT



MURPHY (NY), SCOTT



MURPHY (NY), SCOTT



MURPHY (NY), SCOTT



MURPHY (NY), SCOTT



MURPHY (NY), SCOTT



MURPHY (NY), SCOTT



MURPHY (NY), SCOTT


H0NY20079
Murphy, Scott


H0NY20079
Murphy, Scott


H0NY20079
Murphy, Scott


H0NY20079
Murphy, Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
Murphy, H. Scott


H0NY20079
MURPHY, SCOTT M


H0NY20079
MURPHY, SCOTT M


H0NY20079
Murphy, Scott


H0NY20079
Murphy, Scott


H0NY20079
Murphy, Scott


H0NY20079
Murphy, Scott


H0NY20079
Murphy, Scott


H0NY20079
Murphy, Scott


H0NY20079
Murphy, Scott





can_id
can_nam



Aden, Doug



Aden, Doug



Aden, Doug



Aden, Doug



Aden, Doug



Aden, Doug


H0CO04148
Aden, Doug


H0CO04148
Aden, Doug



This is the case for multiple different candidates in the file and I need the can_id to exist for all. Does anyone have a dynamic way to do this?

Thanks!