Using Drop Down Box data for a Summary Report

I have developed a monthly report with drop down boxes and I want to link a summary sheet that will recognise the text in the drop down box and calculate as numbers for reporting.
Thanks Michele

Hi Michele,

Perhaps some dummy data and some kind of idea of what the output should be would be helpful?

BSB.

Hi Michele,
I am also working at a clinic and understand your file. But you did not clear that what you really want to do. You should have to elaborate your question. I also use excel for patients. But in many different ways.

Hi Michele,
I am also working at a clinic and understand your file. But you did not clear that what you really want to do. You should have to elaborate your question. I also use excel for patients. But in many different ways.

I have attached an updated spread sheet with dummy data and you can see the drop down box information. The column's that I need to tally have an asterix * in the heading.

This is my problem and I am not sure there is a solution:
I want to be able to set up a Summary Sheet that will link to the Report Sheet recognising the drop down information entered on the Report Sheet numerically so that the Summary Sheet ends up tallying with a number
value.
Thanks
Michele

Hi Michele,

I think you attached the wrong file as there was still no dummy data.
However, take a look at the attached. Is this something like what you're looking for?

I've taken the liberty of adding the data validation to the columns you've starred.

Let me know if that's of any help OR if I'm WAY off in my assumption of your need.

BSB.

Thank you very much this has been a great help Merry Xmas.
Michele

Happy to help. Let us know if there are further questions on it.

BSB

I do have another problem that I cannot solve with the attached spread sheet.

On the Client Report Sheet and the Monthly Summary Sheet I have added new data fields;OOS,OOS(Group),Clinical Time(hrs),Other Time(hrs).

How do I add these columns in the Client Report Sheet and link to the Monthly Summary Sheet so the totals are
automatically calculated for each month in the Monthly Summary Sheet.
Thanks
Michele

Hi BSB
I do have another problem that I cannot solve with the spread sheet.

On the Client Report Sheet and the Monthly Summary Sheet I have added new data fields;OOS,OOS(Group),Clinical Time(hrs),Other Time(hrs).

How do I add these columns in the Client Report Sheet and link to the Monthly Summary Sheet so the totals are
automatically calculated for each month in the Monthly Summary Sheet.
Thanks
Michele

Hi Michele,

Sorry for the delay. Been away from the forum for a couple of days.

What do you want to do with these columns? I'm guessing for 'Clinical Time' and 'Other Time' you wish to sum the hours recorded against each month(?), but I don't what what 'OOS' and 'OOS(Group)' are so I haven't a clue what you want doing there. Perhaps summing those too?

BSB.

Maybe this is the sort of thing you had in mind?

BSB

BSB
Thank you.
Yes, I did want to SUM the hours, OOS, and OOS group.

Another issue that has occurred with this spread sheet relates to where I have added drop down boxes in the cells on the Client Report Sheet.
How do I modify the drop down boxes so that multiple options if required can be identified in the Column N (Chronic Illness), Column O (Other Conditions) and Column P (Treatment Provided)?
Then the next question is how do you add the multiple selections automatically in the Monthly Summary Data.
Thanks
Michele