Create a bill with macro

Hi All,

I'm really bad with all VBA stuff, hope you can help me. I'm trying to get a macro to Build an automatically bill.

My data comes from a Summary table where I have an Address and an Amount from each store. This count of stores are dinamyc, so, some months I have information from 3 stores and some times information for 40 stores.

What I want to do is when I run a macro.. this should be create a new sheet with the information for the first store. Then create another sheet with the information for the second store and continue with the same process until the last address.

This sheet should be created with the Address of the Store. I have like a template where should be updated with this values in the summary tab.

Here is a link for an example... A "Summary" sheet where I saved the information and in RED the sheets that should be created by the macro.

https://dl.dropboxusercontent.com/u/...l_Summary.xlsx

Do you any idea? This is possible?

Thank you!

Bill_Summary.xlsm

Let me know if this is close to what you want, of course it could look better if you let me know what else needs to be added where the XXXXXX are, if there needs to be a company header or other information or formatting, just push the button and an invoice for each of the addresses (Dynamic so you can add or subtract) will be created (with out the yellow highlighting and the XXXXXX)

Hi Scott!

that's awesome! Thats the idea that I want... ... Below its a more real case, you can see a text instead of XXXXXX; that text are in spanish hehe. In BOLD are the parameters that should be replaced with the data on the summary tab.
You can see some blanks cells, this is because we print this bill on a paper that have some layout.

https://dl.dropboxusercontent.com/u/...78/Sample.xlsx

Really thanks to take on this.. ...

Scott really thanks I understand now how generated the sheets with the other information. I only get an error when I leave only 3 of the Address ... Its look like it is missing the last row.

mmmm not sure how fix that :S