Assign NAMES to cells based on another cell

[Barkster]

Hi.

I have a list of account names in column A and values alongside in Column B (its a Trial Balance for the accounting fraternity) and I want to NAME each number cell in column B but using the text contained in column A as the name.

Is this possible ?

And is it possible to name all the cells in one go rather than having to do them one at a time ?

I've attached a file showing the spreadsheet

Many thanks

[#2 · Accepted solution]

@Barkster 

Here is step by step instruction https://www.engineerexcel.com/name-multiple-cells-quickly-using-create-selection/