| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Filtered Data by selecting from a drop down list
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting from drop down list enters multiple cell data | Excel Worksheet Functions | |||
| how do i copy data from the top cell of a filtered list to anothe. | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| Autocopy of data filtered by drop down list | Excel Worksheet Functions | |||
| Drop down list from filtered data | Excel Discussion (Misc queries) | |||
Linear Mode
