Advanced Filter
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.
»
- Vishesh's blog
- Login or register to post comments
- 13687 reads
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...