My requirements are simple. I have a huge worksheet with hundreds of rows and columns. I need to search a string or a part-of-the string, copy all rows which contain that part-of-string to a new worksheet and name the worksheet as the name of the string or sub-string.
I tried the following code:
The code works in excel 2010 but does not work in 2007. And it does not work for parts of string.
My columns are like this_midas_2050, that_midas_2040 etc.
I need to seach for midas in the worksheet and create a worksheet named midas.
Thanks a lot in advance
Bookmarks