mperrah
03-23-2007, 04:06 PM
Hello all, it's been a while,
I have a "detail" page that shows qc info for all my techs. Each job has it's own line so there may be several entries for a specific tech.
My "report" page has one row for each tech and counts the number of pass, fail or NA entries from the "detail" page.
I am manual using auto filter and entering the data by hand.
Can I use countif and look up the tech number then check the offset for the columns with pass, fail and NA?
The "report" sheet has a column for each result so I can put a formula in the answer cell for each on the "report" page.
Also, I send the report out each Monday, and keep the detail info for each previous week. So as I auto filter I scroll to the current week.
Can I use a drop down box on the report page with each date range for the year pre-entered to look for the current week range to look up on the detail page?
I'll paste the file.
I think Formulas might do this but the date searching I think would work better with VB - Isn't everything better with VB :)
Thanks for any insights. :think:
Mark
I have a "detail" page that shows qc info for all my techs. Each job has it's own line so there may be several entries for a specific tech.
My "report" page has one row for each tech and counts the number of pass, fail or NA entries from the "detail" page.
I am manual using auto filter and entering the data by hand.
Can I use countif and look up the tech number then check the offset for the columns with pass, fail and NA?
The "report" sheet has a column for each result so I can put a formula in the answer cell for each on the "report" page.
Also, I send the report out each Monday, and keep the detail info for each previous week. So as I auto filter I scroll to the current week.
Can I use a drop down box on the report page with each date range for the year pre-entered to look for the current week range to look up on the detail page?
I'll paste the file.
I think Formulas might do this but the date searching I think would work better with VB - Isn't everything better with VB :)
Thanks for any insights. :think:
Mark