Connection of the backstage to presentation
Connection of the backstage to presentation
We said that the program will just fill in the backstage sheet. To connect the data sheet to the presentation sheet, you can use Excel features.
Imagine you want to display the drawing code. The backstage sheet shows the KB1234 value in C2 cell of the BACKSTAGE sheet.
The presentation sheet will look like this:
As you can observe, the B2 cell shows the value of cell C2 of the BACKSTAGE sheet. To achieve this, just edit the cell B2 of the presentation sheet and enter the formula:
=IF(BACKSTAGE!C2="";"";BACKSTAGE!C2)
This simple formula checks the value of cell C2 of the BACKSTAGE sheet and if not blank ( "") it fills the contents of the current cell with that of the backstage.
Knowing the syntax of the EXCEL formulas, you can perform interesting operations. For example, if you want to display the sum of the contents of a group of cells of the spreadsheet BACKSTAGE in the presentation sheet, you can use the following syntax:
=SUM(BACKSTAGE!C9:C19)/1000
This formula fills the current cell with the sum of the values of the group of cells that goes from cell C9 to C19. The value of the total sum is then divided by 1000.