Or you could just "Save As" the workbook and give it another name. Or if you
want to keep a database of all the entries you make in another workbook use
the template wizard with data tracking (tools / addin's).

"kzparham" wrote:

I am working btw two workbooks and would like the data I enter in one to
automatically populate the second. For example, as I add new entries, I
would like that new entry to populate on the second workbook (separate file)
as a new entry as well.