+ Reply to Thread
Results 1 to 1 of 1

Compare Data Script To check Names

  1. #1
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Compare Data Script To check Names

    Ok I have this spell check script working now thanks to "VBA Noob" however The spell checker isn't automatic. Which means I need to keep changing the names in each worksheet manually.

    So is there a way that I could use the spellchecker or a script that would look at Sheet1 column (A:A) with a list of names that are correct and check all my other sheets2,3,4,5 ect. Column (A:A) and make changes to the names that dont match sheet1?

    Here is an example book:

    Again Thanks everyone for all your help.

    Mike
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1