Finally worked it all out after trial and error, based on what markee said, I was on the path to want I wanted and managed to get the right one (see the attachment). Man Excel (and Office) 2007 is a pain in the prosteria
Thanks for all the help and Ideas guys!