p45cal,

Thanks for the correction. As you suggested, I did cut/paste to display the result in a separate sheet and it worked.

Based on the sample file everything is working as intended. Now, my actual workbook contains over 3000 rows and columns A – X to include ID, Name, Code, Address, Amount etc.

What steps do I need to take to apply your method from scratch on this and similar projects in future?

TIA

Regards,