find changes in a cell range, copy changes to another workbook

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.offset(0,-1).Value)

or make it a string

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


--
Regards,
Tom Ogilvy


"Susanne" <[email protected]> wrote in message
news:[email protected]...
> 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.
>