Ive got a work book with 6 sheets of data in it. Ive worked out how to delete each page indivudally. Im trying to find out how to delete the data in all 6 sheets at once whilst still keeping the template that all the data goes into. I use the assign macro using the tools on excel.


Can anyone help or point me in the right direction?

Im new to macro's so if a explination in idiot proof mode would be greatly appriciated.