All-
Please help! I need to write a macro that will allow me to automatically populate a list from another list. I want to use the attached workbook to manually enter items into my "purchase order log" and once I change the status of "item received?" column to "YES," I would like that row (whatever line item it might be) to automatically become a line item on the "receiver log" tab.
Please see attached spreadsheet and offer some advice.
Thanks!
Bookmarks