Hello everyone, I really need help with this VBA code. What I need first from the spread sheet below is to first detect duplicates from a table and only delete based on the following condition.
--If they have a 1st signature OR a 2nd signature then keep the line.
--If they do not have either a 1st signature OR a 2nd signature then it is deleted.
--If they have both a 1st signature AND a 2nd signature, check for duplicates 1 more time and if there is still a duplicate delete the one with the earlier created
Keep in mind this has to work in a table column and below is a sample of what I am trying to achieve
START with this
FI-Last Name Created Date 1st Signature Date 2nd Signature Date
JO-FA Sep 2, 2014 Sep 2, 2014 Sep 2, 2014
JO-FA Aug 26, 2014 Aug 26, 2014 Aug 27, 2014
JO-FA Aug 27, 2014
PA-RI Aug 25, 2014 Aug 25, 2014
PA-RI Aug 26, 2014 Aug 26, 2014
PA-RI Sep 2, 2014 Sep 2, 2014 Sep 2, 2014
TE-LE Aug 26, 2014
TE-LE Aug 25, 2014
TE-LE Sep 2, 2014 Sep 2, 2014
END with this
FI-Last Name Created Date 1st Signature Date 2nd Signature Date
JO-FA Sep 2, 2014 Sep 2, 2014 Sep 2, 2014
PA-RI Sep 2, 2014 Sep 2, 2014 Sep 2, 2014
TE-LE Sep 2, 2014 Sep 2, 2014
Any help would be really appreciated
--If they have a 1st signature OR a 2nd signature then keep the line.
--If they do not have either a 1st signature OR a 2nd signature then it is deleted.
--If they have both a 1st signature AND a 2nd signature, check for duplicates 1 more time and if there is still a duplicate delete the one with the earlier created
Keep in mind this has to work in a table column and below is a sample of what I am trying to achieve
START with this
FI-Last Name Created Date 1st Signature Date 2nd Signature Date
JO-FA Sep 2, 2014 Sep 2, 2014 Sep 2, 2014
JO-FA Aug 26, 2014 Aug 26, 2014 Aug 27, 2014
JO-FA Aug 27, 2014
PA-RI Aug 25, 2014 Aug 25, 2014
PA-RI Aug 26, 2014 Aug 26, 2014
PA-RI Sep 2, 2014 Sep 2, 2014 Sep 2, 2014
TE-LE Aug 26, 2014
TE-LE Aug 25, 2014
TE-LE Sep 2, 2014 Sep 2, 2014
END with this
FI-Last Name Created Date 1st Signature Date 2nd Signature Date
JO-FA Sep 2, 2014 Sep 2, 2014 Sep 2, 2014
PA-RI Sep 2, 2014 Sep 2, 2014 Sep 2, 2014
TE-LE Sep 2, 2014 Sep 2, 2014
Any help would be really appreciated