Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut and Paste after Auto FIlter
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
Auto-Filter copy/paste problem | Excel Discussion (Misc queries) | |||
how to auto "copy & paste" (or filter) from a Master spreadsheet? | Excel Worksheet Functions | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) |