How best to link 3 columns from a mastersheet to a secondary sheet.
I've had a colleague come to me with a query about how best to link 2 sheets. Her enquiry includes a handy diagram:
I'm wondering if cell linking would be best bet here? I realise this would obviously require her to keep having to action this for the 3 columns in question, when a new row of data is entered but it would mean the data is pushed from the mastersheet to the secondary sheet.
Thank you in advance - any thoughts on this would be greatly appreciated.