Hi. I have a list of cell reference ranges and corresponding desired names. I have 100+ of these, but the attached example file only has 10 to simplify. Is there an efficient way to create named ranges based on these two columns, or do I have to create them one by one? Example file attached, and the list I am referencing is pasted below:
Name ACTUAL RANGE (Sheet & cell range)
NAME1 Sheet1!F3:H25
NAME2 Sheet1!A4:A75
NAME3 Sheet1!L29:L100
NAME4 Sheet2!Z5:AB100
NAME5 Sheet2!H15:H27
NAME6 Sheet2!BB15:BB45
NAME7 Sheet3!A10:B56
NAME8 Sheet3!F81:F100
NAME9 Sheet3!H8:H67
NAME10 Sheet4!A55:B70
Thanks for your help!
MV
Bookmarks