I'm not sure if this is possible. Does anyone know of a way to maintain two lists of data where items are added to to random locations within the first one and the second one always lists all items in alphabetical order ? (Without having to run anything to do it; i.e. with formulas and/or functions). Assume up to 300 items. There may be gaps of several rows of spaces in the first list, so it would have to be defined as going from row 1 to row 300, rather than by contiguous data. Thank you for any help.