Event handler or a macro

Hi ,

I have a workbook which gets data in several ranges on sheet1
Like:
A2:A10 (Time stamp); B2:B10 (temprature values) and so on.
I like to copy data and insert in sheet2(transposed) as and when the value in any of he cells in the range changes. This has to be something ongoing.
Please help me.

Apprecaite your help
Thank you
Jaz

Appreciate your help.

Thanks
Jaz

Depending on how the cells are populate you should be able to use the Change event of the sheet.

Would you copy over the whole range if any cell changes or just the changed cell?

Thannk you Andy for your time.
yes I would copy the whole range.
I did use change event of worksheet, it works, but I am unable make it:
transpose and also inseret at the same time. I am not aware of the syntax to put both of these actions together.
I would like it to go to the lastrow and transpose while inserting the copied range.
Appreciate your help.
Tahnks
Jaz

Andy,
I got it working!

Thank you
Jaz

Roy,
I am sorry for not posting the code I managed to make it work.
Actually it was a very silly thing.
I used the following to capture the change in the range

If Not Intersect(Target, Range("A2:A10")) Is Nothing Then
which was not a biggie. But here was the problem:

HTML Code: 

I was ignoring that underscore which validates the continuation to next line.

Thank you
Jaz