Jump to content


Excel assistance


  • You cannot reply to this topic
No replies to this topic

#1 Borimard

    Young Padawan

  • Members
  • Pip
  • 1 posts
  • Location:London

Posted 30 August 2005 - 07:19 AM

Hey there,

I need help with M. Excel and I'm hoping someone'll help me out!!

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 "printable" 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 8 yield strategies, all different.

Does that all make sense? Hope so!

Look forward to hearing from you all, hopefully, with some interesting input on how I can get around this issue. 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)...

Thanks

Edited by Borimard, 30 August 2005 - 08:45 AM.






1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users