Populate Table from other sheets based on drop down selection

[m2abrams15]

Hey all,

So i have this excel sheet, with a summary page on front. The summary page has a drop down menu to select the month desired. What i want is for the summary table to populate with the desired data based on the month. i thought about using a VLOOKUP, even tried it, but that doesn't seem to have worked.

here is the file. right now im just worried about getting the first table to work. Currently it fields are blank, its the formula i need to work out. Any help would be greatly appreciated


i tried to use ( =VLOOKUP($A$2,Sheet2!$A$2:$O$36,5,) ) as the formula but that returned errors.

[m2abrams15]

sorry, attachment didn't work

[Richard Buttrey]

Hi,

I'm puzzled why on the subsidiary sheets you haven't continued the July - December months across on the same rows which would have been more logical.

On the attachment I've therefore changed this on the Total Machines installed sheet. I've put the relevant formulae in B5:C16 on the Summary. YOu'll need to copy to other columns and change the sheet names of course.

Having said that I don't think the subsidiary sheets are the best way of collecting and using data. I think you've fallen into the trap of mixing up data capture layouts and reporting layouts. The two are different.
Almost invariably you should aim to build a simple multicolumn database for data capture, and then use other Excel functionality like Pivot Tables or Data Filtering for subsequent reporting.

So your data capture table should consist of columns for Date, Name, Element, Numeric Value/Qty
The Name and element column cells can be data validation cells which allow you to pick values from drop down arrows and avoids the need for typing.

Regards

[ladymuse]

Hello,

The reason for the spreadsheet separation like that was because they need to print the individual pages out from time to time. The formula you've put in here on the main page works beautifully, but it's missing some needed components and I can't figure out how to insert them. The summary page needs to display the rank totals from each individual spreadsheet and then take those by the scorecard value in row 4 on the main page. As I understand it, the rank value is ranking the districts against each other. This formula writing is beyond my ability. Any help is greatly appreciated. The deadline is approaching fast (January 31). Thank you in advance.

[nhen.enry]

Hi everyone! I'm a newbie here. Please allow me to post here since the thread title seems very related to my concern. I sincerely hope you will not find my post out of place.

I am currently working on a classroom behavior monitoring system. In sheet1-column 1, is the list of students. Running across the page are expected behaviors for each day (Please see Behavior Monitoring attachment). Cell entries will simply be Y (for YES) and N (for NO) linked from similar sheet.

Behavior Monitoring.jpg

In sheet2, I want to be able to generate an individual student behavior summary showing his/her demonstration (or non-demonstration) of each expected behavior for the week/s or month if I select him/her from a drop down list. (Please see Behavior Summary attachment)

Behavior Summary.jpg

I have read some related posts, but they are not totally the same as mine. Additionally, I really struggle with VB codes and FUNCTIONS. Please help.

[FDibbins]

nhen.enry, sorry, but forum rules state that you may not attach your question to an existing post. please start your own (new) post, and if you want, post a link to this thread.

thanks

[nhen.enry]

My apologies.