Where are units identified, and does this mean that you might work on
multiple units on the same day, that is multiple rows for a date?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ledzepe" wrote in
message ...

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