I need help with inventory products. In excel I have 2 sheets. First sheet is template, where I want to enter number of room lets say 400 in one cell like b3. After i enter number in cell b3 i want inventory products, like pc, desk, chairs automatically display under in template that i create based on room number. Second sheet is my data base with all inventory products organized by room and inventory number.


