Mac Numbers Using One Table To Edit Another

25 Views Asked by At

It seems like something that should be simple, and it probably is but my mind is being dense and not helping me. I have two Tables in a sheet on Numbers. The first acts as a master list of titles, and the second acts as a list of titles used. I simply want a way to remove everything that has been used from the master list so that the first table no longer contains them. Can someone help me with a script or simple way to do this?

Have tried scripts when I had this both on one table:

tell application "Numbers"
    activate
    tell front document
        tell sheet 1
            set masterList to value of cells of column "B"
            set usedList to value of cells of column "C"
            
            repeat with i from (count of masterList) to 1 by -1
                set masterItem to item i of masterList
                if masterItem is in usedList then
                    delete cell i of column "B"
                end if
            end repeat
            
        end tell
    end tell
end tell
0

There are 0 best solutions below