HI, I have been beating my head against this problem for some time but haven't yet managed to find a solution. I have an extensive spread sheet of financial data that i am trying to transpose into a different format. I am sure a VBA script will do the job but i am very inexperienced in VBA coding and everything i have tired so far has failed.
I am trying to make this (sample only):
| Index | Start Date | End Date | Monthly Cost |
| index 1 | 01/01/2015 | 25/04/2015 | £100 |
| index 2 | 02/04/2017 | 03/06/2017 | £120 |
| index 3 | 03/05/2013 | 01/08/2013 | £150 |
Look like this:
| Index | Start Date | End Date | Monthly Cost | Billing Date |
| index 1 | 15/01/2015 | 25/04/2015 | £50 | 15/01/2015 |
| index 1 | 15/01/2015 | 25/04/2015 | £100 | 01/02/2015 |
| index 1 | 15/01/2015 | 25/04/2015 | £100 | 01/03/2015 |
| index 1 | 15/01/2015 | 25/04/2015 | £33.30 | 01/04/2015 |
| index 2 | 10/04/2017 | 10/06/2017 | £80 | 10/04/2017 |
| index 2 | 10/04/2017 | 10/06/2017 | £120 | 01/05/2017 |
| index 2 | 10/04/2017 | 10/06/2017 | £40 | 01/06/2017 |
| index 3 | 05/05/2013 | 30/08/2013 | £125 | 05/05/2013 |
| index 3 | 05/05/2013 | 30/08/2013 | £150 | 01/06/2013 |
| index 3 | 05/05/2013 | 30/08/2013 | £150 | 01/07/2013 |
| index 3 | 05/05/2013 | 30/08/2013 | £150 | 01/08/2013 |
I have other data in other columns that i would also need to copy down but it wouldn't need to change just stay aligned to the correct index (in case it makes a difference i am using Excel 2013).
Any help would be much appreciated.
