Hi rdwj, i have tried the auto filter and used the custom version to create
what it should look like. yes 6 columns, I want to click on the category and
just how that one category with all the questions and answers. e.g
category question response
Anti-money lndrg policies 1. Does Vendor.. If yes,...
""" "" 2. Are all... If yes,...
Business Ethics 1. Can we... No, ...
"" "" 2. We can... yes....
""" "" 3. We should... We can..
Through filtering, it looks like the above, I thought of something else. If
number the category 1 through 25, I want to list all the questions under
Category 1 not everything. can that be done? I am sorry, I am not sure how
else to explain it.