Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Please help...display image if xx
Basically, I need help coming up with some sort of a formula that will pull information from one worksheet (showing the yield strategy over a one year time span) and displaying it on another (easily done? yeah, but) - the catch (what I cant seem to figure out) is that I'd like the "yield matrix" worksheet to convert the information from the "data" worksheet into images - so instead of the 1st week in August showing HH, HH, HH, HH, HH, LD, and LD under the 1st - 7th it would show each "HH" or "LD" as an image under the respective date - there are 10 yield strategies, all different. I've attached the document to give you a better idea (I've only c&p'd the images there already) I also hage JPEG's of the images displayed on the worksheet. Does that all make sense? Hope so! I can do it all manually - copy and paste the images under the respective dates, however, there must be an easier way to do it -rather than copying and pasting 300 odd images (each the size of the corresponding cell, so not large, but still - seems like a lot of wasted time and effort)...especially as the report needs to be amended each week. Thanks, Borimard +-------------------------------------------------------------------+ |Filename: Yield Matrix v2.zip | |Download: http://www.excelforum.com/attachment.php?postid=3768 | +-------------------------------------------------------------------+ -- Borimard ------------------------------------------------------------------------ Borimard's Profile: http://www.excelforum.com/member.php...o&userid=26792 View this thread: http://www.excelforum.com/showthread...hreadid=400705 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
Any way to keep an image if publish Excel interactively to web? | Excel Discussion (Misc queries) | |||
How do i make my picture size display in inches rather than cms? | New Users to Excel | |||
Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |