Formulas

Hi Nicki,

Thank you for your question and welcome to the forum.

You can link cells from one sheet to another sheet or link cells from one workbook to another.

There is an advanced technique called Array formulas that can be created and provide answers to a range of cells.

Regards

Simon