Hi,
I would like the functionality of being able to choose a sheet from a drop down list and have the camera tool display an image from that corresponding sheet. I have tried using the indirect function, but it just isn't cooperating.
I've included an example. To achieve what I am seeking, on sheet4, the selection in d2 would determine which sheet the image below is generated from.
Any help would be appreciated!
Thanks,
Bookmarks