M
meg99
I have embedded spreadsheets that produce a stoplight function for
project status - Red, Yellow, Green
Each spreadsheet is identified with a project name.
I have an intro slide that depicts the summary of each project with
the stoplight status.
The following/supporting slides show the individual projects with its
respective stoplight spreadsheet.
What I want to do:
Link the individual spreadsheets to the spreadsheets in the summary
slide. Thus, when I change the status in the summary slide, the
corresponding spreadsheet in the individual project slide changes as
well.
In other words, I want the spreadsheets in the summary slide to
control each of the corresponding spreadsheets in the supporting
individual project slides.
example: Summary slide shows projects ABC, DEF, GHI, JLK with
corresponding RGB status.
The supporting slide for ABC shows details of the project with another
RGB status spreadsheet.
I want to enter the RGB status in the summary slide and have the
status spreadsheet in the supporting slide for project ABC to reflect
that change.
Is that possible?
regards,
meg99
project status - Red, Yellow, Green
Each spreadsheet is identified with a project name.
I have an intro slide that depicts the summary of each project with
the stoplight status.
The following/supporting slides show the individual projects with its
respective stoplight spreadsheet.
What I want to do:
Link the individual spreadsheets to the spreadsheets in the summary
slide. Thus, when I change the status in the summary slide, the
corresponding spreadsheet in the individual project slide changes as
well.
In other words, I want the spreadsheets in the summary slide to
control each of the corresponding spreadsheets in the supporting
individual project slides.
example: Summary slide shows projects ABC, DEF, GHI, JLK with
corresponding RGB status.
The supporting slide for ABC shows details of the project with another
RGB status spreadsheet.
I want to enter the RGB status in the summary slide and have the
status spreadsheet in the supporting slide for project ABC to reflect
that change.
Is that possible?
regards,
meg99