vba excel - how do i link
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba excel - How do I link spreadsheets?

vba excel - How do I link spreadsheets?

resolvedResolved · Low Priority · Version Standard

Mon 12 Mar 2007, 16:16 replyReply Delegate Laura said...

Laura has attended:
Powerpoint Introduction course
Excel Introduction course

How do I link spreadsheets?

How do I link up several spreadsheets onto one?

For upcoming training course dates see: Pricing & availability

Mon 12 Mar 2007, 16:26 replyReply Trainer Richard said...

RE: How do I link spreadsheets?



Try this:

1. Select the cell you want to see the result in.
2. use a formula like

=Sheet2!B5+Sheet3!B5+Sheet4!B5

 

Excel tip:

Changing the Tab Colour of an Excel 2010 Worksheet

Did you know you could give the tabs in your worksheet different colours?

This is particularly useful when organizing all your worksheets relating to a particular period or year, for example.

Right click a tab
Select Tab Colour
And choose your favourite colour!

View all Excel hints and tips



Excel training
Course rating:
4.7 stars - based on 18023 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom