Home

Dynamic images

%3CLINGO-SUB%20id%3D%22lingo-sub-719421%22%20slang%3D%22en-US%22%3EDynamic%20images%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719421%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EStep%201%20...%20I%20have%20placed%20a%20list%20of%20images%20in%20Worksheet%201%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EStep%202%20...%20I%20return%20a%20value%20in%20a%20cell%20within%20Worksheet%202%20to%20return%20a%20corresponding%20image%20from%20Worksheet%201%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EStep%203%20...%20I%20now%20want%20to%20create%20additional%20Worksheets%20(e.g.%203%20to%2010)%20which%20also%20return%20images%20from%20the%20original%20list%20in%20Worksheet%201%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EBUT%20the%20challenge%20is%20to%20avoid%20using%20Name%20Manager%20as%20this%20would%20require%20me%20to%20create%20a%20new%20one%20for%20every%20new%20worksheet%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EKind%20regards%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-719421%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-719639%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamic%20images%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719639%22%20slang%3D%22en-US%22%3EI'm%20afraid%20the%20trick%20using%20a%20named%20formula%20requires%20a%20separate%20name%20for%20each%20dynamic%20picture.%3C%2FLINGO-BODY%3E
Bigfish69
Occasional Visitor
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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies