Can it be extended to other columns? Yes. As it is currently coded? No.

If that was your ultimate intention it should have been stated in the first post. Please provide a sample workbook of your actual data and layout (or fake data representing actual data if it is confidential) and show what you want the result to be, where and why.