The Template Wizard with Data Tracking add-in will do this nicely.

What version of Excel do you have?


Gord Dibben MS Excel MVP


On Mon, 8 Oct 2007 20:43:00 -0700, SEAN wrote:

So here is what I want to do: I have an excel document designed to be a
workorder template, I want to fill information out in this template and have
certain feilds transfered to a seperate workbook (basically a register). This
part is no problem, however I want to close and reuse the template again and
each time have the information from the workorder sent to the ``register`` on
successive rows (1,2,3...) everytime.

Is this possible,
and if so how can it be accomplished...
lastly can a control button be used to export the data to the register...

thanks for the help