05-06-2008, 10:51 PM
[quote N-OS X-tasy!]- Select all columns
- Selete Data > Filter > AutoFilter.
- Use a custom filter to show data only for years 2007 and 2008 (this assumes there is a Year column)
- Copy and paste filtered data
Your method is more efficient
I'll memorize it for I will be using it for the endurance of this job. Thanks!
- Selete Data > Filter > AutoFilter.
- Use a custom filter to show data only for years 2007 and 2008 (this assumes there is a Year column)
- Copy and paste filtered data
Your method is more efficient
