Data Tracking in same workbook

[Del Cotter]

Hi

I've been using the Template Wizard to create data input forms in one
workbook with the data tracked in another Excel workbook. Now I need to
have the data input form and the tracking database be different
worksheets in the same workbook.

Is there a way to do this?

 

[Del Cotter]

Hi

I've been using the Template Wizard to create data input forms in one
workbook with the data tracked in another Excel workbook. Now I need
to have the data input form and the tracking database be different
worksheets in the same workbook.

Is there a way to do this?

Okay, all fixed now. I created the template and the database, then
opened a new file using the template, then copied the sheet into the
database and saved it again. Now the workbook logs changes made to the
form in the same workbook, which I can save on a LAN or send as an
attachment in email and not worry where the user is.