I am building a spreadsheet. In Col A I have stock symbols. In Cols B, C, D etc..I want the Last, Change, Prv Cls etc...This is a DDE link with RediPlus. Now here's the question. Is there a way to write the formula (see below) so that where "SYM" appears It will automatically populate with the corresponding symbol? I want to be able to drag and copy the formula instead of having to write the formula for each symbol on each cell. So when I drag the formula the symbol in A1 gets copied into the B1 and symbol in A2 gets copied into formual in B2 and so on. Here's is an example of the formula. This one is for last price. =RediLINK|'L1'!'SYM;LP' This example is for last price in Col B.