Is there way to update data based on alignment of certain cell data

[Irish15]

Ok, so I have a report that I need to update every few days and it takes hours. There has to be a better way. Not all of the info comes over correctly but the correct data is already on the spreadsheet from previous entries. Lets call this a badge report. When bringing over the new data to the badge report the new entries have the "badge number" aligned to the right. The old correct entries have the badge number centered. Is there way to have excel match the badge number and update other columns (in this case Group and Manager columns)?

I attached a sample spreadsheet if that helps. There are thousands of these so it would be really helpful to come up with a better way. Please let me know if you have any questions as I may not have explained that right.

Thank you

[jindon]

Try

Please Login or Register  to view this content.

[maniacb]

Try

Please Login or Register  to view this content.

[Irish15]

OMG, thank you so much! This worked! You saved me soooo much time. Thank you both for your replies. It works perfectly. I figured this was a total shot in the dark and almost didn't ask...so glad I did. Thank you, thank you, thank you!

[jindon]

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[Irish15]

Hi Maniacb,

Thank you again for this VBA code. I ended up using this one. It works great and I believe you set this up to match the badge number and update group (column E) and Manager (column F). I noticed that occasionally the names are a little different from time to time. Some include a middle initial, etc. Would you be able to update the VBA code to also update the Name (column D)? That would be really helpful

[maniacb]

Here is the update

Please Login or Register  to view this content.

[Irish15]

Awesome! It works great, thanks so much!