Detailed summary of a spreadsheet

Hi gents,

I want to do something on my worksheet but it is beyond my excel knowledge, I admit it is too complicated for me, I know it is possible and I hope someone can help me or at least give me something to start working on.

I attached the sample worksheet I'm working on. it is basically a spreadsheet to help me keep tracks of documents.
on the top (F1:F6) you will notice a brief summary of the documents. but I actually want to show a much more detailed summary.

I'm planning to display the contents fn the "section" and how many approved Procedure or SOP or Form currently they have.

here's a sample output I want to display below.

Drill & Blast

• Procedure 6
• SOP 1
• Form 5

Exploration

• Procedure 7
• Form 6

Geotech

• Procedure 17
• Manual 5
• SOP 2
• Form 14

If I could display it on userform, much better and neat.

Hope I explained my query clear, if it is not clear let me know and I will do my best to elaborate.

Thank you in advance.

Try this formula to hopefully get you started;

Formula:

Please Login or Register  to view this content.

=6

Okay, thats true, I've done that before, sorry, but let me rephrase my problem. is there a way to put the "Drill & Blast" on the formula without writing the actual word drill & blast? because example I deleted or added a new section, then I need to update my formulas again..

A pivot table would do this.

I've added a quick one to your sheet.

Hi,
You can use pivot with filter on Status, check out attached file.

Thanks, I will search how this pivot works..
but couple of questions:

1) will this pivot table works even I "share Workbook"?
2) is it possible to display this pivot table on userform?

Originally Posted by kasan

Hi,
You can use pivot with filter on Status, check out attached file.

Hi kasan, thanks for it, it is quite similar to my desire. newby question, how do you tally the total? how do you insert the "Count of status" in the values?

Try

Please Login or Register  to view this content.