linking a book to recognize inventory
Posted by n2aqua on November 20, 2000 6:27 PM
I need to show a "check off" system for inventory. When I list numbers as inventory, I need to link another book to mark a cell when it gets invoiced for ex: book1;cell A1 has 2001 in it when I invoice and in book2;cell A23, 2001 gets used and written to another book I want to have book1 cell B1 to mark to show it has been used. Can Excel recognize a number in another book and when it gets used mark it to the book it was first listed?