Lux Aeterna
Board Regular
- Joined
- Aug 27, 2015
- Messages
- 205
- Office Version
- 2019
- Platform
- 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
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!
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!