Advanced Filtering
Is it possible using Advanced Filtering, to have the output go to a different
Sheet, instead of the current sheet(database Sheet). Thanks in advance. Tony |
In 2003, it asks (data, filter, advance filter) if the data should be copied
to another location. Don't know about other versions. Carole O "Tony" wrote: Is it possible using Advanced Filtering, to have the output go to a different Sheet, instead of the current sheet(database Sheet). Thanks in advance. Tony |
Yes you can, but you need to start the filter on the destination sheet and
browse back to the data range you want to filter, Regards, "Tony" wrote in message ... Is it possible using Advanced Filtering, to have the output go to a different Sheet, instead of the current sheet(database Sheet). Thanks in advance. Tony |
Thanks Alan,
It worked like you said and it is exactly what I needed. Tony "Alan" wrote: Yes you can, but you need to start the filter on the destination sheet and browse back to the data range you want to filter, Regards, "Tony" wrote in message ... Is it possible using Advanced Filtering, to have the output go to a different Sheet, instead of the current sheet(database Sheet). Thanks in advance. Tony |
All times are GMT +1. The time now is 02:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com