Advanced Cell Linking Capabilities?

Sarah Palmer

When we list our monthly marketing promotions (what's new, what's on sale, what's exclusive) in our Marketing Master Plan, we link those cells to other sheets where it would be useful to have that data on hand (for copywriting, graphics design, email plan, etc).

 

Only problem is that if something gets added at last minute (i.e. if a vendor lets us know on the first day of the month, "oh by the way, we're having a sale this month"), the new row we add to the Master Plan doesn't get picked up by the other sheets with linked cells. We have to go to all of the sheets and add new linked cells.

 

It would be fantastic to be able to link a region of cells between sheets - one that automatically identifies that a new row has been added within that region and adds that row to a linked region on other corresponding sheets.

 

Is there currently a way to do this?

Jim Hook

I think you can do exactly what you want since you can link a range of cells from one sheet to another in a single operation. Both sheets would need to have the same area though. On the sheet that nees the incoming links, select an area and then right click on Link from Cell in Another Sheet. When the popup window opens, select the sheet you want to link from then select the area you want to link and then create link. You have to premediate all the links you need to have but that's usually not a problem since you can indent all the incoming links below a total row and sum all the incoming data for a simple display.

JamesR

Sarah and Jim,

Just bear in mind thats OK is you are entering the new data into the sheets directly.

 

If you are using a Web form then it will enter the data either at the top of the sheet or the bottom of the sheet(default) and will treat the empty rows with linked cells as existing records therefor will place then under them and therefore will not be linked.