I hope to display only rows containing the word "Total" in the attached sheet.

Try:

Please Login or Register  to view this content.

Thank you so much for the quick reply. I'm afraid I may be doing something wrong with the application of the macro and I'm not sure I understand how to work with the Criteria window. I tried selecting the cell containing the value "Total" (AD2) but it didn't work. Am I doing something wrong?

That works perfectly! Thank you so much.

Will this work?

Thank you for replying. Actually my goal was to show only the totals rather than hiding them. Jaslake's macro works perfectly. I may be able to make use of your macro in some other cases. I do appreciate it.

Oh sorry I misread your post. I will go ahead and post this one as another option, because i recently posted it for someone else, and it is probably the macro i use more frequently than anyother. IT will create a new page, returning all occurrences of your seaRch. It will also add hyperlinks with cell addresses for each occurrence.

Please Login or Register  to view this content.

John:

Sorry for the slow response. I have marked the issue as SOLVED. Thank you very much.

I hope to do more with the data but don't want to cross a line of requesting too much so please tell me if my request is unreasonable.

I hope to take the consolidated data and total it by department each week, then show each of the departments on a line graph. I would also like to show the individual totals separately as percentages of a 40-hour capacity (perhaps on a table like the original). Both charts will be used to project available bandwidth for a resource (and a department) in the weeks to come. I will do this manually but as I will need to repeat this on a regular basis based on the same core report, it will be wonderful if anyone can provide assistance with pieces of this so I can streamline the process.

Sincerely,

Mike

John:

I will start a new thread. I should have some examples of the desired outputs tomorrow.

Thank you.

Mike

John:

I posted my examples in a thread entitled "I hope to convert a table from values to % of a 40-hour capacity and graph dept totals". Please let me know if I have omitted anything. Again, if the request is unreasonable, please let me know.

Mike