Importing data from another worksheet when you type a name

[Sam Burton]

Hi so, I want to add a way to get information from a different worksheet to automatically fill in the rows that are required when you type in the name. I have more data that will be added to the "Data" sheet in due time, so it needs to be usable for any other data that's in that worksheet as well


For instance, typing ATTCL in B4 then populates Name D+E, Density spec H+I, and sizes N5,N6,N7 column's/rows with the data from the other worksheet.


Any help appreciated

Thanks.