Reference an entire worksheet

[DianaH]

I want to add values to one worksheet but I want them to
show up in another worksheet within the same workbook. I
can do individual cells, but don't know how to reference
an entire block of cells.

Can someone help. Thanks

 

[GJones]

-----Original Message-----
I want to add values to one worksheet but I want them to
show up in another worksheet within the same workbook. I
can do individual cells, but don't know how to reference
an entire block of cells.

Can someone help. Thanks
.
Select the range, Copy the range, slect the other sheet,

select the top left cell for the range in the second
sheet,click Edit, Paste Special, then paste link the range
from the first sheet into the second one. Any data in the
first will dynamically appear in the second

 

[dianah]

Thank you so much. I figured it was easy. Like I said, I
figured out how to do for one cell, but not for a large
range. Thanks again.
Diana