B
bluegrassstateworker
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?
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?