Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How generate new list in another worksheet from existing list?
I have a list in sheet 1 covering several colums, with a lot of parameters.
Lets say I have AA, BB, CC as parameters used in colum A. I would like to sort in a new list, in sheet 2, all AA. I would like to have all the belonging parameters in the same row as AA included in the new list (as if you were using filter). I would also like the new list in sheet 2 to update and expand it selv, when the main list in sheet 1 is updated (if the selected parameter is a part of the update). How to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I generate an email list from my worksheet? | Excel Discussion (Misc queries) | |||
how to generate data from a list on excel from another worksheet? | Excel Worksheet Functions | |||
How to filter list from pre-existing list | Excel Discussion (Misc queries) | |||
Add new inventory list to existing list | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |