I'm attempting to put together a spreadsheet to help schedule our shop. My plan is to have a separate tab for each machine, have the user enter the job number under each machine, and use vlookup to auto-populate the job info. My sticking point is that the open order report changes daily as jobs are completed and new ones are added. I'd like to be able to compare the old open order list to the new one. In theory, that should tell me which jobs are gone (completeted) and need to be deleted from the sheet, and which jobs are new and need to be added to the schedule. Does anyone have ideas on the best way to accomplish this?