I have an excel spread sheet that has a column with a bunch of different invoice numbers. For everyone of these invoices, I need to have the "Finished" box checked off on the access form. Going through and doing it by hand creates problems, is there a way to automate this process. So that any invoice number in the column is automatically marked "finished" check box in the form (or table)?
What would be the easiest way to do this?