Consolidating data

Hi Samantha

Thank you for your question. You could create a data range by highlighting a block of cells then from the Data ribbon choosing Name a Range then from the menu choosing Name a Range once more.

The dialogue box that appears will let you give your range of data a name. Alternatively if you highlight a column or row of data and include a label in your highlight choose the Create option and tell Excel when prompted where to find your labels (eg Top or Left). Excel will create ranges and name them based on the labels you highlighted.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew