I've created a database with 10 columns and about 500
lines. I autofilter based on a value in column 10 and
want to copy and paste the data (do not want the header
copied). The autofilter first selected ciriteria is line
114 (this can change from month to month). I tried to do
a copy end down end right using recording a new maco,
unfortunately because one of the columns in the first line
of the database is empty, I am not copying all the data
that I need. The end right is only going to open column
in the second line of the database (which is NOT included
in the autofilter). How do I modify the macro code to
work around this issue?

Thanks