I have two spreadsheets that I need to share information but I cannot
consolodate them into one since a different department is requiring
one in its original state.  There are common fields such as
justification text, name, date, etc... that I would like to have
placed automatically into defined cells of the embedded spreadsheet.
  Spreadsheet A would have SpreadsheetB embedded as an object.  If a
user inputs a value into a cell (on A), I would like that value to
automatically be input into a cell on B.  Can this automatic "push" be
done since the embedded spreadsheet B is not open?  My thought is that
I would have to open B then have it pull those values from A before
this might work.  Does anyone have any experience with issues trying
to do this or any pitfalls to avoid?