Hi, I have a workbook with 2 sheets: "input" and "placeholders". On open workbook, the "input" sheet was populated some values from "placeholders" sheet column A. Then if I press Ctrl+Alt+F9 keys, those cells in sheet "input" will be populated with another values from "placeholders" column B.
I just wonder how to create a workbook like that.
Hi Quynh,
First, you will have to follow the cross posting rules, it's not fair to post the same question on multiple sites on web without posting links to all your other posts. cross posting
Please update all your posts to include links to the topics you have started on other sites.
I think it’s just a workaround.
If you go to placeholders sheet cell B12 and put there the formula: ="{"&A12&"}", this value will show up in the other sheet. Turning workbook calculation to manual will allow you to change the value in placeholders B12, while the input cell D6 will still show the previous value.
Problem is that I don’t really see any scenario where this will be useful, using notes, comments or defined names is permanent, not volatile.
