-
Change event code to copy range from two sheets to different ranges in Master sheet
Hello:
I am new and looking for a code that will automatically update My "Master" sheet when Reference sheets have changed.
My master sheet has added columns that differ from my reference sheets and feel this might be an issue.
I tried putting code into two reference sheets "Tracker" and "Archive" sheets and have no luck.
PrivateSub Worksheet_Change(ByVal Target As Range)
IfIntersect(Target, Me.Range("a:z")) Is Nothing Then Exit Sub
Application.EnableEvents= False
Call Master
Application.EnableEvents= True
EndSub
Is there a code that will allow data to auto populate when columns from one sheet to another have changed?
Basically, I am looking for a live update to my master sheet when new data is entered from the other two reference sheets without use of a button.
Any help would be appreciated. Attached is a sample sheet.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules