This macro must be in the module belonging to the worksheet you are
filling. Right-click on the tab of the worksheet and select <View
Code. Now the VBA editor opens in the module belonging to this
worksheet. If you insert your Worksheet_Change routine here it will
work.


DTM wrote:
Any help with this problem greatly appreciated, I am feeding live data
into cells and wrote a quick macro triggered to run when values in cell
change

Private Sub Worksheet_Change(ByVal Target As Range)

However changes in data values in cells do not seem to cause following
macro to run.
Can anyone think of a solution?