Hello all
Is there a way, in a worksheet of one workbook, to have links to a an entire worksheet in another workbook so that work in the source updates the one with the links? Now, I've done it many times where I make a simple cell reference to one cell in the source sheet and copy things from there but I'm hoping there's a more elegant way to do this. With the individual cell reference method, I lose formatting and have to manually do that. Format Painter helps with that but is there a more efficient way. In other words, a function that would basically be an "insert remote worksheet link" one.
Thanks in advance for any help offered.
Is there a way, in a worksheet of one workbook, to have links to a an entire worksheet in another workbook so that work in the source updates the one with the links? Now, I've done it many times where I make a simple cell reference to one cell in the source sheet and copy things from there but I'm hoping there's a more elegant way to do this. With the individual cell reference method, I lose formatting and have to manually do that. Format Painter helps with that but is there a more efficient way. In other words, a function that would basically be an "insert remote worksheet link" one.
Thanks in advance for any help offered.
