3D Reference in Excel
You can create formula in excel that gets data from multiple worksheets without having to specifically reference each sheet by using 3D references. Example of 3D reference: =sum(Holiday1:Holiday3!C3) 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, […]