I have attached a workbook with 2 sheets. One sheet is a list of magazines that shows what magazines we have. Each magazine gets distributed around my office. When a person is done with it, they give it back to me and I choose someone else to give it to. The sheet has a grid of initials for each person and when I give them the magazine, I "x" out the box for that magazine under their initials.
Some people don't want to receive certain magazines so the 2nd sheet is a grid where they choose what they want to receive. Is there a way that I could link the blank boxes from the sheet where they choose what they want to the magazine list and automatcially "x" out that magazine?
To use a vlookup function would require me to type an equation in a box that I might have to populate later so i'm not sure if something in a module for that worksheet would be better.
I hope I just made sense.
Bookmarks