Suppose that we have 10000 rows with unknown number of columns in each row (0 to 700), which include lots of duplicated data in "Sheet4" like this.
I found a VBA in youtube but to do bulk find and replace but it takes lot of time and trouble.
May you optimize it to do it more fast?Please Login or Register to view this content.
Bookmarks