excel training in london - Using a text worksheet name in a cell to be picked up as part of

Hi Louise,


Your request has a number of options. Excel has a number of features to generate summary information on a worksheet by selecting data from other worksheets in the same Workbook.

1. Name Ranges are good way of identifying specific ranges of cells in differing worksheets to be used in calculations

2. Excel has routine called 3D Referencing that allows calculations to be performed across multiple worksheets and summarised in another

3. Excel also has routine called Consolidate that allows calculations to be performed across multiple worksheets and summarised in another

These are all useful for creating summary sheets for worksheets that have the same layout

Regards