duplicating data

[Lynn]

I have 2 excel worksheets, both are in different formats. Both will
contain the same data but spread across different parts of the
worksheets.

if I have filled in the data for 1 worksheet, how can i automate this
data to be filled into the other worksheet?

 

[Gord Dibben]

In Sheet2 use linking formulas.

Sheet2 H1 formula is =Sheet1!A1

For contiguous areas these can be copied by dragging.

For non-contiguous areas..........manually enter references.


Gord Dibben MS Excel MVP