+ Reply to Thread
Results 1 to 4 of 4

Find part of current workbook name and paste in matched

  1. #1
    Registered User
    Join Date
    12-15-2014
    Location
    Wales, UK
    MS-Off Ver
    365
    Posts
    66

    Find part of current workbook name and paste in matched

    Good day,

    I have to find a part of the workbook name and if it matches one of 4 options, paste the corresponding name in a cell.

    Example: Workbook name: Consumer Inland SDC
    If "Inland" then paste "Inland" in Cell A4
    If "WC" paste "WC" in A4, etc. for 4 options

    I've searched through numerous posts on the internet and have no idea how to do this. If someone can help, please, thank you.
    Last edited by Simone Fick; 07-24-2017 at 08:06 AM.

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Find part of current workbook name and paste in matched

    Hi Simone,

    You gave the one example of a workbook name... is that always the same? Meaning 3 words... or even better, is it always "Consumer" and "SDC" with, in between, the part you want to paste in A4?

    Also... there are 4 options... does that mean one of the 4 ALWAYS happens? Or we need to check to see if it matches one of the 4?
    Last edited by Arkadi; 07-24-2017 at 07:44 AM.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Find part of current workbook name and paste in matched

    Maybe

    Please Login or Register  to view this content.
    Kind regards
    Leo

  4. #4
    Registered User
    Join Date
    12-15-2014
    Location
    Wales, UK
    MS-Off Ver
    365
    Posts
    66

    Re: Find part of current workbook name and paste in matched

    It work perfectly thank you

+ 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] VBA Macro pull a certain cell in closed workbook and copy/paste into current workbook
    By Hoover5896 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2017, 01:36 AM
  2. Open workbook, copy rows, paste to end of current workbook
    By gmn734 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2013, 05:16 AM
  3. [SOLVED] Need a complicated formula to display part of current workbook name in a cell
    By ianpwilliams in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-06-2013, 01:41 PM
  4. [SOLVED] [How-to] ask marco to find, cut, paste entire row to new sheet if matched?
    By hark in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 11-15-2012, 01:55 AM
  5. Filter data on seperate workbook and paste on current workbook
    By ZeDoctor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2012, 08:08 AM
  6. find data not used, find last row and paste(stuck on last part! pls help)
    By donyc in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-23-2011, 09:30 AM
  7. match columns and find the matched Part number
    By rajivs27 in forum Excel General
    Replies: 5
    Last Post: 02-17-2010, 04:46 PM

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