How can I get info from 2 different workbooks to show up in a 3rd book as it
is input? I have to transfer info from severl books into one to reconcile
them on a regular basis. I need the master to update automatically when the
original is changed. Sharing is not an obtion.

If all of the workbooks were on the same mainframe it could be done with
links. However, I would guess they are on an intranet since you don't want
to use sharing. There is no easy way to do it. With some
BeforeWorkbookClose code or Worksheet-Change code, it might be possible to
generate an automatic email, but the actual update would have to be done
manually. Maybe someone more knowledgeable than me can offer a better
solution.

"GARDNERGUY" wrote:

> How can I get info from 2 different workbooks to show up in a 3rd book as it
> is input? I have to transfer info from severl books into one to reconcile
> them on a regular basis. I need the master to update automatically when the
> original is changed. Sharing is not an obtion.