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:
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:
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.
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: