Hello,
I am trying to create a named cell range based on the value within a range i.e. if in cell range a1:a20 cells contain the text of J.K.Rowling they will be part of a named range called Author.
Is that possible, either through named ranges or VBA?
Thanks
Z
Bookmarks