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("D1:D10") I need _
worksheet("2").Range("E1:E10") updated with a calculation involving _
worksheet("1").Range("A1:A10") and worksheet("2").Range(D1:D10")

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?
--
Cheers
Nigel



"Ouka" <[email protected]> wrote in message
news:[email protected]...
>
> 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("D1:D10") I need _
> worksheet("2").Range("E1:E10") updated with a calculation involving
> _
> worksheet("1").Range("A1:A10") and worksheet("2").Range(D1:D10")
>
> 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...
>
> ?_?
>
>
> --
> Ouka
> ------------------------------------------------------------------------
> Ouka's Profile:
http://www.excelforum.com/member.php...o&userid=23988
> View this thread: http://www.excelforum.com/showthread...hreadid=380272
>