Correct mistaken info

Lux Aeterna

Board Regular
Joined
Aug 27, 2015
Messages
205
Office Version
  1. 2019
Platform
  1. Windows
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

1712678666720.png


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! 🙏 🙏
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,224,820
Messages
6,181,160
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top