thanks, worked great, was able to aply it to a if function and some sum
functions as well for some custom work sheets of my own

oops that was a typo on my part it is 13 periods not 14...

lol boss face was great when she went in there and found 90% of her
spreadsheet automated. Also got me a small raise


--
elitewolverine
------------------------------------------------------------------------
elitewolverine's Profile: http://www.excelforum.com/member.php...o&userid=27893
View this thread: http://www.excelforum.com/showthread...hreadid=474031