Have you tried the Template Wizard with Data Tracking?

Writes each newly created workbook record to a data.xls workbook.


Gord Dibben MS Excel MVP

On Wed, 2 Jan 2008 07:19:01 -0800, gary wrote:

i have created a sheet in Excel that will be used by sales reps to enter in a
few items which they can get from drop down boxes. the problem i am having
is, this will be the only sheet for them to use, and we are asking them to
'save as" and then when complete, to re-use the same sheet for the next phone
activity. i need to creat a second tab that will keep a running list of what
was entered into the static tab as soon as they save it. how do i do this?