+ Reply to Thread
Results 1 to 3 of 3

Creating a new tab and filling in one column based on user responses

  1. #1
    Registered User
    Join Date
    02-09-2013
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    11

    Creating a new tab and filling in one column based on user responses

    Hello!

    I have a spreadsheet (attached) that has a "Project Build" tab and a "Template" tab. The "Project Build" tab has a list of typical project tasks in Column B, and a series of Check Boxes in Column A (beginning with Check Box 1). I would like to have a macro that will create a new tab (which is a copy of the "Template" tab) with the Project Number as the name, list the project tasks in Column E that were indicated by the user checking a box, and change Column N to "In Progress" for each row that has a task on the new sheet.

    If possible, I would also like the project to get listed in the "Project Directory" tab and then have the "Project Build" tab reset after the macro has been run (I will use a command button to run the Macro).

    Thank you very much for any help!
    New Project Build.xlsm

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,551

    Re: Creating a new tab and filling in one column based on user responses

    Heres a good start for you. You will need to get rid of all the extra checkboxes you have. I believe starting at task 5 on down you have double checkboxes in column A

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Registered User
    Join Date
    02-09-2013
    Location
    Toronto
    MS-Off Ver
    2010
    Posts
    11

    Re: Creating a new tab and filling in one column based on user responses

    Perfect! Thank you very much

+ 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