How can you have data automatically populate btw workbooks  
Author Message
lluscious





PostPosted: Fri Dec 02 11:30:15 CST 2005 Top

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.

Excel329  
 
 
Dnereb





PostPosted: Fri Dec 02 11:30:15 CST 2005 Top

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

--
Dnere

-----------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2618
View this thread: http://www.excelforum.com/showthread.php?threadid=49022

 
 
WilliamHorton





PostPosted: Fri Dec 02 13:04:02 CST 2005 Top

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.