I'm working on setting up a management system for process audits, which are required in various departments on either a monthly or quarterly basis. Each sheet contains several rows of audit criteria and yields a single score on the top parent row showing plant, audit, date, and score. Since there are multiple plants, multiple audits, and frequent audits, the number of these will quickly get quite large. I'd like to have a combination sheet or report that pulls in only the parent row from each audit, but I'd also like to be able to include formulas so that I could tell whether the audits are completed on time (requiring a rolling due date depending on prescribed frequency), and highlights audits that are below standard. Where should I go for tips on handling multiple sheets in a format that allows formulas (I don't think these are permitted in Reports)?
