Automatic population of cells

New Contributor


Hi guys,


I basically want to be able to type something into a cell, and it then automatically insert and populate the rows below. For example lets say I type 'Flat', i'd like it to insert the appropriate rows from the other tab. I have attached an example. So if I Type in 'Flat' in cell A3 (as I have done), it will automatically insert into where I have highlighted yellow the items under 'Flat' from the other tab.


Also note that column 'Quantity' will be manually inputted and so no formula required.



2 Replies


In the attached version, I have changed the list on the second sheet to a table, with the type (Flat, Garage) in each row in a separate column. You can then use the Filter function.

That's great thanks @Hans Vogelaar exactly what I needed.