Hi ARowbot

i was just playing around with your formula which is great by the way and works perfectly

But i noticed if i add another school/client after i have saved and closed it then run the macro again it fails because it starts from the beginning again would i need to write a different macro that does what the other one does but doesn't try to duplicate the originals

and i notice aswell with it if i change a price in the file then try to run again to update it does the same as above is there a way round this??

cheers