Good day to all,

Sheet1: Column A is the date (from Jan 1, 2005 to the current date),
Col B contains the hours worked on that date and Col C is hours worked
for the last 12 days.

I manually type in the hours worked everyday on Col B and there is a
formula on Col C to add the last 12 days. There's about 45 units that I
keep track of the hours worked.

How can I show on a summary sheet, the hours worked of each unit as of
yesterday? My problem is that the cell that totals the last 12 days
moves down one cell everyday.


--
ledzepe
------------------------------------------------------------------------
ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
View this thread: http://www.excelforum.com/showthread...hreadid=495556