Results 1 to 2 of 2

Populating cells based on growing list of names.

Threaded View

  1. #1
    Registered User
    Join Date
    01-17-2004
    Location
    Jersey
    Posts
    26

    Populating cells based on growing list of names.

    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.
    Attached Files Attached Files
    Last edited by rxwillow; 04-18-2008 at 02:10 PM. Reason: Attached file

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1