Thread: How can you have data automatically populate btw workbooks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dnereb
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote