Hello All,
I've come across a situation where I've 5 sheets(Sheets 1,2..5) having personal data records like name, location, occupation, etc. for 5 different entities. All of these are collated in a master record spreadsheet (Sheet Master).
Is there any way in which i can link these sheets together such that if i change a cell of a record in sheet 2, it should reflect the same in Master Record Sheet and vice versa?
Thank you
Bookmarks