missrutele
New Member
- Joined
- Nov 17, 2017
- Messages
- 10
I have 3 sheets with listed different models there you can indicated how many you need of which model (~300 models). I need to use a formula in another sheet that check these sheets and if cell is not blank (quantity indicated), return information to main sheet (order sheet) - name, barcode and quantity.
For example with smaller amount of models:
in model sheet I have such information and I choose item and indicated needed quantity in column C
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Than in main sheet i need that information would be like this (would shown just ordered goods)
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Please someone help
For example with smaller amount of models:
in model sheet I have such information and I choose item and indicated needed quantity in column C
Barcode | Name | Quantity |
022677030104 | item1 | |
022677280431 | Item2 | 2 |
022677271934 | Item3 | 1 |
024777670679 | Item4 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Than in main sheet i need that information would be like this (would shown just ordered goods)
item | Barcode | Order |
Item2 | 022677280431 | 2 |
Item3 | 022677271934 | 1 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Please someone help