How can I extract a range of cells based on a filter view and copy them to another sheet ?

[omaoma]

How can I extract a range of cells based on a filter view and copy them to another sheet ?

( Example – Filter all the parcels sent in 03/04/2013 and make a list of them in the sheet LIST)
Thank you

[MaczaQ]

try somehow like this:

1st - execute some filter condition
2nd - run macro

Please Login or Register  to view this content.

This should work

[Charles]

Hi,

Welcome to the forum.
Are you wanting to specify the Date.
If so what column is the Date in?
What is the range you want to copy.
That is what column to last column.
Also if you do a search on this forum you may be able to find a solution.

[Harribone]

Once you have applied a filter, highlight the data then copy and paste.

Or you can approach this with the attached example. Sheet1 has the raw data, Sheet2 dislayed results based on date entered.

[Charles]

Hi,

Others have given you help.
This is my version. You will see a "Test" button it will display a input box for a Date. You must enter it
like 3/12/2013. When you click the "Ok" on the box the code should run.
I have it looking at column 3 for the Date if the date is not in that column you must correct the code for the correct column.

[omaoma]

Thank you for the quick answer. Could you tell me how to set the first range of cells (A1:c100) ? I dont know how many rows result after aplying the filter ..

[Charles]

Hi,

The file filters on the date you provide. It assumes that the Date is in column 3 it will only display the date that you inputed.
It will copy all of the visible info to sheet "List" It is code to look for the last row.
If you can provide a copy of your file. This will help.

[omaoma]

Thanks, Charles!

[Eduard]

Hi MaczaQ,

How to amend your code to keep the data in the format of destination cells, i.e. sheet2?

Thanks,
Eduard