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!

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

Copy Data On Autofilter

Status
Not open for further replies.
vtops

vtops

IS-IT--Management
Oct 13, 2005
63
GR
Dear All,

I have a workbook with a button. Also all the columns have autofilter.
If the user apply any filter how can i copy the filter data in another workbook when user presses the button
?

Please Help me
Thanks a lot
And Best Regards
 
Sort by date Sort by votes
just copy everything as you would normally
hidden lines will not be copied

Record yourself doing this with the MacroRecorder

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Thank you very much xlbo
i can cintinue my project now
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
1K
remeng
remeng
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
1K
strongm
strongm
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
554
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
774
feipezi
feipezi
monyi
  • Locked
  • Question
Extracting Data from XML Node
Replies
0
Views
350
monyi
monyi

Part and Inventory Search

Sponsor

Back
Top