Hi,
I'm struggling to start this as I'm not sure how to make the script at different ranges within the worksheet.
I need to define a range to form a sum equation when it finds the first blank cell in the column, there is always a block of 3 blank rows together. I then need to repeat this for the next range of cells down the column.
As the ranges will always change I'm not sure how to make this dynamic so that it will find the first and last cell of the next range and step 3 rows once it finds a blank cell to then continue the loop again.
Any help would be appreciated.
Thanks
I'm struggling to start this as I'm not sure how to make the script at different ranges within the worksheet.
I need to define a range to form a sum equation when it finds the first blank cell in the column, there is always a block of 3 blank rows together. I then need to repeat this for the next range of cells down the column.
As the ranges will always change I'm not sure how to make this dynamic so that it will find the first and last cell of the next range and step 3 rows once it finds a blank cell to then continue the loop again.
Any help would be appreciated.
Thanks