help with code

[mbaughuk]

I have an excel sheet that I need help with

I would like it to be able to find duplicate entries and then add on any points from a column that the two entries appear and then delete the duplicate line can anyone help

I hope this makes sense

Show Points 2013 - New.xlsm

[Sarvazad]

Hi mbaughuk,

I see you are newer to the forum like myself. Could you please make your title more relevant to the question you are asking? I believe this is one of the rules, and being new I don't want you to get scolded.

Upon looking at the file you have attached, I see you have a module with the subroutine "Sort_Add()" within it. Just so everyone else can see it easier, I'll put it in the quote box below. I am not entirely sure what you are attempting to do here however. Would you mind elaborating please?

Please Login or Register  to view this content.

[mbaughuk]

Hi Many thanks for the fast reply sorry I am new to this and not sure what to do really. do you know how to re title this thread as I cannot find it. what I need to do it add more dogs into column A and then add the points for the relevent show however as the year goes on this list will grow by a large amount and there will be times when a dogs name is duplicated I would like a macro to find the two entries and then add up the points and then delete 1 of the lines only showing the 1 line with all of the relevent points that have been accrued at the relevent show. I hope this makes sense

thanks

Marcuss

[Sarvazad]

You're welcome Marcuss. Hopefully someone here will be able to help you out more.

If you go to "Edit Post" on your first post, there should be a button for "Advanced Editing Options" or something of that nature present. From there you should be able to change and save the name.

Okay, so to break down your requirements, you are asking to (with regards to your sheet):

1. Sum the score horizontally
   
2. Add an additional button to enter additional dog's names
   
3. Have the summation button simultaneously search the list for duplicate entries, combine their results onto the original, then delete the duplicate.
   (For this one, will it only be you entering the names? And are they always entered in the same way? Otherwise spaces and such will make it more difficult than simply looking for matching strings of characters.)

Is that all correct?

[arlu1201]

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[mbaughuk]

Many thanks for everyones help

[arlu1201]

You have not changed your title yet. For the benefit of other users, please change your title.