Thank you for your help although its not quite what I had in mind. Let me give you what I've got working for me so far:
This is code I have for Sheet1 that is working its way over to Sheet2.
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Cell As Range
Dim isect As Range
Dim FORM_LIST As Range
Dim MASTER_LIST As Range
Set FORM_LIST = Worksheets("Sheet1").Range("FORM_LIST")
Set MASTER_LIST = Worksheets("Sheet2").Range("MASTER_LIST")
Set isect = Intersect(Target, FORM_LIST)
If Not Intersect(Target, FORM_LIST) Is Nothing Then
For Each Cell In isect
MASTER_LIST.Value = FORM_LIST.Value
Next
End If
End Sub
Now when I tried to write the same code in Sheet2 I got errors.
So I hope I gave you a little better idea now of what I'm trying to do. I just want the two lists linked where I can make a change on either one.
Bookmarks