Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking Multiple sheets
Resolved · Medium Priority · Version 2003
Dina has attended:
Excel Intermediate course
doee the layout of the sheet you are trying to link have to be identical
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
|
Excel tip:Quickly Adding New WorksheetsWant to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11 |
We'll call during UK business hours
Server loaded in 0.09 secs.