Thanks Arlette,
It works well but I would like to modify it as the formula uses indirect and The reference cell needs to be incremented accordingly.

Cheers