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.

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

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.