Hi,
Attached is my solution. In each worksheet in column AA I
have totalled the usage for each part for the given Start and End
dates. The Start and End dates are now named ranges.

In the summary sheet, I total the columns AA from each sheet for each
part.

The part number data validation is now a named range called Items.

Hopefully you can now customise this to your needs.


+-------------------------------------------------------------------+
|Filename: Copy of Testing.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5127 |
+-------------------------------------------------------------------+

--
Toppers
------------------------------------------------------------------------
Toppers's Profile: http://www.excelforum.com/member.php...o&userid=30076
View this thread: http://www.excelforum.com/showthread...hreadid=564594