How to link appended cells /row in source sheet to destination sheet

Sonali Senbardhan

Hi,

 

I have ben able to learn how to link cells from source sheets to destination sheets and observed auto refresh in destination sheetfor teh cells linked already.

My query is, if additional cells/rows are appended in source sheets ( quite possible), what is the way to get these also automatically refreshed/refklected in destination sheet?

 

Kindly answer.

 

Cheers!

Sonali

J. Craig Williams

Sonali,

 

I belive this has to be done manually. I'm hard-pressed to imagine otherwise from a design and implementation standpoint, but it is early and I haven't had my first cup of coffee yet.

 

To do so would require the structure of two sheets to somehow be linked or fixed in either length (rows) or width (colums) or both. And there is nothing that says the cells linked from are in the same order as the sheet they are linked to. 

 

You can copy-paste-special to copy links, but 

1. Select Links to Copied Cells to create cell links to the copied cells. This option will only be available if you’re pasting into a separate sheet than the one you’ve copied from, you have the appropriate sharing permissions, and you’re pasting into a column that allows cell links.

 

so maybe there is a feature request lurking there.

 

You can create links for multiple cells at the same time, so at least if your data is in the same order it won't be so tedious.

I would suggest setting up an alert when the sheet changes. I don't see a quick way to get an alert on new rows. Maybe that is also a feature request.

 

I might of course be wrong and I'll learn something cool.

 

Craig

Jeremy Michels

I do this manualy. I do as was mentioned prior. I have the layout between sheets set to the same order and then we copy the entire column from sheet to sheet. The limit is 500 rows on this. It is a great way to clean up sheets and update them. Keep in mind you would never want to add any rows into the order. All rows would need to be added at the top or the bottom. 

 

J. Craig Williams

Also, depending on how often you do the manual update, if you have anyone with coding skills, you could likely automate this using the API.

 

At my last job, we were updating an existing sheet with data pulled from an Oracle database. It would update existing rows, highlight new rows, flag deleted rows, and  give the end-user a list of rows it could not resolve (which did not happen very often).

That was phase 1 and was built by an intern to our specs in a week or so (and he had to learn the API) . Phase II would have been to pull it automatically and periodically, but we did not get to it.

There's an app called Azuqua that would likely help but it costs $$ and I haven't had the opportunity to use it yet.

 

Google "xkcd: Is It Worth the Time?" or just go here: https://xkcd.com/1205/ to

whether automation will help.

 

Craig