Is there a reason you've broken the date into two columns, i.e., month across the top and day down the left? Why not have the entire date in one cell, which can be formatted as a date type cell? That way you could use one column/row for the entire date value and then use the second column/row for all your parameters on one sheet, vice having a separate sheet for each parameter. Then you can work on a separate sheet to consolidate the info using the value lookup function recommended by the other dudes/dudettes.
|