Importing Data from a different worksheet

[Ceblevey]

Hi, I'm trying to make a sheet that will import data from another sheet when you type the "Run" of a product.

So for instance, in row B4 I type ATTCL it then pulls from the data sheet the name from column D, density spec from column H and sizes from column K for Length, N for Width and Q for Height and inputs that data in column's D+E, H+I and N5-7

Bare in mind I have a formula already set up for the size column that interreacts with the in spec/out of spec column's


Any help appreciated.

 

[Ceblevey]

All good guys! Managed to figure out myself! quite proud of myself as well

 

[RoryA]

Welcome to the MrExcel Message Board!

Well done for figuring it out, but for future reference:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Importing data from another worksheet when you type a name [SOLVED]

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...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.