I have set up a Vlookup for a list of products produced in a manufacturing site. The vlookup is used to produce daily reports on the production of each product. Over the months, adding new products has been a simple enough process, being careful to update any reports which are linked with the Vlookup.

However, I now have a list of products which have been decommissioned. I am faced with the problem of trying to remove the old products from the original list. (or the source for the lookup). However, if I do so, any cells in the report which are linked to the cell which has been removed all produce a REF warning.

Is there anyway I can remove cells from the source list, and simultaneously remove any cells which are linked to them. A further complication is that I don't want to remove these products from previous reports, just future ones.