The test data in 1.xls is much too large for help in a forum. There are too many rows to post.
We just need enough data to test macro.
It is difficult in a forum to work with many rows.
Reduce the rows
We need just enough data to test.
Pick your test data carefully.
Just use a few rows. But pick your test data carefully so that it test all scenarios


What does this mean?
Quote Originally Posted by fixer View Post
i have a vba code but has a little error
You must give more details

From where do you have this macro(vba code)?

Alan