Hi,

Thanks for the help !

Attached the file with the comments and the datas to be filled in the Paid & Wait sheet highlighted.

Also have hidden the rows from 6-25 to show the corresponding headings for easy reference.

Comments given in the corresponding fields which date to be taken and which not to...

Hope this will be clear !
Am new to VBA started learning now only...

Thanks for the help in advance !!!

-Sindhuja