I am new to this and my question is posted with humble and kindness. I have tried this several times but get stuck. I am curious if it is possible to make the enclosed file to a for-next loop?
Can you please in simple English explain what you are trying to do?
Don't worry about the VBA Code, just explain what you are trying to achieve with your data ?
I think you misunderstood what Hui was asking of you. Instead of providing us with a Macro that does not suit you, tell us step by step in simple English what the steps you would do manually that you wish to have VBA do. With this information in hand we can then design for you an efficient macro that achieves what you want. We are Excel experts here, but we are not mind readers. Help us to help you by giving us specific information that we can convert to a successful solution.