|
|
|
|
#1
04-08-2020, 12:11 PM
|
||||
|
||||
A VBA solution is certainly possible—and a lot more fun
 —but I'd need to know what variations you think the filenames might exhibit before I can come up with an algorithm. What else might the filename look like, and which part do you want to extract in each case?And I see your point about the user being able to enter a table of possible filename types and associated formulae—more flexible that way. I'll try to take a look at that tonight (since my original program didn't work for you) and make a program that behaves correctly. 
|
|
| Tags |
| paste formula lookup |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| LOOKUP Formula error but WHY??? | Haga | Excel | 1 | 04-17-2019 11:13 PM |
| N/A Value in Lookup Formula | NickFazer | Excel | 2 | 04-02-2019 04:22 AM |
| How to update lastname with the help of V-Lookup formula? | Mangesh1212 | Excel | 6 | 12-05-2018 02:15 AM |
| Need help with lookup formula | tristanlau | Excel | 1 | 08-14-2017 07:16 AM |
 Lookup / Paste Multi Values VBA
|
Mav | Excel Programming | 6 | 05-10-2015 08:42 PM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode