See Chip Pearson's page on Events
http://www.cpearson.com/Excel/Events.htm

you would use the change event for the sheet where the changes would be
made.

You can translate a month into an index

Dim sh as Worksheet
set sh = Workbooks("Other.xls").Worksheets(month(target.off set(0,-1).Value)

or make it a string

sStr = format(Target.offset(0,-1).Value, "mmm")


--
Regards,
Tom Ogilvy


"Susanne" wrote in message
...
When a cell in a range is updated I want to copy the value to another
workbook in the corresponding sheet (months). Haven't used XL VBA much and
presumably need to use sheet index numbers.

Any help gratefully received.