update a worksheet thru a link

  • Thread starter Thread starter yh73090
  • Start date Start date
Y

yh73090

I would like to enter changes to sheet1 and have sheet2 (which is
carbon copy) update as I enter the changes.

Is this possible?

Thank you for any help or direction.

Y
 
Hi Yo!

I've named the data entry sheet Data Entry Sheet.

The syntax for referencing a cell in another sheet is:

='Data Entry Sheet'!A1

Note the placing of the '

You can then copy down and across as needed for changes in the Summary
Sheet to be reflected in the sheet with the formula.
 
You can "Group" the sheets, which means that *any* changes made to one, will
be duplicated in the other.

Hold down <Ctrl>, and click on the "other" sheet tab.
Both tabs are now "white", with the main focus sheet tab in BOLD.

Make the necessary revisions, then "Ungroup" the sheets by either clicking
in any sheet tab no included in the group, or right clicking in one of the
"grouped" tabs, and choosing "UngroupSheets".
 
Back
Top