vba code to keep unique data entries
Posted on 2014-03-11
Hi Experts Excel 2007
Need vba code to do the following and apologies I cannot upload a sample file from my location.
Business Name. Reference.
Based on the above table keep the unique values based on col d (reference) and delete the rest..in this case we have edf twice in col A and Office twice in col d so remove.
Need the macro to loop through 20000 rows of data..
Where there is a single line as with dcf keep in the table.