If the current Workbook is named "Alex Yoong 120399", how can I pull out just "Alex Yoon" and paste it to the Destination:=Workbook(Data).Worksheets(Sheet1).Range("A1").
Something like this:
ActiveCell.Offset (-1,1).Copy Destination:=Workbooks(Data).Worksheets("Sheet1").Range("A1")
Thank you for your help.
This worked for me.
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
looks good, but unfortunately that macro is not dynamic. I am looking for something more dynamic where a name can be "Alex Hu Mai 1843". I this case, I just want only Alex Hu. I believe your macro will pull "Alex Hu Mai"
You have provided two different criteria. In simple business terms, how would you describe the conditions under which the name is extracted. For VBA to fully automated (dynamic in your terms) it must have definitive criteria, ie. some form of standardization.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks