Recent content by uknwmedontu

Please do let me know..how you can help me in it. Thanks a ton

Hi.. Hui.. it is still not working and i am tense..now.. there is nothing to do with "WhHotN" its just a searching criteria which i named so. the "ExtractDetails" range is formatted as "general" although i did'nt very well understand..what u meant by the last question? i tried...

No, actually i have to do it in Excel 2003 only, that is the restriction from the university side. There are more than one criterias i have to sort it by city, country, region, report source, date, type (residential, hotel and so on..) r u sure that it is working in excel 2010 ?

Is there a better and a more beautiful way to implement the above search criteria ?

but the data will keep on increasing and changing..so the range will keep on changing.. Thanks a lot for reply 'Hui' Please find me a solution to the above problem

E2:E65 in the orignal data has hyperlinks

Hi i have written the following code , which searchs through various columns and basically filters my data and then copies it to the worksheet, but i am facing one problem, the source data has a columns containing hyper links to various other files on the system, but the copied data does not...