Split date period into seperate dates

Hi,

Im working with a sheet where i need to split a range/period of dates into seperate lines and the informations connected to the dates should be copied aswell into the new sheet. I have some work in the period 01/04/2013 to 03/04/2013 and want to split this period into 3 rows with one date in each row.

The sheet my dates are listed in is called "4 mrds planen" and the sheet where my dates should be spilted is called "4 mrds_udvidet".

When the dates are splitted i need to copy all the other informations from sheet "4 mrds planen" to "4 mrds_udvidet".

I have been battling with this for weeks now.

Hope there is a "excel guru" here, who can sort this out and help me.

thanks :-)

rgds
Sivran

4 mrd planen.xlsm

Try:

Please Login or Register  to view this content.

Hi Armando

I cant make it work. Can you put it in a macro in my file and upload that. I really cant make it work.

Thanks for your time :-)

rgds
Sivran