+ Reply to Thread
Results 1 to 2 of 2

Clicked checkbox shows worksheet name in another worksheet

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    6

    Clicked checkbox shows worksheet name in another worksheet

    I want to create a main sheet where I can view whether or not a member has paid or not for the registration form that I am making. So, say bob has paid, he would show up under the "Paid" column and Mike, who hasn't paid would show up under the "Not Paid"

    Here is the project I'm working on. I currently have 4 sheets but will soon expand to 100 when I input member data. Each sheet will be a member so the name of the sheet will be the members name. In the "template" sheet, I have a checkbox option set up for answering payment which you will see on the top right. I want to set up the checkbox to where if I click yes, the members name shows up under the "Paid" column in the "Payment" sheet and if clicked no, under the "Not Paid" I don't know if this is possible as I consider myself a rookie at this. I hope I am making sense.
    Attached Files Attached Files
    Last edited by ashen786; 09-19-2012 at 10:18 AM. Reason: Title not accurate

  2. #2
    Registered User
    Join Date
    09-12-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Create a main sheet to update and show a specific data if other sheets are changed

    Maybe I wasn't clear on what I was asking. Let me try being as simple and straightforward as possible.

    Attached to this is what I would like. I have 3 sheets. "Bob" "Paid" "Not Paid" In the Bob sheet, there is an option of either yes or no checkbox. What I would like to do is if I click the Yes checkbox, the worksheet name, in this case "Bob" to show up in the "Paid" worksheet and if the No checkbox is clicked, have it show up in the "Not Paid" sheet. Is this possible?
    Attached Files Attached Files

+ Reply to Thread

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