I am trying ot set up a WIP along with a time line.
We would like to have ability to print as with a WIP or a time line. Is there a way of having a sheet which is the master sheet where we input bot WIP and timeline (which correlates with the WIP) and then have 2 other sheets – one for just WIP (ie first 6 columns) and second fr time line (ie column A plus columns F-Z).
I have tried the =’MASTER’!A1but when a new row is added to the ‘MASTER’ sheet it is not replicated in the second sheet.
Is it possible to have the sheets set up so they automatic update from the MASTER (data and formatting ie colour)?
(sounds too good but thought would ask) L