linking multiple sheets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking Multiple sheets

Linking Multiple sheets

resolvedResolved · Medium Priority · Version 2003

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


 

Excel tip:

Quickly Adding New Worksheets

Want to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11

View all Excel hints and tips


Server loaded in 0.09 secs.