Duplicating cells on multiple worksheets in same workbook

[wnorrick]

I have an invoice set up in excel. I am going to prepare 209 of them and would like to streamline the process. I will have a list of 209 names that can be used for vlookup and i know how to do that. What i don't know how to do is take the invoice and each name and create 209 worksheets in the same workbook that have the selected cells. I will then need to use vlookup to populate the rest of the invoice. Is there a way to that? I have attached a mini sample so you can see what i am trying to do. There will be 209 instead of 5 properties. All help is appreciated. The idea is to create the master template and then going forward it would be easy to just adjust the Annual tab and you would have your current charges for budget purposed and bill backs.
Thank you,
Wanda

 

[Atlas Johnson]

Hi Wanda,
It is a really hard question. In Pivot, you can create a sheet for each item automatically, but I believe it won't be your solution. I suggest you to use Excel as your database and Word as your printing engine. So for every invoice, make an entry in excel, and have a mail merge function in Word to print those.

This is all I can think of.
Best,
AJ

 

[wnorrick]

Hi Wanda,
It is a really hard question. In Pivot, you can create a sheet for each item automatically, but I believe it won't be your solution. I suggest you to use Excel as your database and Word as your printing engine. So for every invoice, make an entry in excel, and have a mail merge function in Word to print those.

This is all I can think of.
Best,
AJ

Thank you AJ. I was hoping for some ideas on how to do at least parts of it but it is a hard question. I appreciate your response. Wanda