Consulting

Results 1 to 3 of 3

Thread: Find and Replace Macro code for multiple replacement

  1. #1

    Find and Replace Macro code for multiple replacement

    Hi friends,

    I want run a find and replace on multiple values from 2 column.

    I have2 Excel files,files from the first worksheet contains old Room number and new room number
    Column-A Column-B
    Old Room tag New room Tag

    -1.712 B-R121
    -1.651 C-F677
    - - - - around 500 values continues in columns as mentioned above.

    In 2nd files contain multiple worksheet (50 worksheet),I have to change Old room tags as new. i am struggling to change those taggs.Please advice.

  2. #2

  3. #3
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    This thread is a duplicate of: http://www.vbaexpress.com/forum/show...alues-in-Excel
    Kindly don't ask the same question in multiple threads. Thread closed. You may continue the discussion in your original thread.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

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