Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update on Worksheet_change with data from other sheets?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I update links from .xls sheets to .xlms sheets | Excel Worksheet Functions | |||
How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
Combine 2 sheets into 1 that will update w/new data | Excel Worksheet Functions | |||
Creating an "update" button and using a macro to copy data from multiple sheets | Excel Programming | |||
Can an add-in macro update a worksheets Worksheet_Change function? | Excel Programming |