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.

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?


--
Dnereb


------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=490220

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

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