Am I Correct in Using a Named Range to Insert Multiple Cells?
Posted on 2015-01-04
I have a text label in cell A1 followed by numbers in B1, B2, B3 and B4. I have named this range of cells (RangeName). I want to be able to simply type the label name and have the label and its associated numbers inserted into cells in another sheet of the same workbook.
I thought this could be done by naming the range. However, if I enter +RangeName or =RangeName in a cell in another sheet, I get a value error (#VALUE!). If I enter either phrase on the sheet containing the range, I get a number that doesn't seem to relate to the numbers in the range.
Am I incorrect in trying to use a range name to accomplish what I want, which is to type the label name and have it and the numbers inserted into separate cells? If I cannot accomplish this with a named range, is there another way to do this?