Hi, Im trying to make a shared spreadsheet (on Teams), and my idea is that it will be a waiting list for trucks to come and load product at our site. As trucks call the loading gate, the operator will enter the truckers name and number into seperate columns in the spreadsheet, and fill in further truckers below. Once a trucker enters however, their information would be deleted from the spreadsheet and the lower cells would shift up to fill in the blank space, so the spreadhseet doesnt get cluttered with old information. Unfortunately I have no idea how this would be accomplished, as my experience with Excel is fairly limited. Does anyone have an idea on how I could accomplish this?
