I am assembling a work order tracking workbook. Sheet 1 contains a dashboard with that uses basic countifs and sumifs to plug in data from a work order input sheet. The input sheet contains cells that have date,unit,task,labor,parts,status. The balance of the work book contains sheets for each unit. I am looking for help to accomplish the following;
Sheet 1 Dashboard
Sheet 2 Work Order Input
Sheets 3 - 100 - summary of work orders for each vacation rental
I want to pull the input data as it is entered and auto plug into the individual unit sheets based on the unit # criteria
For instance when i enter the work order information into sheet 2, i want excel to search criteria for that specified unit and take the date,task,labor,parts and status and plug into one of the sheets 3-100 and track.
Sheet 1 Dashboard
Sheet 2 Work Order Input
Sheets 3 - 100 - summary of work orders for each vacation rental
I want to pull the input data as it is entered and auto plug into the individual unit sheets based on the unit # criteria
For instance when i enter the work order information into sheet 2, i want excel to search criteria for that specified unit and take the date,task,labor,parts and status and plug into one of the sheets 3-100 and track.