Please find attached a file that I hope is self explanatory. Details are on the worksheet.
I am getting unexpected results and I am sure that there is probably an easier way of writing what I am trying to achieve. My issue is explaining clearly what I am trying to achieve. There are hundreds of rows to add once the issues are solved. So I am hoping for an easier method of writing the VBA and assistance in understanding what is going wrong.
Regards, Matt
I am getting unexpected results and I am sure that there is probably an easier way of writing what I am trying to achieve. My issue is explaining clearly what I am trying to achieve. There are hundreds of rows to add once the issues are solved. So I am hoping for an easier method of writing the VBA and assistance in understanding what is going wrong.
Regards, Matt