Forum Discussion
Automatic population of cells
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.
Thanks!
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.
