|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-28-2008, 03:11 AM
|
|||
|
|||
|
Copy filtered data to a new sheet?
Hello everybody,
I hope you are all well. My question is quite simple. I have a file for my database with 10 sheets, who are similarly built (same columns). I would like to extract filtered data to another sheet who would be a recap. I would like only to extract the columns A, B , and C (First name, name and another criteria) and the filter is applied on the column B. I have Excel 2007. I hope that i have been clear, if you really need it i can upload an example (not very easy for me as data is confidential). All the best, Alain 
|
|
#2
08-28-2008, 08:00 AM
|
||||
|
||||
|
Hi,
using Data - Filter - Advanced Filter you can paste filtered data where you like.Maybe doing the drill once while recording a macro will allow do repeat the process if needed. Cheers
__________________
Cheers Here you can find the forum rules Non English speaking forum Relevant keyword thread title helps searching for info
|
 |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Compare data and copy to matched row | mark_jam3s | Excel Programming | 2 | 06-17-2008 07:58 AM |
| Copy data from multiple sheets to single sheet | maacmaac | Excel Programming | 11 | 04-22-2008 11:22 AM |
| How do I prevent Excel from adjusting formulas when inserting new rows of raw data? | maxedison | Excel Worksheet Functions | 3 | 02-13-2008 06:28 PM |
| Copy Data to another sheet based on the Value | Rajkumar | Excel Programming | 5 | 02-04-2008 06:36 AM |
| Copy filtered list to new sheet? | drdavidge | Excel Programming | 5 | 11-21-2007 01:34 PM |
Linear Mode
