hi
thats exactly what i wanted thanks if i add more rows i wanted it to update and when i enter in textbox st number to incorporate the new rows , i kept having to format if i entered more
many thanks colin