Hello!



I would like to create a few tables in different sheets. Each table is predefined and has empty cells at the beginning.

In the first sheet, there is a cell in which I can choose (drop-down menu) an option, and the rest of the tables will be filled up according to this selection.

Basically, I need a quite way to organize construction elements of my building. So, if the building is made of wood, I choose wood in the first sheet, and the rest of the lists about other properties of this building is already filled in.

How to do this in Excel? Of course, before doing anything, I will fill in all the necessary information which has to be filled in.

Thanks!