Results 1 to 3 of 3

Thread: Populate worksheets from master worksheet based on column contents

  1. #1
    Neophyte TJ2020's Avatar
    Join Date
    Nov 2020
    Posts
    2
    Articles
    0
    Excel Version
    2013

    Populate worksheets from master worksheet based on column contents



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there! I have a master question bank and I want to create auto populated work sheets based on contents of columns in the master sheet. So as an example, this is the master question bank:

    Question Reference Revision Color Dogs Cats Rodents
    Question 1 Manual reference is 1 1 Red x
    Question 2 Manual reference is 2 2 Blue x x
    Question 3 Manual reference is 3 3 Green x
    Question 4 Manual reference is 4 4 Pink x
    Question 5 Manual reference is 5 5 Yellow x
    Question 6 Manual reference is 6 6 Purple x
    Question 7 Manual reference is 7 7 Orange x x
    Question 8 Manual reference is 8 8 Black x
    Question 9 Manual reference is 9 9 White x

    Consider it starts at column A and ends at G. I'm going to have a worksheet for each animal column (so worksheets called Dogs, Cats and Rodents). Each worksheet should be populated based on the x in the dogs, cats or rodents columns. But the trick is, I only want the cell contents of columns A, B and D in the worksheets. So the Dogs worksheet would look like this:
    Question Reference Color
    Question 2 Manual reference is 2 Blue
    Question 6 Manual reference is 6 Purple
    Question 7 Manual reference is 7 Orange

    Do I need to run a macro, or can it be a VLOOKUP. Some of the worksheets will have more rows than others so I'd need it set up so it doesn't have error messages or zeroes etc. I'm not sure how to make this happen. Any help is greatly appreciated.

    Thanks in advance.
    Last edited by TJ2020; 2020-11-20 at 01:47 AM.

  2. #2
    Neophyte TJ2020's Avatar
    Join Date
    Nov 2020
    Posts
    2
    Articles
    0
    Excel Version
    2013
    I figured out how to do it with a pivot table so never mind...

  3. #3
    Seeker RET's Avatar
    Join Date
    Nov 2020
    Location
    Spain
    Posts
    10
    Articles
    0
    Excel Version
    2019
    A pivot table would work. If not, you need to have a macro as with VLOOPUP you do not kown how many rows will have each sheet.

Tags for this Thread

Posting Permissions

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