Re: column duplicates / merge data formula and/or macro???
I have a spread sheet where in column A1 I have duplicate numbers. To the right I have the associated components of that number and need to be left unsorted. My goal is to create a macro that will take all the duplicates merge them and all other columns are left as is. This spread sheet will be used for a mail merge data base to fill out forms. On the forms I will have fields that will be filled out by the unique numbers in column A1 and in the body of the form the data to the left of Column A1 will be placed in the body of the form. Is there anyone that can help me?