Hi!
Back in the office and tried the template. It looks really good. I added 1500 extra lines in the DataEntry and Errors tab and copied the formulas down.
I was wondering if you could also help me with a formula that would calculate the total number of issues by issue type?
As explained earlier, I will copy all the rows that have issues in an Excel document that I will be sending out to management (exactly the same as the Template we are working on except for the Code column that will be hidden or deleted. In the current template, one row may have multiple issues. For the Excel document, there may only be one issue by row. So for the rows that have multiple issues, I will copy the row multiple times.
I.e. Template, row 5: issue 3 and 12
Document, Issue 3 represented in row 5 and issue 12 in row 6.
I would like to have the totals represented in the Excel document. Knowing that the number of data row will vary from week to week, I was thinking of creating a tab for each week. Here is what my Excel document currently looks like.
Is it possible to have the total number of issues transposed in the code week tab? If so, would I need to adjust the formulas every week? (For example, this week we are 1937, next week 1938, etc.) Maybe I'm wishing too much
but it would avoid doing manual entry. If it's too complicated, maybe I could add some line at the top of the DataEntry tab where the totals would be presented based on the filters I apply on the tab.
Hope I make sense!
Thanks again for all your help