help with macro to get rid of duplicates

[lyndseygus]

Hello i have a macro where i have information in columns A, B, E, and F. Columns A & B are being pulled in from one spread sheet and columns E and F are being pulled in from another spreadsheet. I would like to combine columns E and A into column A and get rid of duplicates. After this being said the rows that were in column F still need to line up with the value that they were with in Column E before E and A were combined.

Example of spread sheet:

A B E F
4070401052 .10 4070494685 6



*6 and 4070494685 need to stay together somehow after value 4070494685 is moved to column A.

Thanks!

 

[AKR22]

Hi,

Do you want column E to be the master column; so for every duplicate value the value in column A will be deleted? Will the duplicates in column A and E be on the same row?

Cheers,

AKR22

 

[MrKowz]

Hello i have a macro where i have information in columns A, B, E, and F. Columns A & B are being pulled in from one spread sheet and columns E and F are being pulled in from another spreadsheet. I would like to combine columns E and A into column A and get rid of duplicates. After this being said the rows that were in column F still need to line up with the value that they were with in Column E before E and A were combined.

Example of spread sheet:

A B E F
4070401052 .10 4070494685 6



*6 and 4070494685 need to stay together somehow after value 4070494685 is moved to column A.

Thanks!

Is there a need for a macro here? This can easily be handled with a few quick operations. Cut/paste E:F under A:B and then use Data>Remove Duplicates using column A as your criteria.