Recording data in Excel - a question

[sagar]

Hi folk, is there a way to record the last prices in an Excel spreadsheet with multiple markets and every time the value changes copy it in the same row but in next available column? In other words, if a price in O5 changes it will be copied in AA5, if it changes again the new price will go in AB5 (while keeping the previous in AA5) and so on. The same should happen if a value changes in, for instance, O20 (which will be copied in AB20, AC20, AD20 etcetera). Theoretically it’d be great if I could monitor the whole O:O column.
Is that possible on VBA?

Many thanks in advance,
S.

[horpunt]

hi, sagar

it should be possible if you program a macro , although this would take a little bit of work to do, i have somthing similar that i use in my workbook.

cheers

[joe lively]

Have a look at this thread:

http://gruss-software.co.uk/forum/viewtopic.php?t=4035&highlight=recording+odds

It doesn't do exactly what you need but I think you would find it useful.

[/url]