I want to create a macro that will take information from one worksheet to another. The problem is that the first worksheet has an autofilter and i do not know how copy information only from the cells that were filtered with the correct information without copying it manually.
Last edited by ctdutro; 02-20-2009 at 05:15 PM.
You can use
You might want to add a check for a Filter
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I suspose my broader question would really be this
How can I have ONLY the filtered data in order to use it as my rowsource property of my listbox..ie, I would like my listbox to display only the rows of data that are visible after filtering, not the entire list which I began with.
Could the same code still be used?
Why not ask this in the first place? Take a look at the code that I use to Filter data & display it in a Listbox in this example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks