Show the Month details in row wise based on the Date Duration

[Kamalakar M]

Hi All,

A quick help required on the below inputs.

I have few employee list as Input details , which talks about the for a particular duration an employee is tagged to which project and customer.

Now I want to derive the 1st of every month between the duration provided of each employee and the month details to be shown as row wise.

I have attached the sample data in the attached worksheet. It has two sheets called “ Input” and required output in “Output” sheet. Can this be achieve through macro ?

Please help

Regards,
Kamal M.

[karedog]

Maybe :

Please Login or Register  to view this content.

[Kamalakar M]

Hey Karedog, this is picture perfect solution.

thanks a ton for your quick help on this. Thanks once again.

[karedog]

You are welcome.

Don't forget to mark this thread as solved :
Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.