modify the data in a report

[Guest]

a worksheet AAA contains the following formula in cell n7
=((($O$6*$O$7)-(SUMIF($C$4:$N$4,"Actual",$C$8:$N$8)))/($O$6-(SUMIF($C$4:$N$4,"Actual",$C$6:$N$6))))
, o6 and o7 contain numbers, c8 to n8 contain numbers, c6 to n6 are also
numbers.n8 is n6*n7. n10 is n11/n8, n8 is an interger. n13 = n14/n8 n14 is an
integer. n16= n17/n8 n17 is an integer. n19= n20/n8 n20 is an interger. O10
to O20 contain percentage numbers.
I wrote a macro that adds a new sheet to workbook and pulls the formulas
from n7,n10,n13,n16,and n19 in sheet AAA and the percentages from the O
column to a new sheet let me call it CCC .
the n formulas are actual the O percentages are wishful percentage numbers
my manager wants the ability to change the percentages numbers the O column
numbers on CCC report which would change the actual numbers the N actual
formulas on CCC without going back to sheet AAA.
if I go back to sheet AAA and change a wishful percentage at any O cell then
the whole table changes and another macro could be run to generate a new
report but he wants the ability to execute the changes at the CCC sheet.
could this be done. if you need any additional info please let me know. thank
you

 

[OJ]

Hi,
rather than describe your specific workbook why don't you try to
generalize your question? It sounds to me that you want a
worksheet_change event on sheet CCC that says something like this....

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 15 And Target.Row > 9 And Target.Row < 21 Then
Me.Range("$O$10:$O$20").Copy Sheet1.Range("$O$10:$O$20")
End If
End Sub

Hth,
O