I will be having 5 sheets in the workbook. First sheet is data entry sheet looking like so:
Operation # Complete Expected Hours Actual Hours
Mill 1 80 1.7
Mill 2 400 3.6
Select 22
the following sheets will be trackers for the different items. First sheet being basket with dates across the top. the other sheets the same for each item. ie:
12/13/2005 12/14/2005 12/15/2005
Footage 102.5 100 60 50
Run Time 5.4 5.6 5.2 5
Down time 3.6 2.5 5.3 2.3
Now the problem. I would like to retain the date from one day to the next. Enter data on the main page then have it flow to its individual sheets and be retained for data analysis. Anyone help with htis. I know it is a crude example, but people on here work wonders with this. Thank you
Operation # Complete Expected Hours Actual Hours
Mill 1 80 1.7
Mill 2 400 3.6
Select 22
the following sheets will be trackers for the different items. First sheet being basket with dates across the top. the other sheets the same for each item. ie:
12/13/2005 12/14/2005 12/15/2005
Footage 102.5 100 60 50
Run Time 5.4 5.6 5.2 5
Down time 3.6 2.5 5.3 2.3
Now the problem. I would like to retain the date from one day to the next. Enter data on the main page then have it flow to its individual sheets and be retained for data analysis. Anyone help with htis. I know it is a crude example, but people on here work wonders with this. Thank you