Hi, my name is Martin L and this is my 1st thread. I hope someone can help with this query as my vba is virtually none existence.
I want to split the date range Date From (Col M) and Date To (col N) so there is 1 day (only weekdays so ignore weekends) per row. e.g. ID 1 will have 2 rows, ID 2 remains as 1 row and ID 3 has 5 rows.
Thank you and much appreciated.
Martin
Last edited by martinello69; 09-04-2020 at 04:23 AM. Reason: sorry pressed wrong button
Hello martinello69,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
You have posted a question in a forum that is meant to be used for making introductions.
Please repost your question in one of the Microsoft Office Application Help - Excel Help forums linked below.
https://www.excelforum.com/microsoft...el-help-forum/
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks