PDA

View Full Version : Change event code to copy range from two sheets to different ranges in Master sheet



Simple_Man
08-25-2016, 02:26 PM
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.