0

Hi I need some help with my work sheet. I have to build a dynamic questionnaire and I need to have a code that allow me to hide/ Unhide automatically some rows base on a cell information. Example:

if c6 is "internally" then show me row 7 but hide 8 to 107

if c6 is "Externally" then hide all the rows from 7 to 107

if c7 is "yes" then show me row 8 but hide 9 to 107

if c7 is "No" then show me row 8 but hide 9 to 107

if c8 is "Critical" then show me row 9 but hide 10 to 107

if c8 is "Important" show me row 9 but hide 10 to 107

if c8 is "Ordinary" show me row 9 but hide 10 to 107

if c8 is "Other" then show me row 9 but hide 10 to 107

if c9 is "Critical" then show me row 10 but hide 11 to 107

if c9 is "Important" then show me row 10 but hide 11 to 107

if c9 is "Ordinary" then show me row 10 but hide 11 to 107

if c9 is "Other" then show me row 10 but hide 11 to 107

etc.

can somebody help me?

  • Is this for Excel, OpenOffice Calc, LibreOffice Calc, or some other spreadsheet app? Please advise. – K7AAY Feb 14 at 17:23
  • Hi Deni, please correct your message with "then" instead of "than" and read your message again as there are some duplicates within your example sentences, making them painful to read. – OuzoPower Feb 14 at 17:39
  • Hi is for Excel – Deni Feb 14 at 17:47
  • Thank you modified – Deni Feb 14 at 17:47
  • What have you already tried in VBA? – harrymc Feb 14 at 17:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.