Update on Worksheet_change with data from other sheets?

[Ouka]

Hi all, another question..

Here's my scenario:

I have a series of data eneterd onto one sheet of my workbook

What i need to happen is when cells in another worksheet are updated,
access the 1st workbook's cooresponding cells and update cells adjacent
to them.

It's like this:

Worksheet("1").Range("A1:A10") has data in it.

As data is entered into Worksheet("2").Range("D110") I need _
worksheet("2").Range("E1:E10") updated with a calculation involving
_
worksheet("1").Range("A1:A10") and worksheet("2").Range(D110")

Specifically, when worksheet2.D1 is updated, I need to divide that
value by the value in worksheet1.A1 and put the result in
worksheet2.E1, and so on down to N10

I can't just use a formula on row E because sheet2 and on are created
dynamically by the user based on input on sheet1, and leaving a raw
formula on the column results in a div 0 error on empty cells, which
screws up another trigger that I have to format the column E cell on
certain values...

?_?

 

[Nigel]

I do not see why you cannot use a conditional formula such as the
following....

=IF(Sheet1!A1>0,D1/Sheet1!A1,0)

it avoids the division by zero issue, if you wanted cells E1 (etc) to be
blank instead of a zero use ....

=IF(Sheet1!A1>0,D1/Sheet1!A1,"")

or maybe I didn't understand your problem?