CODEWITHSUNDEEP
excelvba
blazing
blazing

Reputation: 577

How to auto update one worksheet from another?

How do I update one worksheet from another?

Let's say I have Sheet1 and Sheet2. Whatever cell I type in Sheet 1 automatically updates that specific cell in Sheet2.

Upvotes: 0

Views: 98

Answers (1)

Vityata
Vityata

Reputation: 43595

In the worksheet that you write, in VBA,

enter image description here

create Worksheet_Change event like this:

Private Sub Worksheet_Change(ByVal Target As Range)        
    Worksheets(2).Range(Target.Address) = Target        
End Sub

Anything you write on the first worksheet would be present on the second one.

Upvotes: 1

Related Questions