Populate worksheets from master worksheet based on column contents

TJ2020

New member
Joined
Nov 20, 2020
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2013
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:

QuestionReferenceRevisionColorDogsCatsRodents
Question 1Manual reference is 11Redx
Question 2Manual reference is 22Bluexx
Question 3Manual reference is 33Greenx
Question 4Manual reference is 44Pinkx
Question 5Manual reference is 55Yellowx
Question 6Manual reference is 66Purplex
Question 7Manual reference is 77Orangexx
Question 8Manual reference is 88Blackx
Question 9Manual reference is 99Whitex

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:
QuestionReferenceColor
Question 2Manual reference is 2Blue
Question 6Manual reference is 6Purple
Question 7Manual reference is 7Orange

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:
I figured out how to do it with a pivot table so never mind... ;)
 
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.
 
Back
Top