How can you have data automatically populate btw workbooks

[Guest]

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.

 

[Dnereb]

You could use the on_change event of the first workbook
to fill the cells off workbooks(2).cells(Target)
with the same value

You need to do some error checking if you want to do this.
How is your VBA skill

 

[Guest]

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