Dina has attended:
Excel Intermediate course
Linking Multiple sheets
doee the layout of the sheet you are trying to link have to be identical
RE: Linking Multiple sheets
Hello Dina, Thank you for your post and welcome to the forum, in answer to your question,
I am assuming that you are refering to the exercise on the Intermediate course where sheets are linked to create a 3D formula;
If this is the case then it is advisable to have the sheets consistent (the same) so that Excel will know that data in cell A3 on Sheet1 will be the same type of data on A3 in Sheet2, so that when you create a formula linking the sheets for example an =SUM( then the same data is going to be computed.
I hope that has helped, if so please click the resolved link, regards Pete