Hi,

I was wondering if there was a way to format a spreadsheet I have so that when a name is selected from a list, the values associated with another name will be cleared from the cells. Can this be done only by recording a macros, or is there another way to do this?