Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXPORT INFORMATION FROM ONE WORKSHEET TO THE OTHER VIA AUTOFILTER

Status
Not open for further replies.

L66CUR

Instructor
Mar 16, 2011
1
0
0
GB
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???

Thanks
 
Not without a macro.

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top