Linking a Column to a masterfile with automatic updates
I am creating a solution where I have linked a column on a sheet(Sheet 1) to a column in a 'masterdata' sheet using 'Link from Cell' function in Sheet 1 to the masterdata sheet.
I want to be able to update the masterdata column ......and sheet1 to be automatically updated for any changes in the linked column.... this is not happening. Please help.
Help Article Resources
Check out the Formula Handbook template!