05-06-2008, 10:35 PM
- 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
- 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