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.
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.
Maybe
Kind regards
Please Login or Register to view this content.
Leo
It work perfectly thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks