it worked a treat your a super star, quick question though think im doing something wrong in another area if you look at sheet1 (2) - T1 i get 141 in total purchase orders and in sheet graph data J11 i get 142 in total . i cant believe how quick you did that, if only i had this knowledge