Hello Saad3000,

It is possible to do this with formulae but you would need to change your format. The macros are faster since the only run when needed. Every formula in the workbook will be run anytime a change is made to cell that contains a formula. While the formula is often easier, it isn't always the best approach. If you have questions about the code or what it does, just ask.

Sincerely,
Leith Ross