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

excel vba training - consolidate

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba training - Consolidate

excel vba training - Consolidate

ResolvedVersion Standard

Julie has attended:
Excel Intermediate course

Consolidate

how do I consolidate data

RE: Consolidate

Hi Julie

Thanks for your question.

You can consolidate data from several sheets using the Data - Consolidate command. This normally works best when each sheet has the same row and column headings for the data.

Amanda

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.2 secs.