Results 1 to 2 of 2

Multiple Find & Replace

Threaded View

Bikash Shaw Multiple Find & Replace 09-15-2012, 03:37 AM
JBeaucaire Re: Multiple Find &... 09-15-2012, 09:29 AM
  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Kolkata
    MS-Off Ver
    Excel 2007
    Posts
    19

    Multiple Find & Replace

    I have a database sheet which is getting updated in daily Basis and the respective reports are also update by the database.

    There are three columns 1)Name 2)Address 3)ID

    while typing the name some mistakes occur.

    I have created a master sheet of the Right names & Wrong Name.

    Right Wrong
    A SAHA and CO A.Saha and Co.
    ADARSHA KRISHI BHANDER Adarsh Krishi Bhandar,Mainaguri
    ADARSHA KRISHI BHANDER Adarsha Krishi Bhandar
    ADARSHA KRISHI BHANDER ADARSHA KRISHI BHANDAR ( M )
    AGRO CHEM Agro Chem
    AJOY KUMAR NAYAK Ajoy Kumar Nayek, Bahargram
    ALOKE KUMAR GHOSH Aloke Kumar Ghosh (Howrah)
    ALOKE KUMAR SAHA and BROS ALOKE KUMAR SAHA and BROS.
    ALOKE KUMAR SAHA and BROS ALOKE KUMAR SAHA and BROS.,


    the master sheet is too long for me to manually find a wrong name & replace it with the right name by "Find & Replace".

    the macro should first search the Database and then if it finds the data come back to the master sheet pick the Correspondent data from new value and come and replace the same on the database worksheets.

    Please help me with some solution.

    Thank You
    Bikash
    Last edited by Bikash Shaw; 09-15-2012 at 03:54 AM. Reason: explanation

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