3D Reference in Excel
You can create formula in excel that get data from multiple worksheets without having to specifically reference each sheet by using 3D references. In the example above all the values in C3 will be added together from each sheet from Holiday1 to Holiday3. No matter what the sheets are called, if they sit between Holiday1 […]