Split Revenues Between Date Ranges

Hi

I have a list of items and associated revenues with a start date and end date.

I would like to use a macro to split the revenues evenly between the two dates, with a separate row for each date.

The example attached shows a simplified version of the data I'm using on one tab and the output I would like to achieve on the next.

If anyone could provide any help I would be very grateful.

Thanks
Tom

Try this code

Please Login or Register  to view this content.

Thank you so much - really helpful.

I've extended it to match my data as below. I'm concerned that as I include more data it will become very slow to run. Is this an inefficient way of doing it?

Please Login or Register  to view this content.