Combining or mirroring new information

[cweissinger]

I have updated data in one worksheet in a separate file that I would like to
update/incorporate to another worksheet. How do I accomplish this?
--
Christine

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...7-f9dcb8c1766f&dg=microsoft.public.excel.misc

 

[JP]

Depending on your worksheet setup and what you're trying to
accomplish, one way would be cell or range name references.

For example, if you had a data entry worksheet in one workbook, then
wanted to copy the information entered onto a summary sheet in another
workbook, you could create cell references that "point" specific cells
in the second workbook to cells in the first workbook. When those
cells are changed, the changes would be reflected in the second
workbook.

See http://office.microsoft.com/en-us/excel/HP101023431033.aspx for
assistance in creating cell references.

--JP