Excel 3D Reference - easily reference data on another worksheet

A 3D reference in Excel is a simple method to pull data from another cell, another worksheet, or a range of worksheets. Changes in the source will reflect in the destination. You can use multiple functions when creating a 3D reference. Functions such as Sum, Average, Count, Counta, Max, and Min all work with a 3D reference.

Bookmarks/Chapters
0:00 Intro
0:20 Put in Time in Excel
1:25 3D reference
2:17 Update source

Examples of 3D references
=B2 changes in B2 will reflect in another cell.
=Monday!B2 reference the Monday worksheet. Changes in cell B2 on the Monday worksheet will update.
=Sum(East:West!B2) changes in the worksheets that start with East and go to West for cell B2 will reflect. We could have multiple worksheets between the East and West worksheets.

Keyboard shortcuts
CTRL + Shift + ; current time
CTRL + ; current date

#chrismenardtraining #msexcel #microsoftexcel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!