firstly I know this is my second post and do not know if this is macro, vba, or function question. Hence why it is in both forums.
So, I have an problem where I am trying to find a way to show certain fields on a second sheet where the fields shows are based upon a response on sheet 1 in a data validation selection. Attached to this is the sample sheet to help people with the issue. I would like only the numbered boxes on sheet two that have the same numbered box with a yes response to show up on the second sheet.
This sheet should be a dynamic sheet that updates as the drop downs are selected. Also I would like for no blank spaces to appear between the fields on the second sheet.
Thank you so much for your help!
test.xlsm
Bookmarks