| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Rows to New Sheet based on User Selection in Drop-down List
I posted something similar, but wasn't at all clear. This is what i am
trying to do. I want to place a drop-down select box on Sheet 3 with values 1-12, representing months of the year. I want the user to be able to select a month value from the drop-down select box. Once the value is selected, i want Excel to search column B on Sheet 1, looking for all date values matching the month selected by the user. I then want Excel to copy the identified rows in Sheet 1, including column headers, to Sheet 2, replacing anything that was there previously. Can anyone help me out with this? -- Carlee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating values based on selection from a drop-down list in Exc | Excel Worksheet Functions | |||
| Formula to populate a drop down list based on the selection of ano | Excel Discussion (Misc queries) | |||
| count based on selection from drop down list | Excel Worksheet Functions | |||
| Based on Drop-Down Selection go to that Section on Sheet | Excel Discussion (Misc queries) | |||
| Copy row data based on drop down list selection | Excel Programming | |||
Linear Mode
