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

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

=IF(Sheet1!A10,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!A10,D1/Sheet1!A1,"")

or maybe I didn't understand your problem?
--
Cheers
Nigel



"Ouka" wrote in message
...

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