Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses london - Macros to link workbooks

microsoft excel courses london - Macros to link workbooks

ResolvedVersion Standard

Tue 27 Feb 2007, 11:34 Delegate Jenny said...

Jenny has attended:
Excel Advanced course
Excel Intermediate course

Macros to link workbooks

Can a macro be used to pull in new monthly data from a number of workbooks into one master workbook?

Tue 27 Feb 2007, 15:06 Trainer Amanda said...

RE: Macros to link workbooks

Hi Jenny

Thanks for your question.

This is something you could do using a macro but it would be a rather complicated one. This would be the sort of thing that the Excel VBA course would cover.

thanks
Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

microsoft excel courses london - Macros to link workbooks

Macros to link workbooks

RE: Macros to link workbooks

Excel articles

Excel tip:

Display developer tab - Excel 2010