Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
modify the data in a report
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
modify the data in a report
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Help...Need to modify data within a column in a .csv file | Excel Worksheet Functions | |||
=(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response | Excel Discussion (Misc queries) | |||
Help for modify data in excel! | Excel Programming |