worksheet functions >> How can you have data automatically populate btw workbooks
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.
worksheet functions >> How can you have data automatically populate btw workbooks
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
worksheet functions >> How can you have data automatically populate btw workbooks
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).
> 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.