"carl" wrote in message
...

I have a spread sheet that looks like so before the start
of the trading day:

ColA ColB ColC
ABC 4/7/2005

ColB tracks the trade time of stock ABC - it comes from a live data
feed.

When ABC does it's first trade, the spreadsheet looks
like so - and continues to change as subsequent trades occur.

ColA ColB ColC
ABC 9:32:28AM

Is there a macro that will record the time of the first trade and place
it in ColC ??


Thank you in advance.

I would use the Worksheet_Change event and place a timestamp in Col C, same
row, whenever a new value has been entered in Column B. What about the
subsequent trades? You could check if the appropriate cell in col C is empty
if you want to track the first trade only.

I'm not sure this event would work as expected in this scenario. Can you
please describe the live data feed.

/Fredrik