+ Reply to Thread
Results 1 to 2 of 2

Multiple Iterations of Find/Replace At Once (Feeding From A Table)

  1. #1
    Registered User
    Join Date
    10-17-2018
    Location
    India
    MS-Off Ver
    2016
    Posts
    1

    Smile Multiple Iterations of Find/Replace At Once (Feeding From A Table)

    I have a " Reference Table' stored at a particular shared drive folder with Symbols in Column A and Replacement Text in Column B.
    Need help with the Macro which can be used by anyone, which will fetch data from that location path and replace current active worksheet with Column A values to Column B values.

    Thank you

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,620

    Re: Multiple Iterations of Find/Replace At Once (Feeding From A Table)

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)


    Want to get your question answered quickly?
    • Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
    • On the other hand, skip irrelevant details. Be descriptive and concise. Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
    • Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
    • Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.
    • Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, scroll down to the Manage Attachments button, browse to the required file, and then push the Upload button.
    • If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.
    Last edited by protonLeah; 10-17-2018 at 03:20 PM.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to Find/Replace Record in One Table Based on Records in Another Table
    By DavidFC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2018, 04:41 AM
  2. Find-replace from static table with 2,630 find items
    By OhioRuss in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2018, 12:44 AM
  3. Problems exporting a table - find/replace data inside a table in word through excel vba
    By elvagonumero1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2018, 04:33 PM
  4. Replies: 16
    Last Post: 11-19-2013, 02:16 AM
  5. Tables Feeding data into a Further Table
    By JasonMcQueen in forum Excel General
    Replies: 13
    Last Post: 01-10-2013, 12:04 PM
  6. Multiple Find and Replace to replace a list of strings
    By WalterP34 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2011, 07:41 PM
  7. Find/Replace Macro Using Replace Table
    By LampCommandr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-24-2011, 11:00 AM

Tags for this Thread

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