Hi Bernie,
Thanks for your reply, just got the books out to see what you have
done. It works for the first row but not after that. The results need
to be put into 7 columns say I to O and for 8 rows (I10:O17) with each
row having a seperate event type and number of events per day. The
results being the last 7 digits in the origional post (columns I-O).

Thanks again, if you have any other suggestions please let me know.

Regards
stge


--
stge
------------------------------------------------------------------------
stge's Profile: http://www.excelforum.com/member.php...o&userid=16068
View this thread: http://www.excelforum.com/showthread...hreadid=275223