Hello,

I have two worksheets. I'm wondering if there's a way to create a mirror image of sheet 1 onto sheet 2. I want this so that I don't have to retype or copy & paste everything I enter into sheet 1 onto sheet 2. Some of the values on sheet 1 is calculated using a formula. When I change the data that goes into the formula, the value changes (as expected). I would like for the new value to be automatically reflected on sheet 2. Creating a mirror image would make it so that I don't have to do ANY work on sheet 2 at all.

Thanks