Move contents of a cell based on contents of another cell

Hi,

This is difficult to explain but here goes,

Column A has changing values and if that value only appears once in that column then do nothing, but if the value appears more than once as in value 114612546-a below then move the value of colum C to Column D of the first appearance of that value as displayed below.

Start like below:
Column A Column B Column C
114745628-1 8/2/2012 883020360433190
114748693 8/2/2012 883020360433145
114612546-a 8/2/2012 883020360433305
114612546-a 8/2/2012 883020360433381
114612546-a 8/2/2012 883020360433389


After vba code runs like below:

Column A Column B Column C Column D Column E
114745628-1 8/2/2012 883020360433190
114748693 8/2/2012 883020360433145
114612546-a 8/2/2012 883020360433305 883020360433381 883020360433389
114612546 8/2/2012 883020360434295

The value in column A can appear up to 14 times before the script runs but above is my required result.

Thanks for any help,

David

Please Login or Register  to view this content.