No - won't work as the spreadsheet I am populating is a template required for
all sites across the group but we are new to the group.

Thanks for the idea though.

Nigel

"gjcase" wrote:


How about a pivot table with Date on the left & WO/Craftcode underneath
it, and Sum of hours in the field? Alternatively, if you are doing one
week at a time, WO on the left, Date across the top, and Sum of Hours
in the data field.

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=529658