I want to be able to do this in a macro so that it is
invisible to the user. User enters 3 pieces of
data in a new column each week:

wk 1 wk 2 wk 3 ......
OT hours
Repair hours
Cost

I want to be able to sum wk 1 (OT hours + Repair
hours) and then wk 2 (OT hours + Repair
hours) and find the MAX for all weeks input
but I do not want to add another row of data to the
spreadsheet. I want this to be invisible
to the user. Can someone help me achieve this?