PDA

View Full Version : Autofilter copy/paste



Johnpants
11-18-2005, 06:00 AM
Hi, I am using an autofilter to get a single row of data, I then want a button to run a macro that will copy the cell in column a that is showing, to a different cell.

I can get the majority of this working, I have the button and can paste the copied cell to where I want, but the problem I am having is getting the macro to copy the cell from the autofilter..

Can anybody help with this please?
Thanks.

lucas
11-18-2005, 08:50 AM
Hi Johnpants,
Check out this knowledgebase entry for filtering data and copying to a different sheet. If it doesn't help post back here. It uses a range to decide what to filter for and copies the results to a different sheet. It also is set up for 2 criterea for filtering but can be changed to suit your needs.
Filter and Copy (http://vbaexpress.com/kb/getarticle.php?kb_id=567)