| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtered info, into next sheet
I have a master sheet, where users enter their data in rows. One of the columns has a list, formatted using data validation, th list has six options. For those 6 options I want the data sorted int different sheets in the workbook. How can I get the data on the master sheet - sheet1, to appear on th next sheet - sheet2, with only those rows where option 1 was chosen And sheet3 contains those rows for option 2 .. And so on for the other options -- hays ----------------------------------------------------------------------- hays4's Profile: http://www.excelforum.com/member.php...fo&userid=2806 View this thread: http://www.excelforum.com/showthread.php?threadid=48483 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paseting filtered info into another sheet | Excel Discussion (Misc queries) | |||
| help-sum filtered info on excel for more than one filter | Excel Worksheet Functions | |||
| filtered info can be copied (extracted) to seperate sheet | Excel Discussion (Misc queries) | |||
| How do I compare info in on sheet to info in another? | Excel Discussion (Misc queries) | |||
| transfering info from one sheet to another based on info being transferred | Excel Programming | |||
![hays4[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
