Hi Kishoremcp,

For dynamic data range, you can use defined names but still not clear after seeing the image you posted. Can you clarify more with a workbook ? Thanks.

Regards,
DILIPandey
<click on below * if this helps>