Split of data into seperate rows using a date range

Hi,

I have a tricky problem (at least for me) involving a long list that summarize data for a date range in one row per person. I need to split the one row into individual rows based on the date range.

Every entry contains basic data of a person that should stay the same for every row. In the example file there are 3 columns that contains the following; total hours, number of days and a starting date.

I need to split the hours (column I) evenly on as many rows as it says in (column J) and I need to add individual dates for each row starting from the start date in (column O). I hope my explanation make sense. I apologize for any grammar mistakes.

I believe it should be possible but I'm not skilled enough to solve it. Any help would be much appreciated.

Best regards
Anders

Try this code to see if this works as per your requirement.

Please Login or Register  to view this content.

Hi again,

It looks like I was a bit to fast with my cheers for a problem solved.

I need data from additional columns after the O column. Where in the code can I adjust this?
The information should be as is but on every row just like the others.

Thanks for all help!

BR Anders