Auto-population

[Gessen]

http://www.mediafire.com/?xkapa9pdf3o7fcv

Hi Guys,

So in the excell sheet above. I have master sheet and an individual category sheet. The name of each individual sheet correlates to a column on the master sheet. That column on the master sheet is broken into three vertical sections; Launched, Production, and Considering.

Each row of the category has a lot of information, but I want to focus on the supplier name and the Production Stage columns. The Production Stage cells have one of four options; blank, "Considering", "Production", and "Launched"

What I want to do is have a function on the master sheet that goes into the individual category sheets and pulls the supplier names into the appropriate section of their correlating column on the master sheet based on what value is found in the Production Stage column.

I know that is complicated, please let me know if you need any clarification or follow up. Can anyone help me with this. Feel free to respond here.

Thanks!

Gessen

 

[Joe4]

Welcome to the Board!

I removed your email address from the post for a few reasons:

1. We advise against posting your email in threads, as Spambots on the internet routinely patrol public user forums on the internet looking for email addresses to harvest (and Spam!). If you ever have need to share an email address with a member, we recommend doing so via a Private Message.

2. Also, we ask members try to resolve the problems here on-line, and not take it off-line, as it kind of defeats the purpose of having a searchable public database where all can benefit from questions that are asked and answered.

Also, many of us do not have the ability (or are unwilling) to download files from the internet (security concerns and corporate policies). So, you may find that you have more people able to help if you can post some examples right in the thread itself. There are tools you can use to post screen shots mentioned in this thread here: http://www.mrexcel.com/forum/showthread.php?t=508133

Regarding your question, I am one of those people who are not able to download your file, but skimming through your question, it sounds like a VLOOKUP formula may be what you are looking for. You use this to lookup a value in a table and return a related value. If you are unfamilair with this function, I would recommend checking it out in Excel's built-in help files. They have a detailed explanation of how it works along with examples.

I would recommend starting there, and posting back to this thread if you run into trouble (and trying to add the screen shots, if you are able).