2-Way Cell Referencing

miles00

New Member
Joined
Oct 9, 2024
Messages
1
Office Version
  1. 2021
Platform
  1. Windows
Hello, I'm a normie that knows nothing about VBA. Was hoping someone might be able to lend a hand, and I appreciate any and all help :)

I'm trying to link multiple cells from different sheets to each other such that if I change one value on one sheet the value will change in the other referenced cell and vice versa. Here is an example of the cells I need to be linked:
Sheet1 C17 <---> Sheet3 C14
Sheet1 C7 <---> Sheet4 C14
Sheet2 D16 <---> Sheet3 D20

Is there a way to make a bunch of things structured like the following that i found on another thread (that I don't understand at all lol)?

Private Sub Workbook_SheetChange1(ByVal Sh As Object, ByVal Target As Range)
If UCase(Sh.Name) = "SHEET1" Or UCase(Sh.Name) = "SHEET2" Then
If Not Application.Intersect(Target, Range("a1")) Is Nothing Then
Application.EnableEvents = False
If UCase(Target.Parent.Name) = "SHEET1" Then
Sheet2.Range("a1") = Target
Else
Sheet1.Range("a1") = Target
End If
Application.EnableEvents = True
End If
End If
End Sub


How do I change to range to match the cells I need?
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Forum statistics

Threads
1,224,596
Messages
6,179,807
Members
452,944
Latest member
2558216095

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top