hi, i'm new to the forums...

not sure if this is the right group, but here goes...

i have a worksheet within excel 2003 where cells contain dde hotlinks to a dde server...

seems to work ok...

what i'd like to do is have column A as one source with mutiple cells (each one a source) and column B as another source....

and then via either a change trigger or timed update map data from column A to column B... like sort of a data exchange....

i realise that to update the dde server (rather than just read) will require a ddepooke or something... is that right?

ideally, i'm thing a timed script that cross maps Ax to Bx for as many entties exist on a sequential loop?

assuming this can be done... moving on a level, instead of the sync being in a single direction... could it be done that a sync is done in both directions, depending on which entity changed? if not, i could probably live with the unidirectional sync...

i know a bit of vbscript if that helps... but have never delved into excel in that regard before..

thanks a lot

Neil