"=abDDE|BAR!'" & A1 & ";LEVEL'"
where A1 contains a symbol. For example if cell A1 contains the value "ART" then I need something that results in the creation of a working DDE link:
Is this possible? I've got to do 40-50 of these on a daily basis and I'm pulling my hair out trying to automate this.
I'm not sure I understand, but here goes nothing.
Is this what your looking for
=abDDE|BAR!' & if(A1="ART","ART","") & ";LEVEL'"
My problem is that, as far as I can tell, this formula requires one to manually enter the symbol (in this case ART) for the feed to work. So simple concatenation doesn't work unfortunately (thanks for the attempt thought Jerid).
What I'm looking for I think is a work around that will generate a working DDE formula as above for a Symbol several columns to the left.
I am attempting to automate a worksheet which tracks data on approximately 40-50 such symbols at a time. I would like to make it as idiot-proof as possible so that anyone in my office can sitdown and type a series of symbols in a given column and get a live feed for each of these symbols without having to type in or worry about the DDE formula.
Whew... It's a lot less complicated than it sounds, and I have a feeling there's a simple solution.
Does anybody have familiarity with these DDE formulas?
Thanks for your help,