mACRO

[EwatchesUSA]

I have a workbook with 10 different worksheets and they all share data, I need to create a macro so when we add data to the first worksheet it will update the rest of the worksheets automatically, right we have to hit refresh every time we add new data, please advise.

Regards Mike

 

[diddi]

you can use the Worksheet_change () event on the sheet that receives the update. there are heaps of examples here

 

[jim may]

Maybe...

Workbook.SheetCalculate Event

Example


This example sorts the range A1:A100 on worksheet one when any sheet in the workbook is calculated.

Visual Basic for Applications

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
    With Worksheets(1)
        .Range("a1:a100").Sort Key1:=.Range("a1")
    End With
End Sub