| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort between worksheets depending on variable
Excel formula
I need to sort or transfer the data entered into one sheet to automatically show on another sheet within the same workbook but depending on the variable. For example in Sheet A I have names in cells A2 - A10 and in cells B2 - B10 assigned them a value of either L (left) or R (right). I want these names exported to different sheet depending on whether they are L or R. In the order found in the original sheet. Excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide and protect worksheets depending upon who is looking? | Excel Discussion (Misc queries) | |||
| Reading Data from another workbook... depending on variable in a cell? | Excel Discussion (Misc queries) | |||
| Sort : how can I use a variable in a VB sort function? | Excel Worksheet Functions | |||
| How to read CSV lines into different Worksheets depending on a date field? | Excel Discussion (Misc queries) | |||
| Compare 2 Worksheets Create a 3rd depending on results | Excel Discussion (Misc queries) | |||
Threaded Mode
