Hide Rows based on Cell Value

[Shipwreck818]

Hello everyone. I need help and my macro ability is weak. I cn hard code easily but my Boss asked me for a special project.

I am a paralegal working in Fmaily law. I was taksed to (for now) create a use friendyl chart to decifer which law to use based on a date.

My excel sheet #2 holds teh formula per legal version, there are 7 in total.

I wantt o enter a date in Sheet2 B2. The date then in Sheet 1 chooses which legal version to use, then Shjeet 2 on B4 this info is shown. (side note if anyone has a macro to do what I just said I am open to suggestion).

Witht hat being said, each version is listed from rows 7 - 70. I would hope to hide each version when not in use and only presenting the cersion in question becuase of the date entered.

I only applied 2 versions in teh macro just to test and nothing happens. I saved my file as macro enabled so I am lost.

I hope this makes sense and thank you in advance for your time.


Sheet2

Sheet 1

 

[OaklandJim]

I can't promise that I can do this but I'll try. If not me then possibly other people who are more perceptive and/or are smarter about Excel.

If you want assistance you are more likely to get it if you help the helper, so they do not need to guess about or recreate your data.

Pictures are not very helpful. If the data is not confidential post a link to your workbook. If necessary you can enter fake-but-realistic data before providing the link. Put the file on Dropbox, Box, 1Drive, Google Drive etc. Use the link icon above the Mr Excel message area. Make sure that other people can access the file!

 

[Armstrong_N14]

How does Sheet 1 pick which version to use?