I am trying to name many cells in a spreadsheet so I can use those names in calculations on other worksheets within the same workbook. I've started naming the cell manually, but there must be an easier way. I've tried the Create from Selection option, but it doesn't give me the names I want.
For example, I clicked in cell B2 and named it RateSandy, which is the heading and value in column A. I did the same for cells E2 - P2 naming them JanAllocSandy - DecAllocSandy. is there an easier way to get the results I need?