Hi,



I have a table called Equipment Tracker that lists all of the equipment I have and one of the columns is Repair Status with the options of Good, Watch, Needs Service. I would like the equipment to automatically populate into a Repair Tracker table if the Repair Status is Watch or Needs Service. I can do it using FILTER but need to also be able to add additional information into the Repair Tracker table such as quotes, anticipated return date, etc. without the data becoming mismatched as it is updated. Is this possible? I cannot use VBA due to system constraints.