Hello, I'm totally new to all of the in depth excel stuff but i think this may have something to do with this sub category.

I'd like to if possible make an invoice template in a workbook and have a button that's in another workbook that would open up a copy of the template and let me edit details then save the edited template to a location and leave the original blank template unedited so i can then use the button to open that up again for a 2nd invoice to be edited.

I'm also thinking about adding drop down box that when i choose a customer it will auto fill the customers details if that's possible?

Thanks in advance for your help.