attachment

Hi David

Give this a try.

Hope this helps.

Sunny

Thanks  millions Sunny, it works  beautifully. Also thanks to pointing out the consistency in the Master record data

also the layout inconsistency..

Hi David

Thanks for your nice comments.

I have updated my earlier codes to include a progress bar that was created by Philip Treacy. Hope you like it.

https://www.myonlinetraininghub.com/excel-progress-bar-for-vba

Sunny

Wow, that's terrific and fancy, you make us like a film star on a Broadway show. 

Sunny, honestly you always add Bonus to our VB work, not ony that it create positive momentum in all our Excel work.

Thanks is not enough,  but really don't know what else say to you and your team. Anyway have to say thanks again.