Correct mistaken info

[Lux Aeterna]

An excel-friend here created a macro for me, that finds inconsistent names that are assigned to the same Serial number. That macro searches all sheets named List**** and brings up all inconsistencies, which I then have to correct one by one! Take a look at the picture below

I was wondering if it is possible to define the correct* ones, possibly through a checkbox, and fix all the other ones accordingly. In my example, the correct ones are the 1st and the last one. So, the macro will search for the other three registrations (rows 34, 35, 36) in the corresponding sheet, fix them accordingly, and add a comment in the corresponding sheet name cell saying "previously registered as ..." and the value the cell had previously.

By the way, there might already be a comment in that cell, so the new message should be added, without replacing the old content in the comment.

*or maybe the wrong ones, whatever is easier for you and lighter for my PC

Sheet names are List**** (**** stands for the year)
ID is in column A
Name is in column C
Serial number is in column E

Thank you in advance!

PS. After that I am going need some more additions to the macro.

That is, locating the PDF file in my computer (C:\Users\pc50\Documents\Resultsfolder\****\, renaming it with the new value (Eric Cartman, in my example), and opening it with a specific PDF editor program.

But even the first part will be of much help!

Thanks again!

 

[Lux Aeterna]

Don't know if it's ok to comment my post to bring it up!

 

[Lux Aeterna]

Bringing up my request again

 

[abdelfattah]

your thread is not clear , moreover you ask things are different requirments with comparison the tilte!

So, the macro will search for the other three registrations (rows 34, 35, 36)

I suppose you have one name , you need to correcting based on your picture.

and add a comment in the corresponding sheet name cell saying

which is in column E,or ...?

By the way, there might already be a comment in that cell, so the new message should be added, without replacing the old content in the comment.

Totally unclear.

That is, locating the PDF file in my computer (C:\Users\pc50\Documents\Resultsfolder\****\, renaming it with the new value (Eric Cartman, in my example), and opening it with a specific PDF editor program.

this is totally different subject
I suppose for you using XL2BB t o show original data bfore and expected result after it to members help you.
Good luck.

 

[Lux Aeterna]

Thank you so much for your feedback. Indeed, the title is not really indicative of what I ask. I tried to keep it short!

I'll answer your questions one by one.

I suppose you have one name , you need to correcting based on your picture.

The picture is just an example. Let's say, for example, that there are 5 entries under the same Serial number. At least 1 of those entries is correct. I need to have all the others corrected.

which is in column E,or ...?

In column C of the relevant List*** sheet. For example, for the row 35 entry, the comment should be added in List2023 / Row 7 (that is the ID on the picture + 5) / Column C (cell C7)

Totally unclear.

Sometimes, there might already be a comment in the cell. In the above example, cell C7 might already have a comment in it. So, the macro should update the old comment instead of replacing it. For example, List2023 / C7 might have a comment saying "Referred by John". The macro should change the comment to "Referred by John. Previously registered as Eric Kartman."

I suppose for you using XL2BB t o show original data bfore and expected result after it to members help you.

I tried to use XL2BB but I my PC crushes every time. I can upload a copy of the excel to Dropbox if necessary.

 

[abdelfattah]

show original data bfore and expected result after it to members help you.

without this nobody can help you
based on your explenation should post it by pictures

I tried to use XL2BB but I my PC crushes every time.

read and follow for this link
XL2BB - Excel Range to BBCode
maybe else body help. now I'm goning out.