Well, the thing is that the sheet is going to constantly be updated
with items changed from "no" to "yes" so the copy and paste thing would
have to be done all the time. What I'm looking for is possibly either a
macro or a formula that will do it automatically.
Ken Johnson wrote:
Hi Patrick,

Will selecting the sold column then filtering it by going
Data|Filter|Autofilter then clicking the AutoFilter's down arrow and
selecting "Yes" from the list, then copying the Title column and
pasting into the breakdown sheet do?

Ken Johnson