BShady
New Member
- Joined
- Apr 26, 2010
- Messages
- 2
Hi! I think this will be easy for someone smarter than me.
The data: I have a list of items in for repair, and record the date the item hits a particular department in a spreadsheet. Departments are columns, Items in for repair are rows.
What I've done: Created a sheet with a row for each day of the year, and a column for each department, and countif in each cell using the date in column A as criteria to determine how many repairs on a given day are in a given department.
The problem: I lose historical data because as a unit moves from dept to dept, the cell formulas causes a subtraction on one date and addition on another.
The solution (I think!) Use VB to do the counting and paste the count into a corresponding cell.
The data: I have a list of items in for repair, and record the date the item hits a particular department in a spreadsheet. Departments are columns, Items in for repair are rows.
What I've done: Created a sheet with a row for each day of the year, and a column for each department, and countif in each cell using the date in column A as criteria to determine how many repairs on a given day are in a given department.
The problem: I lose historical data because as a unit moves from dept to dept, the cell formulas causes a subtraction on one date and addition on another.
The solution (I think!) Use VB to do the counting and paste the count into a corresponding cell.
- Using today as the date (or ask?) and set it as target-date
- For every row in each of 12 columns (depts) count target-dates recorded there
- Paste count into new (or target-date corresponding) row and corresponding dept column of a sheet named "Report counts"
