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.

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.