PDA

View Full Version : Auto update data to diffrent columns VBA code needed



Simple_Man
08-25-2016, 02:16 PM
Hello Experts:

I am a newbie and trying to figure out the basics to VBA. I am currently working a workbook to run reports. I have Six sheets. I am trying to combine two sheets into a master sheet with different Ranges and have my Master sheet automatically update without use of a button when new data is submitted. My two reference sheets "Tracker" and "Archive" has headings an columns a:u

My master sheet has headings and columns A:Z. I inserted columns to run pivots and charts.

I am looking for a change of event code that will copy data from my reference sheets "Tracker" and "Archive" to the correct corresponding cells in my "Master sheet"

Please help if possible. I have attached a copy of a sample workbook to show what My master looks like and how it differs from reference sheets.