Hi,
I am using Excel 2010 and I am trying to mirror actions in one worksheet to another worksheet. I would like the target sheet to reflect value changes and formatting from the "master" worksheet.

Example- master sheet ranges =A1:K13 and A14:H200 are input cells and Target worksheet's same cell ranges reflect the same data as in the master.

Other notes: file was originally a downloaded gantt chart template but have saved it as 2010 macro enabled workbook.

Desired workbook use: Master sheet has project tasks, assignments, start dates and finish dates. Target worksheet will have a gantt chart with tasks, assignments, dates, etc. I would like to use Master sheet as a punch list and have other comments outside the ranges noted.

Any help would be greatly appreciated!