Hello All,
I’m creating an Decision Tree. (see attached example)
I made some progress but now I’m stuck.
When I select a data calcification in Cell B5 (as confidential or restricted) it is grabbing information from the Sheet “Requirements” and filling this information in cell D5 and D6.
The information form Cell D6 comes from “Requirements” Cell B24
I would like to copy the information (including the Source format and color(s)) to Cell D6 on the “SaaS Questions” TAB.
I can’t get it to work.
The second with I have is that the Cell D6 keeps following the selection I made in B5.
(When I hard copy the cell from “Requirements” B24 to “SaaS Questions” D6 , It will not change anymore when the selection is changed in cell B5 “SaaS Questions”
So I’m looking for a VBA or a triggered Marco to keep playing with the selections in Column B but use the information from the “Requirements” tab Incl the formatting of the refence cell
Emoes
Bookmarks