Hi Erin, I only just sorted that bit thanks for replying again, The code
works brilliantly !!

If you don't mind can i ask a few other questions...

If i wanted to select a specific range of cells would i just changed
the ("A1") bit to show the range?

and

If I wanted to add another column to the summary sheet to calulate the
time worked, can this be added to the code? I already have the code i
need for this purpose which is

=ROUNDUP((E3-D3)*48,0)/2

Please ignore the cell references in this bit as its currently used on
another workbook only

I hope you don'y mind me asking

Kind regards

Paul


--
Paul Cooke
------------------------------------------------------------------------
Paul Cooke's Profile: http://www.excelforum.com/member.php...o&userid=29268
View this thread: http://www.excelforum.com/showthread...hreadid=491675