Additional problem related to 1016964-split-of-data-into-seperate-rows-using-a-date-range

[ploppmongo]

Hi,

I've already got some really good help solving a split of data.
http://www.excelforum.com/excel-prog...ml#post3729492

Original problem was this

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 now encountered a new major problem related to this. The number in the J column can apparently be negative to indicate that something were taken away from the database. I need the negative numbers to be treated as a positive number for the split but then displayed as negative number again.

Included is an example file with input and needed output. In that file the macro created by watersev for the original problem is included. All credits to watersev!!

I got help from a friend who could solve it.

Please Login or Register  to view this content.

[arlu1201]

Thanks for providing the solution.