VBA code for this
Budget: ₹600 – ₹1,500 INR
if the D column is yes then 1. copy the same row, 2. copied row will have C column increment by 1, subsequent C column no will also increase by 1 . Small demo output is mentioned in the sheet two