| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create separate list of only selected data
I am needing to create a new sheet (Sheet 2) of information based on whether
an item is selected on another sheet (Sheet 1). ie: (Sheet 1) Item QTY Cost Total Shoe 0 $33 $ Shirt 2 $70 $140 Pants 0 $104 $0 Jacket 1 $112 $120 Hutch 0 $173 $0 If I only want the 2 lines that are greater than 0 to be shown on my summarized sheet, how do I show those 2 rows together instead of being separated? Sheet 2 Item Qty Cost Total Shirt 2 $70 $140 Jacket 1 $112 $120 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
| Create a separate list of duplicates | Excel Discussion (Misc queries) | |||
| Data Validation from list on separate Workbook | Excel Discussion (Misc queries) | |||
| A validated List which link to selected cells according to what is selected on the list | Excel Worksheet Functions | |||
| How do I create a validation list on a separate worksheet? | Excel Worksheet Functions | |||
Threaded Mode
