Find and Replace when needed Code

Hello guys, at my project (I send a sample file to see it) I have 2 sheets (sheet 1 and sheet 2) . At the sheet 1 there are 2 headings "Rank" and "Name" and below those headings in cells B4 and C4 you can write the Ranking and the Name of a person (for example Rank 1 , Name George). Then there is a button that is titled "Add". When you press it, the data goes to Sheet2 in two columns (A:B) where column A is the Rank and Column B is the Name. The code I used for the button is :

Please Login or Register  to view this content.

Now what I need is that in the same code (when you press the "Add" button) to have a code that will search the range A1:B50 and if it finds a previous entry (for example Rank 1, Name George) it will delete the content of those two cells and will place in that cells (that have been cleared) the new entries for example

Old data

1 George
1 Peter
1 Michael
2 John


New data

3 Peter

Should be Now

1 George
3 Peter
1 Michael
2 John

Thanks guys for your time

hmm the file should have the macro let me check, I am at my laptop now and using different excel maybe it's some setting there. Let me check it

Yeah sorry for that, it was a mistake I saved it as a normal book and not with activated macros I upload it again.

Nice it works great!! thanks both of you rep added

hm I did copy the code to my project but for some reason I get the error 1004 when I push the button :/ can you please check it? at the test file it worked perfectly .

The tabs we are interrested in are "talents" and "Charactersheet"


Thanks guys.