Trying to have a drop down menu selection bring up information.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

Make your layout more conducive to data handling - get rid of merged cells and split lines in the data table - leave graphics to a template page if you need to print reports.
The attached table is more like the format you would need if you want to data handle without resorting to complex formula.

I am rarely confused, but today must be my off day, I have read the thread several times referring to your workbook.
Can you expand with a few examples of what outcome you expect and the method of producing it.

Sorry Torachan im obviously not explaining it very well. If you check the template you updated, its a table of info. What i need is for each of those headers to be a drop down menu, and depending on which option i pick it will update rows 2-38 with the corresponding info for that selection.

For instance, if i select COADMx6 on the drop down, the cells beneath it will populate with that sites info, so row 23 for instance will be quantity 6. And depending on the project depends on how many sites i have, so id like to have say 30 columns total where i can edit the site type. I presume id also need an "Empty" header so that all of the values were zero? So that if i only have 6 sites, it only counts the 6 sites, i dont have 30 sites all being counted

So i can add the drop down menu bit thats not the issue, the problem is the rest of the table being updated accordingly.

Shipping lists Template testscreenshot.jpg

Hopefully this screenshot works

Sorry, I am going to have to pass on this one.
I need to understand things clearly, I do not get the purpose when the data is already on the sheet
I am obviously missing something obvious.

I do have a modest understanding of Excel and its applications.
However I am failing to see where you are getting the quantities from to update your sheet.
As I do not posses a crystal ball I must regrettably forgo this challenge due to my failing abilities.

Hi,

I agree with Torachan

It's not clear (at least to me) what it is you're trying to achieve. We always prefer to see a before and after position along with the clear rules you have used t0 get from one to the other. Essentially your data should be in a regularised two dimensional table, with columns for each UNIQUE type of information (and I mean type, not a specific value) and rows for individual records. Once that's in place then the world's your lobster and you can analyse/report/summarise with a Pivot Table.

Therefore upload your workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

Remember that when you ask a question in a forum those of us who might be able to help know absolutely nothing about your system and work process or the terminology you use. Unless you have uploaded a workbook we know nothing about how it is laid out and little about what you want done with it or how the results should be presented.

Whilst these things are second nature to you since you live with the workbook all the working day we start with zero knowledge so you need to take us by the hand and explain in quite precise detail your aims and goals as well as stuff like how your data might look different in other situations.
Don't assume we are able to "figure it out". We're usually quite good but not psychic.

Put yourself in our position and think about whether what you've posted makes sense and is unambiguous to someone who's never seen it before. You are asking us for help so help us to be able to help you by providing all the information we need, even if that information seems obvious or intuitive to you.

I'll take a stab at trying to figure this out.
On Sheet1 are a list of sites in column A and a table of values in columns C:K
On the Summary sheet row 3 is populated using drop downs linked to the list.
Cells D6:J51 are populated using: =IF(OR(D$3="n/a",$B6=""),"",INDEX(Sheet1!$E$6:$K$50,MATCH($B6,Sheet1!$C$6:$C$50,0),MATCH(D$3,Sheet1!$E$2:$K$2,0)))
Let us know if you have any questions.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' as AliGW requested. I hope that you have a blessed day.