Advanced Filter

Vishesh's picture

With advanced filter in Excel using menu while trying to find out Unique, the limitation is that the destination range should be on the same sheet as the source. However, using VBA there is no such limitation. Using VBA the source and destination ranges in Advanced filter need not be on the same sheet.

not like that... If you

not like that... If you initiate advanced filtering putting your curser/cell pointer on the new sheet... it wont create any problem in excel itself. Means first put your cell pointer on new sheet (instead of data sheet) and then start performing advanced filtering...