AutoFilter help!

[golfnut019]

After autofiltering the data that I need, I need to copy that data onto another worksheet.

How do I specify the range? There are some rows that are not showing that I don't need and the rows that i DO NEED start at 100 and this will always change daily. I need a formula/method to select the first row and on after being autofiltered.



TIA

 

[Greg Truby]

Erik,

I haven't used XL97 in so many years, I honestly don't remember what prompted me to start doing it that way. Back in 1998 when I started using Excel (before that, I used QuattroPro and before that, Lotus) there was no MrExcel.com so I was casting about doing the best I could on my own. I remember picking up too many records if I didn't pull from just the visible cells, but I can't recall the exact context, sorry.

Have a good weekend.

 

[golfnut019]

Thanks guys.

I'll see if it goes well and let you guys now.



Cheers.

 

[zami]

For example :

The data table I have is ordered by partner ID, partner name, spend $, and date. Now, I want the data for only 11/16/2005. When I autofilter it, 11/1-11/15 is taken out and now I am left w/ the rows of data (there are multiple rows of 11/16 as well as other dates) that is associated with the date/transactions relating to the date 11/16/2005.

How do I specify the range of the autofiltered data? The autofilter headers start at row 4 but after autofiltering, depending on the date, for 11/16 the row after the header starts at 122. How I select all the data for 11/16?


TIA

I'm no wiz at this, but wouldn't using the (Custom...) option in the date column filter show only the rows pertaining to 11/16?

 

[erik.van.geit]

I'm no wiz at this, but wouldn't using the (Custom...) option in the date column filter show only the rows pertaining to 11/16?

golfnut019 succeeded to filter the data, he must have used that method - what else ? -, that's what at least I've understood from the first post