Dynamic images

Copper Contributor
Step 1 ... I have placed a list of images in Worksheet 1
Step 2 ... I return a value in a cell within Worksheet 2 to return a corresponding image from Worksheet 1
Step 3 ... I now want to create additional Worksheets (e.g. 3 to 10) which also return images from the original list in Worksheet 1
BUT the challenge is to avoid using Name Manager as this would require me to create a new one for every new worksheet
Kind regards
1 Reply
I'm afraid the trick using a named formula requires a separate name for each dynamic picture.