I have updated the attachement and given 2 examples of what I am trying
to acheive. Please take a look and let me know if more info is needed.

thanks
Brent


+-------------------------------------------------------------------+
|Filename: shift query.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4913 |
+-------------------------------------------------------------------+

--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=553789