Nandu;
Here is the new file Relation_cells-7.xls
You can change the tab name of the worksheet from "My 2nd Example" to any thing you want.Also please let me know if this works when i change the name of the spreadsheet or worksheet "My example" etc to any other name, or the name of cell relation sheet.
Right mouse click on the sheet tab and select "Rename"
You cannot add another sheet yet. The How Cells are Linked sheet needs to be organized differently to handle a different sheet.
You can change the data on My 2nd Example (ctrl-a & ctrl-c from your sheet and ctrl-a & ctrl-v onto My 2nd Example).
You can also change the tab name of "How Cells as Linked" to anything you want.
Bookmarks