Efficiently Creating Multiple Versions of a Template

[Steve0492]

Hello,

Here is my issue. I have 50 data points in a table on tab A. In tab B, I have 50 copies of a form template that link to the data in tab A. The info on row 1 of tab A links to the first template in tab B etc. I recently messed and all my template references now have the lovel #REF! error. Do you guys know if a faster way to re-link my templates to my data set other than manually typing in the formulas 50 times? Thanks!

Steve

[Steve0492]

I attached a copy of my file. Hopefully this clarifies what I am looking for. The data is contained in the "Merge Template" worksheet and the templates on the "Void Form" worksheet. Thanks.

Steve

[Ace_XL]

use the INDIRECT formula.

You would need to define thses for one invoice and refernce them to a row number. For instance, if you input the row number in Cell A8.

Then your formula in C9 would be
=INDIRECT("'Merge Template'!C"&$A8)
In C10
=INDIRECT("'Merge Template'!J"&A8)

and so on


So for the next invoice you would input the row number (i.e. 4) in A54 and then you could copy formulas from first invoice.

Does this help?

[Steve0492]

Perfect. I was attempting to do this earlier, but was not using the INDIRECT formula. Thanks a lot Ace.

Steve