Opening Excel in 3 instances

[ephillips]

I view 1000's of numbers each day on 3 monitors each of which is a custom database tied into a custom database. The key field for each is a product # like '12094'.

It would save so much time daily if I entered '12094' in one cell of the 1st instance of the database and it appeared in the other two updating that screen accorded to that database.

Is something like that even possible? .... Thanks, Edward

 

[Roderick_E]

Can one be the master? And are you only adding new unique entries or are you going to be updating existing entries?
Either way, you should probably use -- on the master -- something like:

Private Sub Worksheet_Change(ByVal Target As Range)
on error resume next 'will not update if entry not found on 2nd or 3rd sheet
row2nd = application.match(target,sheet2.range("E:E"),0) 'change E to the actual range where  the product number appears on the 2nd sheet
row3rd = application.match(target,sheet3.range("E:E"),0) 'change E to the actual range where  the product number appears on the 2nd sheet
resume next
End Sub

 

[ephillips]

Thank You .... I'm ok with Excel but become lost with VBA code. But what I take from this is that it is possible. With that knowledge and the directions you provided above I will dig in and see if I can master this.

.... Thank You Very Much