aka_krakur
Active Member
- Joined
- Jan 31, 2006
- Messages
- 438
Can someone help me with the VB for a macro to select only the rows/cells within an autofiltered selection. So if I Autofiltered this set of data by Column F where Lookup = NO
it would only display Rows 3 & Row 7.
I would want the Macro then to select only these rows, then copy/paste them to another Worksheet called "Static".
it would only display Rows 3 & Row 7.
I would want the Macro then to select only these rows, then copy/paste them to another Worksheet called "Static".
Book2 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Incident# | EntryDate | ReceivedDate | #ofdays,EntrytoReceived | InstAct# | Lookup | ||
2 | 123456-1 | 02/16/09 | 02/24/09 | 8 | A1 | YES | ||
3 | 654321-2 | 02/17/09 | 02/19/09 | 2 | A2 | NO | ||
4 | 456125-1 | 02/17/09 | 02/25/09 | 8 | A3 | YES | ||
5 | 345678-3 | 02/17/09 | 02/25/09 | 8 | A4 | YES | ||
6 | 123456-2 | 02/17/09 | 02/23/09 | 6 | A1 | YES | ||
7 | 654321-3 | 02/17/09 | 02/23/09 | 6 | A2 | NO | ||
8 | 456125-2 | 02/17/09 | 02/23/09 | 6 | A3 | YES | ||
9 | 345678-4 | 02/17/09 | 02/23/09 | 6 | A4 | YES | ||
10 | 123456-3 | 02/17/09 | 02/25/09 | 8 | A1 | YES | ||
Sheet1 |