Copy Filtered Data by selecting from a drop down list

's Computer Specifications

Hi

I have a worksheet called "QRF" with data about a number of work processes.
This sheet will act as the database. For control of data I don't want people
to use this sheet at all so I want to create a second "reporting" sheet.

In the reporting sheet I want people to be able to select an individuals
name from a drop down list and a macro then filters and copies all rows
containing that individuals name and pastes to the "reporting" sheet. The
reporting sheet would need to clear/refresh each time the macro is run and on
closing the workbook. Can anyone help with this please. Thanks in
anticipation!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: how do i copy data from the top cell of a filtered list to anothe.	Don Guillett	Microsoft Excel Worksheet Functions	0	14th Dec 2006 11:03 PM
Autocopy of data filtered by drop down list	=?Utf-8?B?SmVmZg==?=	Microsoft Excel Worksheet Functions	3	10th Aug 2006 07:41 AM
Drop down list from filtered data	Brady	Microsoft Excel Misc	6	28th Jun 2006 06:47 PM
Selecting data to run a query by using a drop down list	=?Utf-8?B?QVRhbmtlcjYy?=	Microsoft Access Queries	1	28th Feb 2005 04:21 AM
Copy data in filtered list	Andre Croteau	Microsoft Excel Misc	3	20th May 2004 10:54 PM