Is there any way in Excel to create single-cell named ranges from a combination of the labels in the rows and column of a spreadsheet.
Here is an example:
<tbody>
</tbody>
I would like the first cell (containing the 100) to have a defined name of (something like) “SalesCompanyA”, and the second cell to be “SalesCompanyB”. And so on – e.g. the cell with 300 in it should be “CostCompanyA”.
I can do it manually, but I have a huge spreadsheet & was hoping it could be automated. Just to be clear, it needs to be a single cell range. I know you can create a range from a selection – but this seems to create ranges of the entire row and/or column.
Many thanks
Bill
Here is an example:
CompanyA | CompanyB | CompanyC | CompanyD | |
Sales | 100 | 200 | ||
Cost | 300 | |||
Profit |
<tbody>
</tbody>
I would like the first cell (containing the 100) to have a defined name of (something like) “SalesCompanyA”, and the second cell to be “SalesCompanyB”. And so on – e.g. the cell with 300 in it should be “CostCompanyA”.
I can do it manually, but I have a huge spreadsheet & was hoping it could be automated. Just to be clear, it needs to be a single cell range. I know you can create a range from a selection – but this seems to create ranges of the entire row and/or column.
Many thanks
Bill