| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditionally Fill a sheet row if cell value in another sheet 0
I am not sure is this is a function or a simple formula set.
My Sheet 1 "Inventory" has 150 rows of item data with column 2 ("B") holding an inventory amount .... either 0/empty or a value 0 I would like to populate rows of another fresh Sheet (Sheet 2) only if Sheet1 Col "B" 0 (i.e. there is inventory of that item) Thanks -scot (I can do this with AutoFilter... but it requires an intermediate sheet for my work...and confuses our "sharing" of workbooks...so I am looking for a formula, or if needed a function) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum of 3 nos. into 1 cell in another sheet relevant to specific da | Excel Discussion (Misc queries) | |||
| Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
| Linking a dinamic cell value from one sheet to another | Excel Discussion (Misc queries) | |||
| How do I make the fill color of a cell on one sheet follow the co. | Excel Worksheet Functions | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
