Is it possible to have an excel sheet with autofilter on it so that when the user selects the criteria in the autofilter it will then export this information into another worksheet in the same file???
But, as long as the selection isn't too complex (meaning made up of too many separated pieces), you can just copy and paste. Excel will, by default, only copy the visible cells.
[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.