creating dynamic mirrored worksheets

J

Johnny Eager

I have project where I import (via Word Automation) text content into a
Excel template. All text, no calculations.

I want to have a second worksheet which mirrors certain columns from sheet
1. Here is the problem.

How can I have both worksheets dynamic at the same time?

If I enter data in worksheet one, I want the data to appear in the same cell
row (like-named column). This I can do.

But what want is to have worksheet 2 also dynamic so when I enter data into
a row, it appears in the like-named column on worksheet 1.

In other words, I want to be able to enter data in either sheet, and the
results are the same in both.

thanks for the help.

JE
 
D

Dave Peterson

See one reply to your other post.

Johnny said:
I have project where I import (via Word Automation) text content into a
Excel template. All text, no calculations.

I want to have a second worksheet which mirrors certain columns from sheet
1. Here is the problem.

How can I have both worksheets dynamic at the same time?

If I enter data in worksheet one, I want the data to appear in the same cell
row (like-named column). This I can do.

But what want is to have worksheet 2 also dynamic so when I enter data into
a row, it appears in the like-named column on worksheet 1.

In other words, I want to be able to enter data in either sheet, and the
results are the same in both.

thanks for the help.

JE
Click to expand...
 
Top