Is it possible to automatically pull data from a main inventory that has not been inspected.
I have a google sheet with 2 tabs.
View 1. Is main inventory of vehicles that is always changing (deleting sold and adding new)
View 2. is vehicles I have inspected pulling from view 1
Is it possible to automatically pull data from view 1 to view2 that his not showing in view 2
Say vin # is showing on tab1 but not tab2…auto add or some type of formatting on tab1 to know what still needs to be inspected.
Keep in mind view 1 is only main inventory data and doesn’t have inspection data on sheet since order always changes do to adds and deletes from google sheet