Hi All, I need help with simply code. What I need is check the column D find the name of the Month and copy to column I. Please check attached file.
Hi All, I need help with simply code. What I need is check the column D find the name of the Month and copy to column I. Please check attached file.
In I2 =MONTH(D2), format Custom "MMM" and copy down.
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
Hi alansidman, Can you prepare for me ready code to past straight to button Thank you very much
Try this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Working perfect big thanks for help
Here is another, more compact way to write the line of code I highlighted in red above...
For future readers of this thread who might find this interesting, here is a compact way to create a 1-d array of month names (the Mnths variable should be declared as a Variant)...Please Login or Register to view this content.
This code line was the basis for the macro I posted above.Please Login or Register to view this content.
Last edited by Rick Rothstein; 08-18-2019 at 10:08 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks