Hi Guys
I am trying to write my own spreadsheet for Timber and steel beam design. In order to keep it simple, I would like to integrate both design into one single page layout. Both Timber and Steel will share some common parameters, in which will not change. There will be an block of content contains different formula, drop down list etc. I would like to swap between the two pre-defined block of formatted text, equation, and drop-down-list based on what beam type is chosen, "Timber" or "Steel". This block of content will automatic update/swap to its associated content once the beam type is selected. This content can be prepared and stored on a different sheet, but need to be somehow swap back to the main page once beam type is selected. So this main page has a common area which is never going to change, and an area that will change once different beam type is selected.
Can anyone point me to the right direction? I know this is achievable but I don't know where to start with. The images below are the swap-able content that I have mentioned above, they need to be interchangeable. Thanks!
I am trying to write my own spreadsheet for Timber and steel beam design. In order to keep it simple, I would like to integrate both design into one single page layout. Both Timber and Steel will share some common parameters, in which will not change. There will be an block of content contains different formula, drop down list etc. I would like to swap between the two pre-defined block of formatted text, equation, and drop-down-list based on what beam type is chosen, "Timber" or "Steel". This block of content will automatic update/swap to its associated content once the beam type is selected. This content can be prepared and stored on a different sheet, but need to be somehow swap back to the main page once beam type is selected. So this main page has a common area which is never going to change, and an area that will change once different beam type is selected.
Can anyone point me to the right direction? I know this is achievable but I don't know where to start with. The images below are the swap-able content that I have mentioned above, they need to be interchangeable. Thanks!