Data Tracking in same workbook

D

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?
 
D

Del Cotter

Del Cotter said:
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?
Click to expand...

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.
 
Top