hi there,

First thread to this forum

My issue is that I have a variance file that links to various other ranges in a different workbooks. Quite regularly I need to add in new lines at the bottom of these ranges (due to new personnel). Is it possible to get the linked range to automatically update when I add in lines to the original file?

Thanks in advance for any answers

Philip