It doesn't work. It came back as Not Paid, but it was paid. If it is paid, it looks like the"PD WE 06-08-08". Also I forgot that sheet 2 can have multiple entries for each order. An example would be, for payroll 8-8 & 8-15, the order is listed as pending, then for payroll 8-22, it is listed as"PD WE 08-22-08". I only need the most recent entry listed on sheet 1.
Bookmarks