mncwattersjr
New Member
- Joined
- May 3, 2017
- Messages
- 3
Hello all,
First time posting. I am attempting to create a spreadsheet where 1 employee can enter inventory counts on one sheet and another employee can place orders off of the same data that has been copied over to another sheet. I also want the "orders" sheet to autohide/unhide the cells that have a quantity of zero. I have searched all over this forum and found many insightful suggestions but none seem to work for my situation. so here is an example
sheet1
materials (columnA)
1
2
3
4
Inventory (columnb) place for data entry
10
15
0
20
order quantity (columnc) automatically calculated by predetermined max/min inventory levels
10
5
20
Sheet2
materials
1
2
3
4
Order quantity
10
5
20
0
Ideally when the information is entered in to sheet1 then the last number (lets say is in cell B4) should disappear until we have inventory then it should automatically reappear. there are actually 15 lines, but if you can show me the concept i think i can get it! thanks in advance!
First time posting. I am attempting to create a spreadsheet where 1 employee can enter inventory counts on one sheet and another employee can place orders off of the same data that has been copied over to another sheet. I also want the "orders" sheet to autohide/unhide the cells that have a quantity of zero. I have searched all over this forum and found many insightful suggestions but none seem to work for my situation. so here is an example
sheet1
materials (columnA)
1
2
3
4
Inventory (columnb) place for data entry
10
15
0
20
order quantity (columnc) automatically calculated by predetermined max/min inventory levels
10
5
20
Sheet2
materials
1
2
3
4
Order quantity
10
5
20
0
Ideally when the information is entered in to sheet1 then the last number (lets say is in cell B4) should disappear until we have inventory then it should automatically reappear. there are actually 15 lines, but if you can show me the concept i think i can get it! thanks in advance!
