duplicating data

  • Thread starter Thread starter Lynn
  • Start date Start date
L

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?
 
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
 
Back
Top