My mastersheet feeds 30 other worksheets and I want to be able to link particular cells from my mastersheet to the various worksheets, automatically i.e excel links them and I don’t have to manually link each cell to each sheet.
so that in what is in cell A2 of the mastersheet is linked to worksheet 1 and then automatically the information in cell A3 of the mastersheet is linked to worksheet 2 and so on.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment